Client: Ministry of Public and Business Service Delivery and Procurement (Land & Resources Cluster)
Job Title: Database Administrator - Senior
Job Location: Remote | 40 St Clair Ave W, Toronto
Must Haves:
- 6 10+ years of proven experience in database administration, including database design, implementation, maintenance and support
- 5+ years of experience in PL/SQL, creating data ETL procedures (very strong) and packages, and query optimization techniques
- Hands-on experience with DBMS operations such as installation, configuration, migration, and upgrades
- Strong knowledge of performance tuning, optimization, and capacity planning
- Experience with one Oracle and SQL Server
- Experience working with On-Prem and Cloud Technologies such as Azure and OCI Platforms.
- Experience with RAC, Golden Gate, Data Guard Technologies.
- Experience with information retrieval tools and query languages such as TOAD, OEM and DB Artisan
General Skills:
1) 10 + years experience in
- one or more operating systems
- one or more database technologies
- In the use of information retrieval packages and proficiency with query languages
- In monitoring and enforcing database rules
- Incident, Problem, Change, Configuration and capacity planning Management procedures
- Experience in Cloud migration
2) Experience with one or more communications protocols
3 )Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills
4) A team player with a track record for meeting deadlines
Desirable Skills:
- Experience with distributed data systems
- Experience with middleware technologies such Web logic, OEM middleware, etc.
- Experience with researching and implementing cyber security vulnerability remediations
- Awareness of emerging IT trends and directions
- Knowledge and understanding of Information Management principles, concepts, policies and practices
- Experience in Database Administration, Maintenance and Optimization and vendor support services.
- Experience and expert knowledge in technology and/or application required including installation, configuration, maintenance, upgrade (technology stack) and cloning
- Additional Skills for Case Management and ERP Experience in designing/developing an automated data distribution mechanism
- Knowledge and understanding of object-oriented analysis and design techniques.
- Experience in developing enterprise architecture deliverables (e.g. models)
- Knowledge and understanding of Ontario Government Enterprise Architecture processes and practice
- Experience in impact analysis, implementation planning and implementation of technology or suite specific patches, maintenance packs and releases, and technology stack patch sets and releases
- Experience in technical design, planning and implementation of specific technology or suite
Evaluation Criteria:
Database Administration Expertise-50%
- 10+ years proven experience in database administration, including database design, implementation, maintenance and support
- Hands-on experience with DBMS operations such as installation, configuration, migration, and upgrades
- Experience with RAC, Golden Gate, Data Guard Technologies.
- Experience with performance tuning, optimization, and capacity planning
- Experience with backup, recovery, and disaster recovery strategies
- Experience monitoring and enforcing database rules, policies, and standards
- Knowledge of Incident, Problem, Change, and Configuration Management processes (e.g., ITIL practices)
- Experience with database security, access control, and data integrity management
- Basic understanding of communication protocols and networking concepts relevant to databases
- Ability to support database connectivity and integration across systems
Technical Proficiency -35%
- Experience with one or more database technologies (e.g., Oracle 12c and above, SQL Server, MySQL, PostgreSQL) in large multi-tenant environments
- Proficiency in PL/SQL, creating data ETL procedures and Packages, and query optimization techniques
- Experience working with On-Prem and Cloud Technologies such as Azure and OCI Platforms.
- Experience working with multiple operating system such as Linux, Unix, and Windows
- Working knowledge of one or more programming/scripting languages (e.g., Python, Shell)
- Experience with information retrieval tools and query languages such as TOAD, OEM and DB Artisan
- Experience coordinating implementation of technically advanced complex systems resources to lower non-production environment
Soft Skills-15%
- Strong ability to troubleshoot complex database issues and optimize system performance
- Ability to document processes, designs, and operational procedures clearly
- Experience in providing complex/specialized systems analysis and design for success
- Communicates effectively to drive technical outcomes with technical staff/teammates
- Demonstrated critical thinking and decision-making capabilities
- Excellent verbal and written communication skills for technical and non-technical audiences
- Strong interpersonal skills with a collaborative mindset