RQ10554 - Database Administrator - Senior

Responsibilities:

• Creating physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery
  

General Skills:

• 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
  
• Experience with one or more communications protocols
  
• Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills
  
• 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
  

Requirements

Experience and Skill Set Requirements:

Must Haves:

• 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
  

Skill Set Requirements:

Database Administration Expertise:

• 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:

• 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:

• 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