Oracle and SQL Database Administrator with PostgreSQL

Job Title: Oracle and SQL Database Administrator with PostgreSQL experience Location: Irving, TX Client: Verizon Project Duration: 12 months Job Type: Contract Work Arrangement: Work from Client Office – 5 days a week Interview: Three rounds of Video interview 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 GCP. 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 Job Type: Contract Pay: $30.00 - $40.00 per hour Work Location: In person