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