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, PLSQL, database monitoring through tools like OEM, Splunk, Dynatrace, Cloudwatch etc.
• Some automation skills like understanding of terraform or ansible or AWS CloudFormation.
• Experience working with AWS RDS environment with understanding of periphery AWS services like EC2, S3, CloudWatch, VPC etc.
• Good of 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 implement 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.