DBA(MySQL and AWS)

Senior Cloud Operations Database Engineer

JOB DESCRIPTION

Summary/objective

We are looking for an exceptional and driven Senior Cloud Operations Database Engineer to join a growing team. This position will report directly to the Sr. Manager of Cloud Operations and will be located in Pune, India.

· Administer multiple databases in AWS RDS and locally on Linux and Windows systems including MySQL and MS-SQL (Oracle a plus)

· Backup and restore databases

· Configure databases for scaling and high availability

· Manage database storage

· Implement and manage database monitoring and alerting

· Design and implement new databases and refactor existing databases

· Maintains scripts and queries in source control

· Database requirements gathering and validation

· Coordinates with subject matter experts to obtain and verify data for new and existing database

· Develops and performs structured queries as needed; designs, develops, modifies and generates specific reports upon request creates tables, queries, and forms; and provides hard copies as requested

· Creates and maintains documentation or users' guides for each database and trains designated personnel on use of databases, as needed

· Designs with database security by controlling database access permissions and privileges

· Coordinates scheduled maintenance

· Implement standard / best practice database security measures

· Performance tuning, including creating indexes, optimizing caching, monitoring, and tuning queries.

· Expected to be available during SEV1 outages (as a 3rd level escalation)

· Maintain the security and privacy of ETQ’s information assets.

What you need to succeed

· 5-7 years hands-on experience with all of the above

· BS. degree in a technical disciple (Computer Science or similar)

· Experience in database performance tuning (running traces, implementing indexes, optimizing queries, optimizing databases overall)

· ETL, Excel and BI tools experience

· Experience with Amazon Web Services (AWS)

· Strong attention to detail as well as analytical and problem-solving skills.

· Proactive/Independent thinker who is adaptable to evolving customer requirements and direction

· Experience administering, optimizing, and creating database systems in AWS, Linux, and Windows

· Experience monitoring databases and with database monitoring tools

· Solid Windows and Linux administration experience

· Network knowledge

· Excellent customer facing skills, meeting customers, and handling their requests

· Strong analysis and troubleshooting skills and experience

· Self-starter: able to take minimal direction and still know where to end up

Above and beyond

· Experience with data lakes

· Experience with Snowflake

· Certifications (AWS, MySQL, MS-SQL)

· Experience in IT standards such as ITIL, PCI or ISO 27001.

· Experience in working in a ticket driven environment as well as handling project tasks via a SCRUM based model