The primary responsibilities of this role include owning, tracking and resolving Microsoft SQL Server, PostgreSQL DB, MySQL and MongoDB instances and databases related issues.
This position involves with analyzing and setting up the infrastructure based on the project requirements. Reviewing service related reports (e.g. database backups, maintenance, and monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with the different teams to come up with strategic solutions on unknown issues.
This MS SQL Server DBA role requires a team centric service oriented mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues, establishing and maintaining communication with technology customers to keep them updated with the status of the requests, initiating and performing changes on production systems, and proactively escalating any issues that cannot be resolved within the established timeframes.
POSITION REQUIREMENTS:
• More than 5 years of experience in Database Administration for SQL Server (2008R2/2012/2014/2016/2017) in a multi-site enterprise environment.
• At least 5 years of hands-on experience in PostgreSQL & MySQL Database Administration/ Engineering
• Knowledge of MongoDB, SQL on Hadoop, SYBASE, Oracle is a big plus
• Must have experience on On-premise, AZURE IaaS, PaaS instances.
• Strong experience on analyzing and migrating the infrastructure (including the application and database instances) from On-premise to Azure cloud infrastructure.
• Must have experience on analyzing the infrastructure to set up the environments as per the defined project scope.
• Strong experience in troubleshooting and resolving SQL Server instances and related technologies integrations and database problems.
• Should be strong on analyzing the application and database connectivity issues including the drivers and protocols used.
• Must have experience configuring and managing SQL Server clusters, Availability Groups and Always On.
• Strong experience in Performance Tuning and Optimization (PTO) of SQL Server databases, using native monitoring and troubleshooting tools.
• Must have experience with backups, restores and recovery models for SQL Server.
• Must have experience with SQL Server Replication.
• Must have strong experience on security models (In-transit, data-at-rest, On-fly encryptions) based on data classifications.
• Strong experience on High Availability (HA) and Disaster Recovery (DR) options for SQL Server, including AlwaysOn Availability groups, SRM cluster etc.
• Must have experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Must have experience in implementing operational automation using scripts.
• Must have experience in how indexes are used, missing indexes, index management, type of fragmentations and st
Digital : Microsoft Azure, Digital : Amazon Web Service(AWS) Cloud Computing, PostgreSQL
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.