DME III / IV ( SQL DBA & NO SQL DBA ) Professional
Location
Secunderabad | India
Job description
- Responsible for creating, monitoring, and maintaining various databases - MySQL, Postgres, Oracle, Click House including NoSQL databases like Cassandra, Mongo DB, Scylla DB etc.
- Automating routine Database Administration, monitoring, and alerting activities using shell scripting, python, Perl etc.
- Providing DB design solutions, hands-on expert using SQL and other DB related tools.
- Providing solutions for Database High Availability (HA), Data Security, Governance, compliance measures etc.
What youll be responsible for
- Ensure optimal health, integrity, availability, performance, and security of all databases.
- Develop and maintain data categorization and security standards.
- 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 organization s program.
- 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 scenario.
- Serve as On-Call database administrator on a rotating basis.
- Develop, Implement, and Maintain MySQL, PostgreSQL, Mongo, Click House, Cassandra, Scylla DB and Oracle Instances including automated scripts for monitoring and maintenance of individual databases.
- Diligently teaming with the infrastructure, network, database, application, and business intelligence teams to guarantee high data quality and availability.
- Collaborating with various teams to install Database software updates, patches, version upgrades when required.
- Performance tuning of Databases, SQL Query tuning, optimizing database designs.
- Knowledge of schedulers - Cron, or any other new generation schedulers like Apache Airflow
- Provide subject matter expertise to internal and external project teams, applications developers, and others as needed. Support application testing and production operations.
- Responsible for implementation and ongoing administration of Data Pipelines
Qualification and other skills
- B.E./BTech/MCA from a premier institute
- 8-10 years of experience in managing enterprise databases
What youd have
- Expert on any three of the databases (covering minimum 1 from SQL and NoSQL database family each) - Oracle, MySQL, PostgreSQL, Click House DB NoSQL like Mongo DB, Cassandra, Scylla DB, Redis, Aerospike etc.
- Installing MySQL, PostgreSQL, Click House DB, Oracle , Cassandra, Scylla DB Mongo DB.
- Backup and Recovering Oracle, MySQL, Mongo DB, Click House DB Cassandra, Scylla DB and PostgreSQL databases.
- User level Access: Risks Threats.
- Synchronous and Asynchronous replication, converged systems, partitioning, and storage-as-a-service (cloud technologies)
- Linux operating systems (RHEL, Ubuntu, CentOS), including shell scripting.
- Windows Server operating system
- Industry-leading database monitoring tools and platforms
- Data integration techniques, platforms, and tools
- Modern database backup technologies and strategies
Job tags
Salary
