Senior Database Administrator: SQL, Postgres
About The Position
The Senior Database Engineer independently evaluates, designs, codes, optimizes, and modifies databases and database applications. The role models databases and develops tables, stored procedures, views, triggers, and other database objects; tunes databases for performance; and collaborates with developers to integrate databases with other applications. The position may include interface development to access databases and a limited amount of database administration. This is a hybrid position requiring onsite work at the Allen, Texas office one day per week. The position is ineligible for immigration sponsorship or support, and may require an onsite interview or in-person onboarding to verify identity.
Requirements
- At least 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 database designs for optimal performance.
- Write and maintain unit tests.
- Write and maintain a library of query performance tests (baselines).
- Maintain accurate history in version control systems (Git/TFS) and write documentation as necessary.
- Monitor and maintain database CI/CD DevOps tooling and ensure accuracy of database deployment update and rollback scripts.
- Write and review application code in the data access layer to ensure performance and security of database calls.
- Troubleshoot across application components, debug and fix code, deploy changes, and test fixes.
- Diagnose and troubleshoot complex application problems, using tools and resources to identify solutions.
- Resolve challenging problems in collaboration with others.
- Help team members with SQL Server setup questions and troubleshooting.
- 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
