About Company
A robust database infrastructure is the backbone of every successful enterprise, and at Career.zycto, we build precisely that. We empower businesses through innovative data solutions and exceptional technical support. For a Database Administrator, this translates into a dynamic environment where your expertise directly impacts client success and operational efficiency. You’ll join a collaborative team dedicated to fostering professional growth and embracing cutting-edge technologies. We pride ourselves on creating a supportive culture where DBAs can thrive, tackle complex challenges, and significantly contribute to our collective mission of data excellence.
Job Description
Career.zycto is seeking a highly skilled and dedicated Database Administrator – SQL Server (Full Time) to join our growing team in Frogtown, St. Paul. This is an exceptional opportunity for a motivated professional to play a critical role in managing, maintaining, and optimizing our SQL Server database environments, ensuring high availability, performance, and security for our diverse client base. In this pivotal role, you will be instrumental in the design, implementation, and ongoing support of our critical data systems, safeguarding the integrity and accessibility of information that drives our operations and client success.
You will work closely with development, operations, and client services teams to understand complex requirements, troubleshoot intricate issues, and implement robust solutions that scale. Your expertise will be vital in ensuring data integrity, system reliability, and efficient data retrieval for complex applications across various business units. We are looking for someone who thrives on problem-solving, is deeply passionate about database technology, and is committed to continuous improvement through best practices. If you possess a strong understanding of SQL Server architecture, advanced T-SQL development, proactive performance tuning, and comprehensive disaster recovery strategies, we encourage you to apply and help us continue building a foundation of data excellence. This role demands a proactive approach to monitoring, an analytical mindset for troubleshooting, and strong communication skills to collaborate effectively across departments and with stakeholders. Join Career.zycto and contribute to an environment where your technical prowess directly translates into tangible business impact and strategic advantage.
Key Responsibilities
- Install, configure, and upgrade SQL Server instances across various environments.
- Monitor database performance, implement proactive measures, and conduct routine performance tuning and optimization.
- Perform comprehensive database backups, restores, and disaster recovery planning and regular testing.
- Manage database security, including user permissions, roles, schema security, and auditing.
- Troubleshoot and resolve complex database issues, including connectivity, performance bottlenecks, and data integrity problems.
- Implement and maintain high availability solutions such as AlwaysOn Availability Groups, Mirroring, and Log Shipping.
- Develop, test, and implement robust T-SQL scripts for database maintenance, data manipulation, and reporting.
- Collaborate closely with developers to optimize queries, stored procedures, and database schemas for optimal performance.
- Document database systems, configurations, operational procedures, and best practices comprehensively.
- Participate in an on-call rotation to provide critical database support outside of regular business hours.
Required Skills
- Proven experience (4+ years) as a SQL Server Database Administrator (DBA).
- Strong proficiency in SQL Server versions 2012, 2014, 2016, 2017, and 2019.
- Expertise in T-SQL development, optimization, and debugging complex queries and stored procedures.
- In-depth knowledge of database performance tuning and optimization techniques, including index management and query plan analysis.
- Extensive experience with SQL Server High Availability (HA) and Disaster Recovery (DR) solutions (AlwaysOn Availability Groups, clustering, log shipping, mirroring).
- Solid understanding of database security best practices and compliance requirements.
- Familiarity with database backup and recovery strategies for various scenarios.
- Ability to troubleshoot complex database issues independently and effectively.
- Excellent communication, problem-solving, and interpersonal skills for collaboration.
Preferred Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Microsoft Certified: Azure Database Administrator Associate or other relevant SQL Server certifications.
- Experience with cloud database platforms (Azure SQL Database, AWS RDS, Google Cloud SQL).
- Familiarity with PowerShell scripting for database automation and administrative tasks.
- Knowledge of other database technologies (e.g., MySQL, PostgreSQL, Oracle).
- Experience working in an Agile/Scrum development environment.
Perks & Benefits
- Competitive salary and comprehensive benefits package.
- Health, dental, and vision insurance with employer contributions.
- Generous paid time off (PTO) and company holidays.
- 401(k) retirement plan with company match to help secure your future.
- Opportunities for professional development, certifications, and continuous learning.
- A collaborative, supportive, and innovative work environment.
- Modern office space situated in a vibrant St. Paul neighborhood with easy access to amenities.
- Employee assistance program (EAP) for personal and professional support.
- Team-building events and company outings.
How to Apply
Apply directly through our secure online portal by clicking the link below. Ensure your resume and cover letter are tailored to this role, highlighting your SQL Server DBA experience and relevant achievements. We look forward to reviewing your application!
