SQL DBA

Responsible for all functions associated with the design, implementation and maintenance of SQL Server databases including security, back-up, logging, reporting and recovery procedures



Manage all technical aspects of the databases and processes



Troubleshoot SQL Server service outages as they occur, including after-hours and weekends



Transform data via standardization, cleaning, data repair, matching, and de-duping



Manage data from multiple sources including internal, external, and 3rd party data



Assist in maintaining and improving database operational efficiency



Perform daily, weekly, and monthly data maintenance tasks



Assist in developing feeds to Data Warehouse, Marts and data management processes



Tuning SQL queries to improve performance



Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO)



Test backups to ensure we can meet the business' Recovery Time Objectives (RTO)



Configure SQL Server monitoring utilities to minimize false alarms



When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes



Configure SQL Server instances, high availability (Mirroring, Always ON) and patching of these instances.



Troubleshoot issues related to SQL Server infrastructure (Patching, High availability etc.)







Preferred Skills:







Design, test, implement and maintain complex databases with the required organization, access methods, access time, validation checks and security to meet or exceed requirements
Develop, edit and maintain required documentation.



Proactively evaluate, recommend and perform database upgrades and changes
Perform system optimization and improvement planning including, but not limited to, database performance analysis, capacity planning and system sizing
Stay abreast of and recommend improvements in technology and methodology to meet changing business needs and market demands, as well as provide for overall optimization of database administration function.



Pro-actively monitor the performance of development and production databases to detect existing or potential incidents and/or performance issues.



Perform tuning and maintenance to correct and prevent unplanned downtime or performance degradation
Ensure operation of database environments meet or exceed agreed upon service levels (e.g
availability and performance).



Plan, schedule and manage the implementation of new databases and modifications to existing databases in a manner that avoids disruption to production and development systems
Set-up and manage database security, manage data purging/archiving activity and other day-to-day database administration activities.



Provide ongoing support to operations and support teams as needed
Escalate and manage escalated issues as appropriate.



Thorough knowledge of SQL Server configuration, High availability configuration, setting up the environment



































Required Qualifications:







5+ years of technology experience of increasing scope and responsibility (e.g
software development, database) expertise in SQL Server 2005, 2008, 2012,2014



Experience with database design, administration and maintenance in distributed environments.



Experience in troubleshooting and resolving database issues, including performance tuning and capacity planning.



Proven expertise in database design, to include solid understanding of related programming languages, clustering, back-up/restore technologies, replication and security.



Proven understanding of SQL coding required to understand performance implications and translate requirements to application developers.



Expertise in SQL Server installations and High availability configuration



Expertise in SQL Server patching and troubleshooting



Expertise in SQL Server Upgradation







Preferred Qualification:







Strong working knowledge of industry-standards database management tools.



Demonstrated, successful experience working in a matrixed, multi-vendor technology environment.



Demonstrated ability to work effectively in urgent situations with high pressure and visibility.



Strong written and verbal communication skills.







Location: Gurgaon, India



Timings: 24x7



Cab Facility provided: Yes