Database Administrator

The Atlas Corp. and Seaspan teams are goal-driven and share a high-performance culture, focusing on building services offerings to become a leading asset manager. Seaspan provides many of the world's major shipping lines with alternatives to vessel ownership by offering long-term leases on large, modern containerships combined with industry leading ship management serves. Seaspan's fleet has evolved over time to meet the varying needs of our customer base. We own vessels in a wide range of sizes, from 2,500 TEU to 14,000 TEU vessels. As a wholly owned subsidiary of Atlas Corp, Seaspan delivers on the company's core strategy as a leading asset management and core infrastructure company.

Position Description:

Reporting to the Team Lead, Database and Integration, the Database Administrator is responsible for the design, development, and administration/support of existing and new database servers while following business, architectural, and service requirements. This position will have a strong understanding of SQL server and database related concepts with the ability to read and write complex SQL queries as required.

Job Responsibilities:

Proactively enhance existing processes, conforming them to the enterprise architecture.

Design, implement, document, and maintain database systems to ensure optimal performance and reliability.

Perform regular database maintenance tasks, including backups, updates, and security protocols.

Collaborate with development teams to optimize database design and functionality.

Monitor database performance and troubleshoot issues, ensuring minimal downtime.

Ensure data security and implement access controls.

Evaluate and recommend new database technologies and solutions.

Provide technical support to internal teams for database-related issues.

Manage both Azure SQL databases and Microsoft SQL Server environments.

Design, implement, and maintain SQL Server Agent jobs.

Utilize advanced SQL querying skills for data retrieval, manipulation, and optimization.

Perform optimizing query tuning for enhanced performance and resource efficiency.

Design and implement ETL processes for efficient data extraction, transformation, and loading, and familiarity with ETL tools.

Identify and resolve performance bottlenecks in SQL databases.

Support and manage SQL high availability groups.

Support clustered Azure VM.

Qualifications:

Bachelor's degree in computer science, Information Technology, or a related field.

5+ years of proven experience as a DBA.

Proven experience as a Database Administrator or in a similar role.

Strong knowledge of database management systems (e.g., MySQL, PostgreSQL, Oracle, SQL Server).

Strong knowledge in reading and writing complex T-SQL.

Proficiency in SQL and database design principles.

Experience with database security and access controls.

Ability to work collaboratively in a team environment.

Strong data analysis skills with the ability to interpret and derive insights from complex datasets.

Experience in designing and implementing ETL processes for efficient data extraction, transformation, and loading.

Understanding of database principles and best practices.

Strong problem-solving skills to address issues related to data quality, integrity, and system performance.

Demonstrate proficiency in creating and maintaining detailed documentation for database architecture, processes, and configurations.

Familiarity with version control systems for managing changes to database structures and code.

Effective communication skills to collaborate with stakeholders and convey technical concepts to non-technical audiences

Experience with coding language(s) such as Python, C#, or Java.

Additional Desired Qualifications:

Certification in Database Administration (e.g., Microsoft Certified: Azure Database Administrator Associate, MS SQL Database Administrator Certified Professional) or relevant certifications in related field.

Familiarity with cloud-based database solutions (e.g., AWS and Azure SQL Database).

Familiarity with Modern Data Management Architecture (eg. Delta Lake).

Experience with ETL tools (eg. Talend, Azure Data Factory, SSIS, or Databricks).

Knowledge of cloud computing (eg. Snowflake, Actian, or Databricks).

Experience with Big Data technologies (e.g., Hadoop, Spark).

Experience with R and DAX is a plus.

Job Demands and/or Physical Requirements:

As Seaspan is a global company, occasional work outside of regular office hours may be required.

Atlas Corp. and Seaspan Corporation are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to age, race, colour, religion, gender, sexual orientation, gender identity, national origin, disability, or protected Veteran status.

We thank all applicants in advance. If your application is shortlisted to be included in the interview process, one of our team will be in contact with you.

Full time