Search Technical Jobs
All GTN W2 consultants get full benefits. Learn more.
GTN Technical Staffing
https://cdn.haleymarketing.com/templates/62895/logos/gtntechnicalstaffing-hml.png
http://www.gtntechnicalstaffing.com
http://www.gtntechnicalstaffing.com
USD
140000
140000
YEAR
true
Sr. Application DBA / Database Administrator / Database Engineer
2024-12-10
2025-01-09
Job Number: 26873
Pay Rate: $140000 - $140000
Remote Friendly?:
Job Description
Sr. Application DBA / Database Administrator / Database Engineer
DETAILS
Location: 100% On-Site in Lone Tree, CO
Position Type: Direct-Hire
Salary: to $140K
Residency Requirements: Candidates authorized to work in the US are encouraged to apply. No sponsorship is being offered at this time.
*Relocation assistance is being offered for out-of-town candidates*
Perks of working at our client's office include:
ABOUT THE POSITION
GTN Technical Staffing is seeking a Senior Application Database Administrator to oversee the development, management, and administration of our databases. This role is pivotal in designing and implementing new data structures, managing existing databases, securing all data, and administering all Microsoft SQL Server database instances on Linux, Windows, and Amazon RDS. The current environment is monolithic with an overabundance of stored procedures creating database performance issues. This person will focus on performance and query optimization. Your focus will be optimizing queries to create a more efficient database environment. The current design is very vertical right now with too many sprocs tracking through 1 object, creating scalability and performance issues. There is a backlog of current issues that will need immediate attention, but following bringing the backlog up to date, you will act as a "hunter"for performance issues vs. Waiting for tickets to roll in.
The Sr. Application DBA / Database Engineer will ensure 24/7 availability, security, and performance of critical databases (SQL Server, MySQL, Amazon RDS). You will design and optimize data structures, consolidate data, and resolve database issues. You will manage security and access control. In addition, the DBA / Database Engineer will collaborate with developers to integrate database requests. You will support SQL Server and SQLite processes for mobile apps, as well as conduct advanced ad hoc reporting, document data models, and transform data into actionable insights. The Sr. DBA / Database Engineer will also design and test backup/recovery procedures and lead database projects for upgrades and migrations.
TECHNICAL REQUIREMENTS
5-8+ years in the following skill sets…
DETAILS
Location: 100% On-Site in Lone Tree, CO
Position Type: Direct-Hire
Salary: to $140K
Residency Requirements: Candidates authorized to work in the US are encouraged to apply. No sponsorship is being offered at this time.
*Relocation assistance is being offered for out-of-town candidates*
Perks of working at our client's office include:
- $17/day of DoorDash deliveries
- Full cafeteria and free catered lunch daily
- Premium, on-site fitness facility
ABOUT THE POSITION
GTN Technical Staffing is seeking a Senior Application Database Administrator to oversee the development, management, and administration of our databases. This role is pivotal in designing and implementing new data structures, managing existing databases, securing all data, and administering all Microsoft SQL Server database instances on Linux, Windows, and Amazon RDS. The current environment is monolithic with an overabundance of stored procedures creating database performance issues. This person will focus on performance and query optimization. Your focus will be optimizing queries to create a more efficient database environment. The current design is very vertical right now with too many sprocs tracking through 1 object, creating scalability and performance issues. There is a backlog of current issues that will need immediate attention, but following bringing the backlog up to date, you will act as a "hunter"for performance issues vs. Waiting for tickets to roll in.
The Sr. Application DBA / Database Engineer will ensure 24/7 availability, security, and performance of critical databases (SQL Server, MySQL, Amazon RDS). You will design and optimize data structures, consolidate data, and resolve database issues. You will manage security and access control. In addition, the DBA / Database Engineer will collaborate with developers to integrate database requests. You will support SQL Server and SQLite processes for mobile apps, as well as conduct advanced ad hoc reporting, document data models, and transform data into actionable insights. The Sr. DBA / Database Engineer will also design and test backup/recovery procedures and lead database projects for upgrades and migrations.
TECHNICAL REQUIREMENTS
5-8+ years in the following skill sets…
- Database Administration / Design / Development
- Microsoft SQL Server Database Administration (SQL Server on Amazon RDS is ideal)
- Performance / Query optimization
- Experience creating, diagnosing-and-rewriting, and implementing complex stored procedures, reports, and queries.
- Excellent knowledge of Microsoft SQL Server data backup, recovery, security, and integrity.
- Experience as a standalone DBA. Willing to work independently, drive critical efforts, and plan and manage work.
- Database monitoring tools - Zabbix (or similar)
- Third-party tools such as Redgate SQL Compare and SQL Data Compare.
- Strong analytical and problem-solving skills.
- SQL Server on Linux
Share This Job:
Related Jobs:
Login to save this search and get notified of similar positions.About Lone Tree, CO
Ready to take the next step in your career? Explore job opportunities around Lone Tree, Colorado, where the Rocky Mountains meet bustling city life. Located in Douglas County, Lone Tree offers a perfect blend of scenic beauty and urban amenities, making it an ideal place to live and work. Enjoy easy access to outdoor adventures at places like Bluffs Regional Park or catch a show at the Lone Tree Arts Center. With a thriving culinary scene, diverse art galleries, and proximity to professional sports teams like the Denver Broncos and Colorado Rockies, Lone Tree has something for everyone. Don't miss out on the chance to advance your career in this vibrant and welcoming community!
