Staff DBA

ANSR Summit Consulting

Gurgaon, Haryana
Permanent
Full-time

28 days ago
Apply easily

About ANSR Summit ConsultingANSR is a market leader in enabling organizations to build, manage and scale global teams through Global Capability Centers (GCCs). We provide full life-cycle services including GCC design, set up and enabling operations. For over 18 years, companies cutting across size, industry and markets have relied on ANSR’s expertise to successfully build global business and technology teams. Since its inception, ANSR has established over 90 GCCs. Our experience spans across industries including retail/CPG, banking, insurance, travel & transportation, and healthcare. We operate in supply-rich locations like India, Central and Eastern Europe, South America, Canada, and Southeast Asia.Job DescriptionRole and Responsibilities:

Monitor and troubleshoot database instances.
Perform root-cause analysis in response to database environment events.
Identify opportunities for improved system performance and process improvements.
Perform code reviews, and assist teams across the organization with query optimization.
Modify and build automated environment installation and setup processes.
Serve as a SME for specific technical topics and team operations.
Architect database high availability and database backup and restore processes.
Review and execute data manipulation scripts created by internal and external team members.
Build external networks to help accomplish team and company objectives.
Contribute to other team efforts as needed to support day-to-day database operations.
Complete infrastructure planning, provisioning, and maintenance tasks to ensure the required resources are available for application functionality
Complete functionality reviews for services and technology that both internal and external teams want to use in the database environment.
Create and drive project solutions that are consistent with stated objectives and guidelines.
Provide guidance to other DBAs on technology topics.
Recommend new technologies and processes that can be used to manage database environments.
Participate in production support on-call rotation to triage and resolve critical issues outside of business hours.

Job Requirement :

8+ years of experience as a Database Administrator working with SQL Server 2017 or higher.
3+ years of experience configuring and maintaining AlwaysOn Availability Groups.
Bachelors degree in Computer Science or another related field, or equivalent. experience in IT related fields.
Strong knowledge of cloud computing computing concepts and infrastructure management.
Expert knowledge of common database administration tasks such as backup & restore, integrity checks, disaster recovery, and security.
Proven experience in performance tuning concepts.
Prior experience supporting database and application development teams.
Thorough knowledge reading and writing complex SQL scripts.
General knowledge reading and writing Powershell or other scripting technologies.
The ability to solve complex problems independently using analysis and research.
Strong communication (written and verbal) and collaboration skills, with the ability to provide technical input both internally and externally.
Strong critical thinking and analytical skills.
Experience working in a PCI/SOX, or other compliance regulated environment.
General knowledge of at least one other database technology.
Ability to work on-call rotation.

Preferred:

Masters degree in technology, engineering or related field
General knowledge of PostgreSQL
AWS RDS\Aurora PostgreSQL experience
IAC tools, (Terraform, AWS Cloudformation)

ANSR Summit Consulting