Company
Company specializing in the design, production, and delivery of personalized business-critical documents including statements, invoices, letters, notices, and tax forms.
Activities
Seeking an experienced SQL DBA with expertise in T-SQL development, troubleshooting and optimization. The Senior SQL DBA will manage Microsoft SQL Server databases, services, and tools running in an on-prem environment as well as participate in building a database presence in the cloud (hybrid solution). In this role you will maintain database uptime, stability, performance, and security to ensure the highest customer service levels. You will also leverage your passion for data engineering to design, develop, and implement ETL solutions, involving close collaboration with development and business intelligence stakeholders.
- Review, analyze and debug T-SQL code
- Optimize data workloads across cloud and/or on-prem environments to stay ahead of business demand while minimizing costs
- Develop complex SQL scripts, functions and stored procedures
- Participate in architecture planning to prepare the business for significant future growth
- Manage production database servers to ensure robust security, high availability and performance
- Actively monitor databases and take preventive or corrective action to swiftly resolve issues that arise
- Support and enhance db’s running on Azure Managed SQL Instance(s) Implement policies and procedures for database backups, DR, security protocols, and data integrity
- Maintain lower-level development, QA, and staging database environments to support efficient development throughout the SDLC
- Create comprehensive diagrams and documentation that accurately captures database state Support development groups with database setup, configuration, optimization, and other modifications
- Bring a passion to stay current on industry database trends and related technology
- Adept at collaborating with leadership and technical stakeholders throughout the organization
- Adhere closely to change control and related ITIL practices
- Work in a highly collaborative software development environment that is primarily onsite.
Skills
- English C1 - Advanced
- Bachelor’s Degree in Computer Science or commensurate experience
- 5+ years’ experience supporting SQL Server databases in production environments that utilize AlwaysOn Availability Groups and Windows Clustering
- 5+ years’ experience in writing complex T-SQL to develop a variety of database objects (schemas, tables, stored procedures, triggers)
- 4+ years’ experience in database tuning and query optimization through analysis of Execution Plans and Dynamic Management Views, and usage of Extended Events
- 3+ years’ experience with developing packages within SQL Server Integration Services (SSIS)
- 2+ years’ experience with developing reports within Power BI and/or SQL Server Reporting Services (SSRS)
Additional Information
- $29-33 per hour
- Remote
- Timezone Central Time