Job Description
Job Description
Codeworks is an IT Services firm headquartered in SE Wisconsin, known for our strong commitment to quality and for our direct client relationships.
Who We Are Looking For : We are seeking a collaborative SQL Server Database Systems Engineer who excels in a team environment.
The ideal candidate will have extensive experience with Microsoft SQL Server and MSBI components, along with skills in Ansible and automation tools.
This is an on site position in the Greater Milwaukee WI Area, long term contract, contract to hire potential.
Summary : As a SQL Server Database Systems Engineer, you will engineer and support database systems through analysis, design, development, and implementation.
You will be responsible for ensuring optimal performance, security, and availability of database environments while focusing on infrastructure availability and automation.
Responsibilities :
Database Administration : Oversee the installation, configuration, and maintenance of SQL Server databases, including MSBI components (SSAS, SSIS, SSRS).
High Availability and Disaster Recovery : Implement and manage SQL Server Always On Availability Groups (AOAG) and other HADR solutions.
Automation and Scripting : Develop and maintain automation scripts using PowerShell, Ansible, and other tools to streamline database management tasks.
Database Migrations : Plan and execute database upgrades and migrations with minimal downtime.
Performance Tuning : Monitor and optimize database performance through indexing, query optimization, and resource management.
Backup and Recovery : Develop and implement robust backup and recovery procedures.
Security Management : Ensure database security through best practices and compliance adherence.
Monitoring and Maintenance : Proactively monitor production databases, observe key metrics, set up automated alerts, and perform regular health checks.
Collaboration : Work collaboratively with application development teams to support deployment and maintenance.
Mentorship : Share knowledge and mentor junior team members, fostering continuous learning.
Incident Response : Act as a point of escalation for complex database issues, providing expert-level troubleshooting and resolution.
Qualifications :
Experience : Minimum of 10 years administering SQL Server databases and MSBI components.
Expertise with SQL Server Always On Availability Groups (AOAG).
Advanced scripting skills with PowerShell, Ansible, or similar tools.
Proficient in database migrations and upgrades.
Hands-on experience with MSBI components (SSAS / SSIS / SSRS).
Strong understanding of Windows Server administration.
Bachelor’s degree in Computer Science, Information Systems, or related field, or equivalent experience.
Familiarity with Hashicorp Vault and / or CyberArk for SQL Server access.
Experience with Atlassian’s Jira for agile feature and story creation.
Knowledge of AWS, Azure, or other cloud environments, including RDS and Azure SQL Database.
Experience with Delphix for database virtualization and other relevant technologies.
About Codeworks : Codeworks has over 25 years of experience serving Fortune 1000 companies in Wisconsin as well as our client's national locations.
Our recruiting team excels at evaluating, advising, and connecting IT professionals with new opportunities that will satisfy their expectations regarding income and opportunity for growth.
At Codeworks, we're committed to diversity, equity, and inclusion in our workforce and beyond. We believe in equal opportunities and value the unique perspectives that every individual brings to our team.
Join us in creating an inclusive, innovative, and collaborative workplace where your talents can thrive.
Codeworks is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military / veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws.
LI-KN1
SQL Server Database Systems Engineer
As a SQL Server Database Systems Engineer, you will engineer and support database systems through analysis, design, development, and implementation. We are seeking a collaborative SQL Server Database Systems Engineer who excels in a team environment. Database Administration: Oversee the installation...
Sql Server Database Administrator
As a SQL Server Database Systems Engineer, you will support and engineer database systems, focusing on analysis, planning, design, development, implementation, and upgrades. SQL Server Database Systems Engineer. Utilizing established architectural and engineering best practices, you'll manage co...
DB2 LUW Database Systems Engineer
We are seeking an experienced DB2 LUW Database Systems Engineer. This role involves engineering and supporting database systems, including analysis, planning, design, development, implementation, and upgrades. Lead the engineering and support of DB2 LUW database systems, focusing on system solutions...
SQL Database Administrator
Our great client in Franklin, WI has an immediate opening for a SQL Database Administrator. Hands on experience with SQL Server AOAG. Experience with SQL upgrades and migrations. Apex Systems is an equal opportunity employer. ...
Entry-Level Data Analyst (Remote)
D Aceto Services LLC is seeking a motivated and detail-oriented Entry-Level Data Analyst to join our team. Help maintain data integrity and accuracy within databases. In this remote position, you will work closely with various departments to analyze data, generate insights, and support decision-maki...
Data Engineer I
As our Data Engineer you will develop data pipelines that support data warehousing, BI reporting, and analytics. As a Data Engineer, you will report to our Director of Data Management and Integration and meaningfully contribute to this department. Develop data pipelines for warehousing, BI reporting...
IT Systems Administrator
The IT System Administrator is responsible for network and systems services as assigned, including ongoing maintenance and troubleshooting. Write and use basic PowerShell scripts that are designed for Enterprise systems administration and Automation. ...
Lead Data Analyst
Leads expert level quantitative and qualitative data analysis and reporting of patterns, insights, and trends to decision-makers in order to drive business decisions and address business questions. Access, gather, and analyze data from multiple internal and external sources to drive insights into co...
Systems Administrator - Deployment
Deployment Systems Administrator. As a member of the IT Infrastructure team, and working closely with the Desktop Management team, the Deployment Systems Administrator is responsible for fulfilling tasks related to servers, software, and user experience. The Deployment Systems Administrator will loo...
Industrial Engineer - Data & Operations
Collaborate with the GBSC Data Team to maintain calculators, manage engineering change releases, and ensure data integrity during production transitions. As an Industrial Engineer you'll play a pivotal role in optimizing manufacturing efficiency through data-driven insights. Build and standardize en...