Data Base Administrator Job in Multi Recruit

Roles and Responsibility

• 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 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 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) Gelara 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 trouble shooting 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