RQ10554 - Database Administrator - Senior

Flexstaf IT | Career PageToronto, ON, CanadaSenior
Active

Job description

Must Have: 10+ years of proven experience in database administration, including database design, implementation, maintenance and support5+ years of experience in PL/SQL, creating data ETL procedures (very strong) and packages, and query optimization techniquesHands-on experience with DBMS operations such as installation, configuration, migration, and upgradesStrong knowledge of performance tuning, optimization, and capacity planningExperience with one Oracle and SQL ServerExperience 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 Experience and Skill Set Requirements Database Administration Expertise-50% 10+ years proven experience in database administration, including database design, implementation, maintenance and supportHands-on experience with DBMS operations such as installation, configuration, migration, and upgradesExperience with RAC, Golden Gate, Data Guard Technologies.Experience with performance tuning, optimization, and capacity planningExperience with backup, recovery, and disaster recovery strategiesExperience monitoring and enforcing database rules, policies, and standardsKnowledge of Incident, Problem, Change, and Configuration Management processes (e.g., ITIL practices)Experience with database security, access control, and data integrity managementBasic understanding of communication protocols and networking concepts relevant to databasesAbility 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 environmentsProficiency in PL/SQL, creating data ETL procedures and Packages, and query optimization techniquesExperience working with On-Prem and Cloud Technologies such as Azure and OCI Platforms.Experience working with multiple operating system such as Linux, Unix, and WindowsWorking 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 ArtisanExperience 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 performanceAbility to document processes, designs, and operational procedures clearlyExperience in providing complex/specialized systems analysis and design for successCommunicates effectively to drive technical outcomes with technical staff/teammatesDemonstrated critical thinking and decision-making capabilitiesExcellent verbal and written communication skills for technical and non-technical audiencesStrong interpersonal skills with a collaborative mindset

Must Have:

Must Have:
  • 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
ETL procedures (very strong)
  • 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

Experience and Skill Set Requirements

Database Administration Expertise-50%

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%

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
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%

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