Job Description for MS SQL
1. Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
2. Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
3. Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations
4. Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
5. Refine and automate regular processes, track issues, and document changes
6. Assist developers with complex query tuning and schema refinement.
7. Provide 24×7 support for critical production systems.
8. Perform scheduled maintenance and support release deployment activities after hours.
9. Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
10. Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
11. Experience with backups, restores and recovery models
12. Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
13. Experience in managing the PaaS and SQL MI Instances.
14. Configuring and troubleshoot the issue related to AOG.
Job Description for Postgress
1. Install, configure, and upgrade PostgreSQL database software and related tools.
2. Design and implement backup and recovery strategies to ensure data integrity and availability.
3. Monitor and tune database performance to optimize query execution and improve overall system efficiency.
4. Perform database capacity planning and resource management to ensure scalability and high availability.
5. Manage database security, including user access control, authentication, and data encryption.
6. Collaborate with development teams to design, implement, and optimize database schemas and queries.
7. Troubleshoot and resolve database-related issues, including performance bottlenecks, data corruption, and system failures.
8. Implement and maintain database replication, clustering, and high-availability solutions.
9. Develop and maintain documentation, including database design, installation procedures, and configuration details.
10. Stay up-to-date with the latest PostgreSQL features, technologies, and best practices.