Oracle and SQL Database Administrator

Job Description:

Responsibilities:

• Install and configure new SQL databases on various platforms (physical, virtual, cloud).
• Set up database clusters, replication, and high availability solutions.
• Configure database parameters and optimize for performance.
• Perform regular database maintenance tasks such as vacuuming, analysing, and reindexing.
• Monitor database health and performance using various tools.
• Implement and maintain database security measures, including access control and encryption.
• Optimize SQL queries and database schema for improved efficiency.
• Regularly perform database backups and test recovery procedures.
• Manage disaster recovery plans and ensure business continuity.
• Troubleshoot database issues and provide timely solutions.
• Assist developers with database design and query optimization.
• Implement and maintain database security policies and procedures.
• Ensure compliance with relevant data privacy regulations (e.g., GDPR, HIPAA).
• Regularly audit database security and access controls.

Qualification and Skills Required :

• Minimum of 5+ years of Oracle, SQL database management systems in testing, implementation, maintenance and administration in a multiple platform environment.
• Upgrades of Oracle, SQL , PostgreSQL database migrations and updates and application of database patches.
• Backup and restores, export and import of data to and from Oracle, SQL run time configuration of Oracle, SQL.
• Develop and implement backup and recovery strategies to protect against data loss.
• Monitoring at server, database, collection level, and using various monitoring tools related to Oracle, PostgreSQL.
• Strong understanding of SQL architecture and internals.
• Proficiency in SQL and database/data design and architectural principles and methodologies.
• Familiarity with Linux/Unix operating systems.
• Scripting skills (e.g., Bash, Python) for automation.
• Supports multiple services and multiple databases of medium complexity with multiple concurrent users, ensuring control, integrity and accessibility of data.
• Implements multiple projects along with the production support.
• Will perform on-call support for critical needs.
• Experience with database monitoring tools.
• Implement performance tuning strategies to ensure optimal database response times.
• Responsible for providing support to customers by researching, diagnosing, troubleshooting issues, and resolving incidents and providing support for software bugs and other technical problems.
• Must have experience in the role of 24/7 Production Support and Maintenance activities.
• Design, build, Manage and maintain CI/CD tools to accelerate software development and deployment.
• Identify, troubleshoot, and resolve infrastructure issues in development, testing, and production environments.
• Perform system tests for security, performance, and availability.
• Automate build, test, and deployment processes.
• Automate repetitive tasks using scripting languages like Python, Bash, or PowerShell.
• Design, implement, and manage cloud infrastructure on platforms like AWS, Azure, or Google Cloud Platform.
• Provision and configure servers, databases, and other infrastructure components.
• Implement infrastructure-as-code (IaC) using tools like Terraform or CloudFormation.
• Implement monitoring and logging systems to track application performance and identify potential issues.
• Develop alerting mechanisms to notify teams of critical issues.
• Ticket management efficiencies i.e. response time, resolution time, providing regular updates, SLAs.

Education:

• BS or MS in CS/EE/ECE/ or related 5+ years of experience in IT industry.