Senior Database Administrator responsible for database design, implementation, maintenance and support. Develop PL/SQL and ETL procedures, optimize queries and performance, and perform DBMS installation, configuration, migration and upgrades. Work with Oracle and SQL Server on on-prem and cloud (Azure, OCI) platforms, including RAC, GoldenGate and Data Guard; use tools like TOAD, OEM and DB Artisan.
We do have a job opening for Database Administrator - Senior for our direct client Province of Ontario. The position details are given below:
Job Details:
Job ID: RQ10554 - Database Administrator - Senior
Client : Land & Resources Cluster
Location : 40 St Clair Avenue, Toronto, Ontario
Duration: 09 months + Extension
Type: Onsite
Job Description:
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 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
Similar Jobs
Information Technology • Professional Services • Software • Consulting
Lead migration of Oracle databases off Solaris to supported infrastructure, upgrade to 19c+, administer and optimize multi-tenant Oracle environments, design/configure DB servers across OSes, ensure security/auditing, support on-prem and cloud (GoCloud) deployments, implement TDE/Dataguard/RAC/OEM, provide technical analysis, documentation, and risk mitigation for the Solaris Evergreening migration.
Top Skills:
ApexArcgisCase ToolsGocloudJavaLinuxMiddlewareObieeOem 13C (Oracle Enterprise Manager)OmsOracle 10GOracle 11GOracle 12COracle 19COracle Data GuardOracle DatabaseOracle RacPl/SqlSiebelSolarisSQLTde (Transparent Data Encryption)Windows
Edtech • Professional Services
Provide senior programming, systems analysis, systems design and SQL Server database administration to support an ERP Student Information System migration. Lead development, code review, integration (APIs/ETLs), performance optimization, backups/recovery, access controls, and project work. Mentor programmers, collaborate with stakeholders, gather requirements, and ensure quality releases and documentation.
Top Skills:
APIsAsp.NetColleagueEnvisionETLJavaScriptPower BISalesforceSQLSQL ServerTeam Foundation ServerUnidataUniobjectsVb.NetVbscriptWorkdayXML
Information Technology • Professional Services • Software • Consulting
Senior Database Administrator responsible for physical database design and full DBMS lifecycle: installation, migration, configuration, performance tuning, capacity planning, backup/recovery, security, and monitoring. Supports on-prem and cloud (Azure/OCI), Oracle and SQL Server environments, PL/SQL ETL development, RAC/GoldenGate/Data Guard, and coordinates incident/change/configuration management and vendor support.
Top Skills:
AzureData GuardDb ArtisanETLGoldengateLinuxMySQLOciOemOracleOracle 12C+Pl/SqlPostgresPythonRacShellSQL ServerToadUnixWeblogicWindows
What you need to know about the Calgary Tech Scene
Employees can spend up to one-third of their life at work, so choosing the right company is crucial, not just for the job itself but for the company culture as well. While startups often offer dynamic culture and growth opportunities, large corporations provide benefits like career development and networking, especially appealing to recent graduates. Fortunately, Calgary stands out as a hub for both, recognized as one of Startup Genome's Top 100 Emerging Ecosystems, while also playing host to a number of multinational enterprises. In Calgary, job seekers can find a wide range of opportunities.
