Responsibilities
- Manage, monitor, and maintain Microsoft SQL Server databases hosted on Amazon RDS (Relational Database Service) and Oracle PL/SQL databases.
- Optimize SQL Server and Oracle PL/SQL performance, troubleshoot performance issues, and ensure efficient database operations.
- Implement and maintain database security measures, including access controls, encryption, and auditing, in accordance with best practices and compliance requirements.
- Develop and execute database backup and recovery strategies to ensure data integrity and availability.
- Keep SQL Server, Oracle PL/SQL, and AWS RDS instances up to date with the latest patches and updates.
- Scale database resources as needed to accommodate growth and changing workloads. Perform capacity planning to ensure resources are allocated appropriately.
- Set up monitoring and alerting systems to proactively identify and address database issues. Use AWS CloudWatch and other tools for monitoring.
- Implement automation scripts and workflows for routine database tasks and maintenance.
- Maintain detailed documentation of database configurations, procedures, and best practices.
- Collaborate with application developers, system administrators, and other teams to ensure seamless integration of databases into applications and infrastructure.
- Develop database objects like Packages, Stored Procedures, Database Links, Functions, Views / Materialized Views, Dynamic SQL, External tables, Exception handling, Triggers, Cursors, Ref Cursors, and other PLSQL objects.
- Experience in query optimization, performance tuning (PL/SQL) using SQL Trace, Explain Plan, Indexing, and table partitioning.
- Handle Oracle XML / JSON / CLOB data and work with large volumes like millions of rows, writing complex queries and performing tuning
- Experience working in Agile methodologies.
- Ability to work independently by interacting with clients from design to implementation.
