Database-Administrator-II

Gurgaon - India

Monthly Salary: Not Disclosed

Posted on: 9 hours ago

Vacancies: 1 Vacancy

Job Summary

Job overview and responsibilities

This position manages the engineering and administration of all on-prem SQL instances and databases including the security
availability performance and data protection for those databases. This position manages the off-hours patching and
deployments for all Tier 1 thru Tier 5 SQL and Couchbase databases. Additionally this position is responsible for AWS cloud
migrations support and deployments.
Off-hours support for all Tier1 Tier5 SQL Databases and Instances
Create physical database structures based on physical design for development test and production environments
Coordinate with systems engineers to configure servers for DBMS product installation and database creation
Install configure and maintain DBMS product software on database and application servers
Assist in the consultation to application development teams on DBMS product technical issues and techniques
Implement monitoring procedures to maximize availability and performance of the database while meeting defined
SLAs
Investigate troubleshoot and resolve database problems
Communicate the required downtime with the application development teams and systems engineers to implement
approved changes
Identify define and implement database backup / recovery and security strategies
Install and support of DBMS (Database Management Systems) software and tools
Perform various database activities which include monitoring tuning and troubleshooting with appropriate
supervision if required Review deployment for all SQL database changes
Complete pre-deployment code reviews with application teams as requested
Review and provide feedback on all SQL code updates
Work with deployment manages on dates and time for releases including assignments
Patching of all SQL Server and some Couchbase
Work with application teams to create schedule
Send advanced and timely notifications for database instances to be patched
Conduct database patching including any troubleshooting and validation post patching
Project management and engagements for database migration
Database Engineering Performance consultations
Work with applications teams on current and new features such as partitioning memory optimized tables Always-On
availability groups etc.
Provide diagnoses for performance issues
Tables and index reviews

Data Purging and job scheduling

Qualifications

Whats needed to succeed (Minimum Qualifications):
Bachelors degree or 4 years of relevant work experience in Computer Science Engineering or related discipline
7 years of experience
Proficient in SQL development and administration disciplines with current hands-on experience with the latest SQL
Server releases including SQL
Strong background and experience with all BC and DR capabilities of Microsoft SQL Server including Always-On
Mirroring Log Shipping and Clustering with a practical understanding of other Infrastructure BC/DC capabilities
Leverage metrics to drive capacity planning and trending to proactively identify potential problems and mitigate
before they result in customer impact
Understand the place of automation and standardization when delivering stable maintainable and performant
database services at scale
Perform platform database and query optimization
Must be legally authorized to work in India for any employer without sponsorship
Must be fluent in English (written and spoken)
Successful completion of interview required to meet job qualification
Reliable punctual attendance is an essential function of the position
What will help you propel from the pack (Preferred Qualifications):
Bachelors degree or 4 years of relevant work experience in Computer Science Engineering or related discipline
Microsoft SQL Server or AWS certification
Hands-On experience with AWS native databases compute storage monitoring technologies and continuous
integration pipelines
Experience implementing automation of Microsoft SQL Server deployment and maintenance and support activities
preferred
Collaborate both vertically and horizontally to evolve overall database services and technology strategies
Experience supporting SSAS SSIS and SSRS
Very large Database (10 TB) experience preferred
Experience with PowerShell or other scripting languages a plus
Experience with PCI SOC and SQL Auditing a plus

Job overview and responsibilities This position manages the engineering and administration of all on-prem SQL instances and databases including the security availability performance and data protection for those databases. This position manages the off-hours patching and deployments for all Tier 1 ...

Job overview and responsibilities