SQL Server DBA/Developer
- New Delhi, DL, India
sql server 2016
Job Posted: Thursday, March 22, 2018
Expires On: Saturday, April 21, 2018
Job Type: Permanent
Duration: 1+ years
Desired Experience: 3-5 years
Work Authorization: Citizen
We are looking for a stellar SQL Server DBA/Developer to work on exciting problems and create industry leading solutions that meet the highest standards in security, quality, and user experience.
We are a small team led by an engineering director and collaborate closely with product management and design to build new products and create new businesses in a fast paced, LEAN and AGILE fashion.
Essential Functions of the Job:
Responsible for creation and ongoing maintenance of functional and relational Database Diagrams for all Network Services SQL Databases.
Keep diagrams/documentation current and establish effective vehicles to publish the documentation to IT Staff and others for use in report development and IT Projects.
Ability to write and troubleshoot complex Stored Procedures, T-SQL queries and scripts, and document processes and procedures.
Experience implementing operational automation.
Perform all common periodic Database Administration (DBA) tasks, including managing database backups and recovery, managing database users and security, Database Server Administration, Event and System Monitoring, etc.
Design database indexing schemes and perform optimal DB tuning
Ability to detect and troubleshoot SQL server related CPU, Memory, I/0, disk space and other resource contention.
Periodic review of all database Maintenance, Backup, and Optimization plans. Recommend improvements to support use of database best practices, more efficient processing, improved system uptime, and to support the growth of the business.
Periodic review of all current SQL servers from a security (Windows and SQL) standpoint. Review industry best practices and make periodic recommendations for Database security and Windows server related security improvements.
Ability to export and import data from/to various formats like delimited raw/text file, MS-Excel, XML, SQL Server, MS-Access, etc. Ability to transfer data between various servers and/or data sources. Ability to restore databases and individual tables upon request.
Provide leadership, architectural recommendations and implementation plans for potential long term database scalability, performance improvements, and support for a hybrid infrastructure.
Perform troubleshooting, resolution and root cause analysis for database and application specific incidents.
Knowledge and Skills Requirements:
Strong overall knowledge of SQL Server 2016
Strong knowledge of running SQL Server on RDS
Working knowledge of SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, Database Engine Tuning Advisor, BCP and Bulk Load
Experience in data migrations, data manipulation, and reporting for end user consumption
Experience in full development life cycle process using LEAN and AGILE methodologies
Excellent written and verbal skills, can do attitude, dedicated troubleshooting efforts, ability to work independently and manage multiple projects.
Minimum 4 years working experience with SQL server, including responsibilities as a SQL database developer and also as a SQL DBA (or with most DBA responsibilities)
B.S./MS/PhD in Computer Science or related field
Shift Timings: 12 noon - 9 pm
Working Days: 5 (Monday - Friday)
(Sat & Sun fixed off)
Location - Delhi
[Note: Candidates MUST be from Delhi location or willing to relocate]