Role Description The Database Administrator (Advanced) is responsible for supporting enterprise database migration and modernization initiatives. This role focuses on planning, coordinating, and executing database migrations from legacy systems to modern on-premises and cloud environments while ensuring data integrity, security, and compliance. The position also provides ongoing database administration and support for critical systems. Key Responsibilities - Migration Planning & Execution - Assess databases for migration readiness and compatibility - Develop and implement migration strategies for on-premises and cloud platforms - Coordinate with application and infrastructure teams to minimize downtime - Monitor migration processes and troubleshoot issues in real-time - Provide technical guidance, documentation, and training to stakeholders - Database Administration - Configure, manage, and maintain SQL Server and related database platforms - Perform schema conversions, data transformations, and integrity validation - Optimize database performance during and after migration - Support ongoing maintenance, backups, and recovery processes - Security & Compliance - Implement database security measures including encryption and access controls - Manage roles, permissions, and auditing processes - Ensure compliance with organizational and regulatory data standards - Collaboration & Support - Work closely with developers, infrastructure teams, and business stakeholders - Support system modernization efforts and continuous improvement initiatives - Provide day-to-day support for database environments Qualifications - Bachelor’s degree in Computer Science or a related field (or equivalent experience) - Minimum 3 years of experience as a Senior SQL Server DBA - At least 1 year of experience migrating databases across versions and platforms - 5 years of experience in database backup and restore processes Requirements - Strong expertise in Microsoft SQL Server - Proficiency in T-SQL - Experience with SQL Server Integration Services (SSIS) - Experience managing database roles, permissions, and security - Hands-on experience with database migration and performance tuning Preferred Skills - Experience implementing Transparent Data Encryption (TDE) - Knowledge of database design and normalization principles - Experience with PowerShell scripting Contact Information For more details reach at resumes@navitassols.com

Role Description This role will be responsible for all operational database administration duties, data engineering, and data operations within the Data Lake and Enterprise Data Warehouse (Snowflake) ecosystem including, but not limited, to the following: - Take the lead on our daily database administration, ensuring our data environment stays healthy and reliable. - Partner closely with our Staff EDW Architect to bring new visions to life, designing high-quality data artifacts that follow industry best practices. - Turn business needs into smart, reusable ETL solutions that grow alongside our company. - Design end-to-end pipelines using your expertise with data models and architecture diagrams to build automated ingestion and transformation pipelines that keep our data moving on schedule. - Analyze and produce artifacts such as Source-to-Target Mapping documents. - Build pipelines that bring together data from everywhere—whether it’s RDBMS, APIs, JSON, or flat files—creating a seamless flow of information. - Define the "Source of Truth" using tools like Python and ETL software to clean, integrate, and transform data into a single, reliable resource the whole company can trust. - Provide day-to-day operational support for all the data pipelines by monitoring and investigating alerts, while troubleshooting and remediating production issues in a timely manner. - Act as a player-coach for junior and intermediate data engineers and ETL developers as the EDO team grows. Qualifications - Deep experience performing ETL design and development via custom coding (SQL, Python, Spark, Java, etc.) as well as using ETL tools (e.g., Coalesce, Informatica, DataStage, Talend) and other tools such as Data Quality tools, Metadata Manager, etc. - Extensive hands-on, professional experience working with Snowflake as a Database Administrator (DBA) and clear understanding of Snowflake’s Access Control framework. - Comfortable with Cloud-hosted solutions, especially AWS with experience deploying Secrets Manager, KMS, S3, EC2, Linux, Cross-Account Access, etc. in a scaled environment. - Innate curiosity to fundamentally understand and solve problems. - Understanding of data warehousing architecture fundamentals (e.g., Kimball vs. Inmon, Medallion Architecture, 3NF data models, reference data models, dimensional models, conformed dimensions, SCDs, etc.). - Experience in orchestrating data operations via tools such as Apache Airflow, Cron, Astronomer, etc. Requirements - The compensation range listed for this role reflects the expected base salary for candidates located in Ontario, Canada. - This range represents base salary only. Depending on the role, candidates may also be eligible for additional compensation such as annual bonuses, commissions, equity awards, and a comprehensive benefits package. - Factors Influencing Final Compensation: - The final compensation offer will be determined by a variety of factors, which may include, but are not limited to: the candidate's specific experience, technical skills, knowledge, abilities, and relevant education, licensure, and certifications. - Other business factors, such as organizational needs and budget alignment, may also be considered in the final offer. - Ontario Salary Band: $100,000 — $125,000 CAD - This range represents hourly rate only. Depending on the role, candidates may also be eligible for additional compensation such as annual bonuses, commissions, equity awards, and a comprehensive benefits package. Benefits - Highly competitive salary - Retirement/401K/Pension Savings globally - Competitive Paid time off packages including birthdays off! - Access to a comprehensive mental health care program - Health benefits from day one of employment - Work from home reimbursements - Optional global WeWork membership for those who want a change from their home office and hubs in London and Toronto - Robust training and onboarding program - Coverage and support of personal development initiatives (conferences, courses, books, etc.) - Access to StackAdapt programmatic courses and certifications to support continuous learning - An awesome parental leave program - A friendly, welcoming, and supportive culture - Our social and team events!

Design and implement data governance frameworks while ensuring compliance with regulatory standards. Maintain metadata models and oversee data lineage and stewardship within enterprise systems, providing technical guidance on integrations with modern...

• Install, configure, upgrade, patch, and maintain Microsoft SQL Server environments (2005–2016) across Production, Test, and Development. • Administer and support Oracle databases (10g, 11g, 12c, 19c) on Linux/Unix and Windows platforms. • Proactively monitor database health, troubleshoot issues, and perform performance tuning to ensure availability, security, and optimal system performance. • Analyze and resolve performance bottlenecks, including locking, blocking, deadlocks, index fragmentation, and slow-running queries. • Perform T‑SQL performance tuning, code reviews, and optimization; collaborate closely with application and development teams. • Manage and test backup, restore, and Point‑in‑Time Recovery processes aligned with RTO and RPO requirements. • Lead and support SQL Server upgrades and migrations from legacy versions. • Administer TempDB configuration, database compression, and overall database optimization. • Implement and enforce database security best practices, including user access, encryption, TDE, auditing, data masking, and compliance monitoring. • Design, develop, deploy, and maintain SSIS/ETL solutions using SSDT/BIDS, SSIS, BCP, and Import/Export tools. • Configure and maintain SQL Server Agent jobs, alerts, maintenance plans, and Database Mail. • Support and administer SSRS environments as needed. • Collaborate with data modelers and architects on logical and physical database design and implementation. • Maintain accurate database documentation, including data standards, procedures, data dictionaries, and models. • Utilize monitoring and ticketing tools to manage incidents, changes, and service requests in accordance with SLAs.