JD (3-5 Years)
The Database Administrator is responsible for overall availability of databases and associated systems, using currently available commercial enterprise relational database management systems. The Database Engineer effectively uses database replication, security, and availability solutions in designing and implementing Database solutions. Must be able to use platform-specific, as well as enterprise, monitoring tools to provide fault and pre-fault performance notifications. Provides platform-specific performance tuning, installation and configuration guidance and expertise. Monitors and manages back-up and recovery, and capacity planning for all Database Platforms.
The candidate will exhibit strong leadership skills; will work effectively in a diverse highly, talented team; will continuously strive for excellence; and will be proficient in design and process definition and documentation.
1.In-depth experience and working knowledge of MySQL & PostGreSQL (8+, 9+) required along with deployment, administration, optimization & best practices
2.Experience working with both Linux and Windows servers required
3.Expert level in performance and query tuning
4.In depth knowledge of SQL, TSQL, and PL/SQL & high availability solutions.
5.Demonstrated experience with automation
6.Experience in designing and maintaining MySQL installations on bare-metals/cloud.
7.Experience with audit, regulatory, and/or SOX type compliance
8.Demonstrated experience with maintenance routines and ability to plan database maintenance
9.The candidate should be able to work independently as well as collaboratively in a team environment.
10.Strong experience in backup, restore, upgrade, migrate, and troubleshoot the databases.
11.Hands on with High availability architecture with hosted & on premise deployments
12.Hands-on with migration, disaster recovery architecture
13.Solid understanding of database design principals and managing the Schemas
14.Solid Database design skills, Schema/Table m