Senior Database Engineer
About The Position
Performs complex computer systems analysis work for the CTO team, with a focus on supporting AI and modernization initiatives across enterprise applications, databases, and technical platforms. Work involves analyzing database and application requirements, developing automation scripts, supporting AI-enabled solution patterns, executing database migration activities, validating data quality, and modernizing technical processes across legacy and cloud-based environments. The position supports SQL development, scripting, ETL/ELT activities, schema analysis, data reconciliation, migration testing, automation of repeatable operational tasks, documentation of data dictionaries and technical workflows, issue resolution, and coordination with application, data, cloud, security, and business teams. Works under general supervision, with limited latitude for the use of initiative and independent judgment.
Requirements
- Graduation from an accredited four-year college or university with major coursework in computer science, database administration, information systems, or a related field. Experience may substitute for education on a year-for-year basis.
- Minimum of 5 years of experience in database programming, ETL development, or data migrations.
- Must have experience with scripting
- Must have experience with SQL
- Thorough knowledge of relational database management systems (RDBMS), such as Oracle and Microsoft SQL Server, data normalization, and indexing.
- Thorough knowledge of modern cloud datastores (e.g., Azure SQL, AWS RDS, PostgreSQL) and distributed schema designs.
- Thorough knowledge of industry ETL/ELT construction patterns, data type conversion constraints, and bulk data ingestion frameworks.
- Knowledge of automation approaches, scripting practices, AI-assisted development concepts, and operational use cases that improve repeatable technical and business processes beyond traditional data pipelines.
- Knowledge of agile project execution, short-cycle sprint deliveries, and schema version control frameworks.
- Strong skill in drafting, optimizing, and running complex, high-volume SQL scripts, stored procedures, and schema generation queries.
- Strong skill in tracking database schema changes and using transformation tools to convert legacy tables into normalized modern structures.
- Strong skill in parsing runtime log outputs, tracking query execution bottlenecks, and debugging transactional row failures.
- Strong skill in developing, modifying, and troubleshooting scripts used for database migration, automation, file processing, validation, scheduling, and system integration activities.
- Skill in applying AI-enabled tools responsibly to accelerate analysis, documentation, testing, code review, and process improvement while maintaining human review and quality control.
- Ability to perform systematic data audits on migrated datasets to verify row counts and relationship index accuracy.
- Ability to synthesize clear data dictionaries, schema documentation, and database maps.
- Ability to identify opportunities to use automation and AI-enabled capabilities to improve efficiency, reduce manual effort, strengthen validation, and support modernization activities across applications, databases, and operational workflows.
- Ability to communicate current migration risks and data validation drift to the systems engineering lead.
Nice To Haves
- Knowledge and implementation experience with NoSQL databases is preferred.
Responsibilities
- Executes structured database migration queries, develops and maintains scripts to support automation, handles data transformations, and extracts and loads large datasets from legacy storage tables into modernized database and cloud environments. 45%
- Validates database migrations, automation outputs, and AI-assisted processing results to confirm data integrity, relationship indexes, volume requirements, and business rules align with source systems and target platform expectations.35%
- Reviews computer logs, error prints, automation run results, AI-generated outputs, and complex data schemas to locate anomalies, troubleshoot failures, and correct discrepancies by updating scripts, mappings, or database logic.15%
- Maintains data dictionaries, schema updates, automation documentation, script inventories, database connection inventory files, and technical runbooks. Performs related work as assigned.5%
Benefits
- 100% paid employee health insurance for full-time eligible employees
- a defined benefit pension plan
- generous time off benefits
- numerous opportunities for career advancement
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
Associate degree
