Senior Database Administrator
19 days ago
Lansing
Job DescriptionCodeworks is an IT Services firm headquartered in SE Wisconsin, known for our strong commitment to quality and for our direct client relationships. Position Summary We are seeking a highly experienced Senior Database Developer/Administrator with a strong background in SQL Server to join our Client's data and development team on a contract basis. This role is responsible for the design, implementation, maintenance, and performance tuning of database systems that support critical applications and services. The ideal candidate combines hands-on expertise in T-SQL/PL-SQL, database administration, and performance optimization, along with a collaborative approach to supporting development teams and aligning with enterprise architecture standards. Responsibilities Design and implement logical and physical database models. Coordinate changes to database structure and code across development and production environments. Define database schema using SQL (DDL), manage access controls (DCL), and set physical parameters. Ensure scalable and maintainable solutions that meet performance benchmarks. Create, configure, and monitor SQL Server databases using SSMS, SQL Server Agent, and monitoring tools (e.g., SolarWinds, Redgate, Idera). Tune queries and manage resource utilization for optimal performance. Collaborate with developers and analysts to ensure high-performing, integrated database systems. Evaluate and manage data elements in a shared environment, reducing redundancy and maintaining uniform definitions. Conduct data modeling and prototyping to support application requirements. Define recovery procedures, storage needs, and access strategies. Implement backup and recovery strategies in line with compliance and business continuity standards. Manage user access, audit controls, and security best practices. Assist with software installs, updates, and performance threshold testing. Provide expertise in SQL and PL/SQL for stored procedures, packages, and functions. Review and optimize SQL code written by development teams. Collaborate with solution architects to build scalable, secure, and performant database systems. Establish and maintain development standards across multiple teams. Qualifications 10+ years of hands-on SQL development (T-SQL/PL-SQL) with query tuning and performance optimization. Excellent written and verbal communication skills Strong attention to detail and a structured approach to documentation Highly collaborative team player with a growth mindset Self-motivated with the ability to manage priorities and meet deadlines in a fast-paced environment 6+ years of experience with: PowerShell scripting Azure DevOps Agile/Scrum methodologies Proven experience with: SQL Server Management Studio (SSMS) SQL Server Agent Database monitoring tools (e.g., SolarWinds, Redgate, Idera) Strong understanding of Database security, Backup and recovery procedures, High availability (HA) and disaster recovery (DR) configurations Preferred Qualifications Experience with ETL processes and Azure SQL Background in large-scale or data warehouse environments Exposure to performance benchmarking and database compliance frameworks 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. Codeworks, LLC discloses that the anticipated hourly pay range for this position is between $50 and $.60 This range is subject to change based on job-related factors, including client requirements where applicable. All full time Codeworks employees are eligible to enroll in the companyβs medical, dental, vision, and life insurance plans. Additionally, employees can participate in Codeworksβ 401(k) retirement plan. #LI-KN1