Database Engineer

Company Overview:

Our success lies at the powerful intersection of people and technology. Bringing innovative training and education solutions to more than 2 million customers a year, Certus enables lifelong learners at every level — from trusted industry brands, such as Amazon, Siemens, Geico and Chick-fil-A, to individual learners seeking to enter, sustain or advance their careers. Our people come with a get-it-done spirit and a desire to impact a rapidly growing industry. Certus is committed to continuously evolving to ensure a culture where employees can be themselves, do their best work, and thrive, both professionally and personally. We choose to be a remote workforce so we can hire top talent regardless of location — all while empowering employees to work from wherever they choose. Innovative, brave, kind and diverse are defining traits of our team. Our talent is positioned in numerous roles, with opportunity for internal mobility, such as software engineers, instructional designers, creative writers, consultative sales professionals, innovative marketers and more.

Database Engineer Overview:

Based on our Platform and Technology team growth, we are actively hiring for a Database Engineer. This role is responsible for developing, monitoring, maintaining and administrating Microsoft SQL, MySQL, MariaDB, and Postgres database instances. Development will be in support of application development and business intelligence teams, while leveraging best practices for optimized query performance and data architecture.

What you’ll get to own as a Database Engineer:

• Utilize Monday.com and Azure DevOps for task management and code review and migration.
• Review Redgate and Azure metrics for opportunities to improve database and application performance.
• Build and automate recurring database maintenance, monitoring, and audit tasks using SQL Agent jobs, PowerShell, or other means.
• Resolve logged warnings, errors, or process failures as needed.
• Support development efforts of the application teams, Enterprise Reporting data warehouse Azure Data Factory pipelines, Logic Apps and Function Apps.

• Gather requirements for reporting data needs across application stacks and team members
• Review SQL code for consistency and performance standards
• Develop data extraction, transformation, and load tasks supporting the data warehouse

• Development and tuning of stored procedures, views, and triggers based on coding standards and best practices
• Some after hours on call support for production issues will be required

What you’ll need to be successful in the Position:

Personal Skills: 

• Strong communication, troubleshooting and problem-solving abilities.
• Comfortable working independently and as a team.
• Learn quickly in a fast-paced environment.
• Overcome discomfort of ambiguity when present.
• Must be capable of performing in a dynamic environment, handling multiple tasks and projects simultaneously.
• Work as a self-starter under limited supervision, optimizing your time and others' time, toward organizational objectives.

Experience and working familiarity with: 

• Developing and optimizing efficient stored procedures, views and triggers
• Technical documentation, entity relationship diagraming (ERD)
• Database design best practices, normalization/denormalization, query optimization, referential integrity and logical database architecture.
• Data warehouse development and design and development concepts
• SQL Server Integration Services (SSIS) and/or Azure Data Factory development
• PowerShell scripting (or other scripting language) leveraged across multiple instances for monitoring and process automation.
• MS SQL Agent job management and trouble-shooting; Azure Elastic Job Agent
• SQL Server tools Extended Events, Redgate Monitor, Profiler and Tuning Advisor concepts
• MS SQL database server installation and configuration with MS SQL Server 2012 and above
• Understanding of SQL Server Reporting Service (SSRS) development
• Familiarity with SQL Server Analysis Services (SSAS), Azure Synapse, and reporting platforms such as wynEnterprise.
• MySQL, MariaDB, Postgres, and SFDC (3rd party API or ODBC) connectors experience
• Azure server or database instance administration
• Data instance file utilization and storage management
• tempdb optimization and management
• Backup management and verification
• Knowledge of High Availability (HA), clustering, mirroring, replication, and log shipping configuration

EEO Statement: Certus provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.