Job Seekers, Please send resumes to resumes@hireitpeople.com

Detailed Job Description:

Sr Database Administrator - Job Description – PostgreSQL / MySQL / Maria DB The DBA will perform administration and engineering for multiple production databases, and will be responsible for fast-paced, complex distributed database environments supporting both OLTP and OLAP systems across multiple platforms. Work with Engineering / Development and CSS Operations teams to deliver and support new and existing PostgreSQL database systems. Help guide best practices in PostgreSQL database administration and introduce innovation with automation. Maintain an environment of dozens of PostgreSQL databases running in a Linux / Unix / Window environment. Responsible for providing day-to-day support and maintenance for existing and PostgreSQL databases. Design and build database solutions that are both highly available and highly performing. Assist in the administration, management, and monitoring of all PostgreSQL database systems. Accountable for proper backup and disaster recovery procedures. Good understanding of Database Architecture, Performance tuning of databases, pro-actively Identify bottlenecks and resolve them quickly. Update skills continuously with emerging technologies and apply them as and when needed. Work with developers on performance tuning, query optimization, index tuning. Very strong experience in replication, clustering, tuning, sizing and proactive monitoring. Actively work with developers to solve database / application issues without compromising database best practices and work with them to promote changes to production. Experience with PostgreSQL database systems and a desire to learn new database technologies. Support PostgreSQL database in external cloud and work with various cloud providers as required. Rotate with other DBAs to be on call to quickly fix issues that arise in our production and non-production environments. MySQL – Strong proficiency in MySQL database management Establish enterprise level infrastructure support environment for MySQL DBA Hands on Experience in setup, configuration, troubleshooting MySQL replication Handle common database procedures, such as upgrade, backup, recovery, migration, etc. Establish mechanisms for data backup/restore of relational databases and provide restoration services as needed Estimate MySQL database capacities; develop methods for monitoring database capacity and usage Resolve problems identified via Monitoring/Health Check Develop application-specific fault-tolerant distributed database mechanisms Database monitoring and Supporting in Production environment Hands On experience with relational database performance tuning Good knowledge of Day to Day commands of Linux/AIX Environments, Shell Scripting for configuring DB.

Minimum years of experience*: 8+

Interview Process (Is face to face required?) No