Data Base Administrator

Design, develop and manage data on various open-source SQL databases

End-to-end performance tuning of Oracle, MariaDB, MySQL, PostgreSQL, and Aurora against very large data sets

Database cluster connectivity and security

Conduct database training

Software installation and configuration

Database patching and upgrading

Using monitoring and management tools

Troubleshoot various issues with other dba’s/developers

Point of Contact for Vendor escalation

Point of Contact for professional service to Customers

Cross-platform migration from Oracle to MySQL/MariaDB/PostgreSQL/Aurora

Support the creation, maintenance, and implementation of procedures regarding how problems are identified, received, documented, distributed, and corrected

Ensures project documentation is complete, current, and stored appropriately

Manages day-to-day project and scope changes

Communicate and coordinate database changes, backups, and downtime to users

Identifies potential security issues and recommend strategies to ensure database security

Research and evaluate new technologies

Proactively monitor systems for optimum performance and capacity constraints

Establish standards and best practices for SQL

Interact with and coach developers in SQL scripting

Perform database backup and recovery

Provides 24x7 support for enterprise database systems

Secondary Functions

Must provide mentoring and training to other staff members

Write procedural documentation including requirements for databases

Develop and coordinate knowledge transfer

Establishes enterprise-wide uniform infrastructure, including supporting defined departmental content processes and creating guidelines for content deployment

Interacts with business units to gather, define, and organize the delivery of business solutions Data

Modeling, design & implementation based on established standards

Automate manual tasks

Who we have in mind:

Candidate with a college degree and relevant work experience

7+ years of hands-on DBA experience with Oracle, MySQL, MariaDB, and PostgreSQL and supporting tools

Strong experience with Linux is required, including command-line editors, scripting (shell, Python, Perl, etc.)

Experience in database performance tuning and strong SQL tuning skills

Experience in database and cross-platform upgrades required Experience in all aspects of the software development lifecycle including requirements gathering, design, coding, testing and production support

Must be familiar with RDBMS concepts, practices, and procedures

Must have knowledge of network connectivity

Extensive experience with Export/Import, Backup and Recovery

Extensive experience with Database Replication Master/Slave, Master/Master (BDR)

Extensive experience with MySQL (MariaDB, Percona) Galera cluster

Experience with MaxScale

Proficient in SQL Language

Knowledge of ServiceNow, or similar Ticket Management Software

Knowledge of SAN infrastructure including HP and NetApp

Ability to work on projects at a time

Knowledge of middle-tier application servers

Strong troubleshooting and problem resolution skills

Good knowledge of Data Modeling

Knowledge of XML and JDBC

It would be great if you had:

Experience of NoSQL databases (Cassandra, Oracle NoSQL, MongoDB) is a plus

Certifications on MySQL, PostgreSQL, and Aurora