Staff Software Engineer

Job Description Summary

As a Database Administrator is responsible for the Maintenance, Migration, performance, integrity, security and fine tune of a database to operate securely and efficiently.

Job Description

• Job Description:
• As a Database Administrator is responsible for the Maintenance, Migration, performance, integrity, security and fine tune of a database to operate securely and efficiently.
• Database Monitoring involves overseeing the performance and availability of databases to ensure optimal operation and timely identification of issues or bottlenecks.
• PL/SQL (Procedural Language/Structured Query Language) developers specialize in writing and optimizing PL/SQL code within relational databases preferably in Postgres and SQL Server . They work closely with application developers, database administrators, and users to create efficient and scalable database applications.
• SQL (Structured Query Language) developers focus on writing and optimizing SQL queries for database applications. They work closely with database administrators and application developers to ensure efficient data retrieval and manipulation. They should be able to review or help in writing complex SQL queries to improve the performance of the system.
• As a Database Administrator is responsible to perform complex DB migration activities based on customer requirements/needs where as high volumes of data have to be migrated more aligned to business/domain use cases.
• Preferably having AWS knowledge in on boarding relational databases, configuring monitoring rules, taking proactive decisions in fine tuning DB capacity to ensure zero down time.
• Key Responsibilities:
• Creating and modifying databases, including tables, indexes, views and DB Partitions.
• Monitoring and optimizing database performance through tuning and indexing.
• Installing and upgrading the database server and application tools.
• Allocating system storage and planning future storage requirements.
• Performing periodic backups and ensuring data recoverability during disaster.
• Troubleshooting and resolving database and SQL problems.
• Implementing and managing database replication, clustering, and high availability solutions.
• Planning for and executing database capacity planning.
• Ensured to follow release process and be agile in DB migration activities.
• Responsible to come up DB scripts to be required to migrate large volumes of data with entities across multiple databases/schemas.
• Developing and maintaining documentation and operating procedures.
• Writing and optimizing PL/SQL code for various database procedures, functions, triggers, and packages.
• Developing and maintaining database stored procedures and scripts to support application development.
• Optimizing SQL queries for performance and scalability.
• Collaborating with developers to integrate PL/SQL code with application logic.
• Writing and optimizing SQL queries for data retrieval, manipulation, and reporting.
• Developing and maintaining database views, stored procedures, and functions.
• Ensuring SQL code meets performance and scalability requirements.
• Debugging and troubleshooting SQL code issues independently and sometimes with application developer.
• Monitoring database performance metrics such as CPU usage, memory usage, and disk utilization.
• Setting up and configuring monitoring tools to track database performance and health, preferably through AWS console.
• Analysing monitoring data to identify performance trends and potential issues.
• Generating alerts and notifications for critical database events or performance thresholds.
• Conducting regular health checks and performance tuning activities.
• Developing and maintaining monitoring dashboards and reports.
• Implementing and maintaining backup and recovery monitoring processes.

Additional Information

Relocation Assistance Provided: Yes