Senior DBA: SQL, Postgres
About The Position
The Senior Database Engineer works independently to evaluate, design, code, optimize, and modify databases and database applications. The role models databases and develops tables, stored procedures, views, triggers, and other database objects. The engineer tunes databases for optimal performance and works with developers to integrate databases with applications. The position may involve interface development to access databases and a limited amount of database administration. This hybrid position is based in Allen, Texas, with team members expected to work onsite at the office one day per week. The role is a regular, full-time individual contributor position with 5% travel. Immigration sponsorship and support are not available.
Requirements
- A minimum of 6 years of experience in database administration.
- Experience writing SQL queries.
- Familiarity with object-oriented programming.
Nice To Haves
- Experience writing and optimizing complex queries.
- Experience with performance tuning.
- Knowledge of payment systems and solutions.
- Strong communication, writing, and diagramming skills.
- Experience with GoLang.
Responsibilities
- Write and review stored procedures, functions, and other programmable objects for high-volume transaction processing systems.
- Participate on scrum teams as the SQL expert, helping move features through the software development lifecycle.
- Tune queries for optimal performance by examining execution plans and ensuring appropriate indexing.
- Participate in design meetings and recommend high-performing database designs.
- Write and maintain unit tests.
- Write and maintain a library of query performance tests and baselines.
- Maintain accurate history in version control systems such as Git or TFS, and write documentation as necessary.
- Monitor and maintain database CI/CD DevOps tooling and ensure update and rollback scripts are accurate for database deployments.
- Write and review application code in the data access layer to ensure database calls are performant and secure.
- Perform advanced troubleshooting across application components, debug and fix code, and deploy and test fixes.
- Diagnose and troubleshoot complex application problems, using tools and resources appropriately to identify solutions.
- Resolve challenging problems in collaboration with others.
- Help team members with questions and troubleshooting related to their SQL Server setups.
- Train and mentor junior team members.
- Perform other duties as assigned.
Benefits
- Comprehensive benefits designed to support physical, mental, and financial health.
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
No Education Listed
