Database Support Engineer

Role & responsibilities

• Ensure optimal health, integrity, performance, and security of all databases.
• Develop and maintain data categorization and security standards.
• Develop and maintain data movement, archiving and purging scripts.
• Evaluate and recommend new database technologies and management tools; optimize existing and future technology investments to maximize returns.
• Provide day-to-day support to internal IT support groups, external partners, and customers as required.
• Manage outsourced database administration services to perform basic monitoring and administrative-level tasks as directed.
• Participate in change and problem management activities, root cause analysis, and development of knowledge articles to support the organizations program.
• Provide subject matter expertise to internal and external project teams, applications developers, and others as needed. Support application testing and production operations. Serve as database administration.
• Document, monitor, test, and adjust backup and recovery procedures to ensure important data is available in a disaster.
• Serve as on-call database administrator on a rotating basis.
• Develop, Implement, and Maintain MySQL, PostgreSQL, Mongo Instances including scripts for monitoring and maintenance of individual databases.
• File system management and monitoring
• Diligently teaming with the infrastructure, network, database, application and business intelligence teams to guarantee high data quality and availability

Preferred candidate profile

• Installation and Maintenance of MongoDB (sharded, replica).
• Should have deep understanding in mongodb clusters.
• Experienced in MongoDB upgradations and migrations.
• MySQL, PostgreSQL & knowledge on NoSQL.
• Backup and Recovering MySQL, PostgreSQL and other databases.

• User level Access: Risks & Threats.
• Synchronous and Asynchronous replication, converged systems, partitioning, and storage-as-a-service (cloud technologies)
• Linux operating systems, including shell and python scripting
• Windows Server operating system
• Industry-leading database monitoring tools and platforms
• Data integration techniques, platforms, and tools
• Modern database backup technologies and strategies