Urgent Client Requirement: Database Administrator

Job Title: Database Administrator
Location: Toronto, Canada (Hybrid - Onsite 3 days per week)
Contract Duration: 6 Months+ (Potential for extension)

• Cloud DB expertise with good exposure in AWS Infra, RDS, Aurora, etc.
• Oracle DB and PostgreSQL DB expertise, any other databases are a plus point.
• Good with Database Performance tuning, SQL, PL/SQL, database monitoring through tools like OEM, Splunk, Dynatrace, Cloudwatch, etc.
• Some automation skills, like an understanding of Terraform, Ansible, or AWS CloudFormation.
• Experience working with AWS RDS environment with an understanding of peripheral AWS services like EC2, S3, CloudWatch, VPC, etc.
• Good to have (not a must have) - AWS Certification, preferably DB, but infra certifications like Cloud Foundations or solution architect associate will also work.
• Managing and maintaining database systems (e.g., Oracle, PostgreSQL, Aurora, AWS RDS, Exadata) to ensure availability, reliability, and optimal performance.
• Implementing strategies and solutions for automated management and monitoring of the database and transaction processing environments.
• Influencing Database design, development, and supporting cloud migrations from Oracle on-prem to Oracle in AWS, AWS Aurora PostgreSQL. (i.e., Migration approach, schemas, data migration strategy and execution, performance, observability, logical and physical database operationalization, and management, etc)
• Implementing best practices and standards for Database production management, ensuring high multi-region/zone availability and scalability, reliability, security, and compliance.
• Constantly enhancing and automating database observability and performance metrics, to proactively detect and prevent incidents / and impact to our services using tools like AWS CloudWatch, Splunk, Dynatrace.
• Analyzing complex distributed production deployments and optimizing performance through automation and resiliency.
• SQL tuning and performance optimization: Strong expertise in analyzing execution plans, proactively identifying potential performance bottlenecks, and optimizing SQL queries.
• Planning, creating, resizing, and monitoring tablespaces for optimized performance, and implementing efficient data and space utilization strategies.
• Strong command over SQL and PL/SQL, with the ability to analyze source-target mappings, develop automated scripts, and validate data accuracy.
• Planning and executing database backups, recovery strategies, and replication, including Goldengate and AWS DMS, to ensure business continuity and disaster recovery alignment.
• Implementing CI/CD pipelines to automate data deployment, testing, and monitoring processes.
• Drive automation initiatives to streamline manual database tasks and improve operational eciency.
• Working closely with the application and product teams to support development, testing, and ongoing automation.
• Rotating on-call production support for critical incidents and scheduled changes.

Best Regards
Mohd Suhaib
Cardinal Integrated Technologies
Direct:
Ph: Ext 329