Job Information
TEKsystems Administrateur De Base De Données/Database Administrator in Montreal, Quebec
Description
The database administrator manages the database fleets; maintains secure, optimized and
highly available databases, data warehouses and lake houses. This includes working with
multiple project teams to determine changes needed to both the database and surrounding
infrastructure, and then implementing those changes. Our DBA’s support ongoing project efforts
and day-to-day support activities for the department. The team is also looking for new technical
innovations to improve developers experience, systems performance and overall operations;
costs
Responsibilities:
● Day-to-day operational management of Redshift Clusters and RDS DBs
● Perform Redshift user/security tasks as needed (user/group management, password management, IAM Roles/Policies)
● Analyze production workloads and develop strategies to run optimized Redshift clusters with scale and efficiency.
● Provide architecture guidance and support to technical leads. Help develop code/SQLs for data assets, identify performance tuning opportunities and work with developers to improve production systems.
● Develop monitoring/recovery automation to identify and resolve issues with high SLA
● Research new technologies and develop proofs of concept. Propose tech improvements and new capabilities.
Qualifications: (Bold Required)
● 3+ years’ experience with AWS Services: Redshift, RDS, S3, EC2, Athena, Glue, Lake Formation (Data Governance), Sagemaker FeatureStore, Snowflake
● 2+ years’ experience with AWS Security Mechanisms: Redshift security, IAM permissions (User Groups, Roles, Policies, Instance Profiles), S3 Security
● Define and Automation of DB admin functions (DevOps) using Python, Jenkins, Airflow, Datadog, Git (Code Management system), Linux, Jira (Ticketing System)
Skills
Database administrator, aws, redshift, aws redshift, Sql, s3
Additional Skills & Qualifications
● Experience with DynamoDB, OpenSearch is a nice to have
● Strong analytical and critical thinking skills
● Ability to lead projects, prioritize and multitask
● Deadline and detail-oriented
● Part of On-call rotation
Pay and Benefits
The pay range for this position is $7000.00 - $9000.00
Workplace Type
This is a fully remote position.
À propos de TEKsystems:
Nous sommes partenaires dans la transformation. Nous aidons les clients à activer des idées et des solutions afin de profiter d’un nouveau monde d’opportunités. Nous sommes une équipe solide de 80 000 personnes, nous travaillons avec plus de 6 000 clients, dont 80 % faisant partie du Fortune 500, partout en Amérique du Nord, en Europe et en Asie. En tant que chefs de file de l’industrie des services technologiques complets, des services aux talents et des applications du monde réel, nous travaillons avec des leaders progressistes pour favoriser le changement. C’est le pouvoir d’un vrai partenariat. TEKsystems est une société du groupe Allegis.
Québec Numéro du permis d'agence de placement de personnel AP-2000547
About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
Quebec Personnel Placement Agency Permit Number AP-2000547
TEKsystems
- TEKsystems Jobs