SQL Server DBA

American Technology Consulting

Madison, WI

Apply

JOB DETAILS

SKILLS

Code Reviews, Communication Skills, CompTIA A+, Cost Estimates, Data Storage, Database Administration, Database Design, Database Management Software/Systems (DBMS), Detail Oriented, Establish Priorities, ITIL (IT Infrastructure Library), Information Technology & Information Systems, Information/Data Security (InfoSec), Interpersonal Skills, Memory Hardware, Microsoft Certifications, Microsoft Product Family, Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), Operations Management, Oracle PL-SQL, Performance Analysis, Performance Tuning/Optimization, Project Management Professional (PMP), Reporting Skills, Resolve Customer Issues, SQL (Structured Query Language), SQL Databases, Scripting (Scripting Languages), Testing

LOCATION

Madison, WI

POSTED

30+ days ago

REQUIRED SKILLS: (Need Majority; 8+ Years) * Advanced knowledge of Microsoft SQL Server (e.g., installation, configuration, support, and troubleshooting) * SQL database administration (e.g., database security, SQL and/or PL/SQL tuning, report writing, scripting, and task automation) * Effective and professional communication and interpersonal skills when dealing with a variety of customers, including executives * Highly self-motivated with the ability to effectively prioritize and execute tasks with strong attention to detail NICE TO HAVE SKILLS: * Microsoft SQL Server certification or similar * ITIL 4 Foundation certification or similar * CompTIA A+ certification or similar * PMP certification or similar INTERVIEW PROCESS: * Microsoft Teams interview with the camera on DESCRIPTION OF ROLE: Under the general guidance of the IT Operations Manager, this position is responsible for growing and operating the Information Technology program at the Wisconsin Department of Financial Institutions (DFI). This position serves as an expert resource and relies on extensive experience and judgment to plan and accomplish goals. This role coordinates physical changes to computer databases; codes, tests, and implements them, applying knowledge of database management systems. It involves designing logical and physical databases, reviewing database design changes to understand impacts on data storage (location, space, access method), and establishing database parameters. The role includes: * Coding database descriptions and identifiers, * Calculating optimal values for parameters (e.g., memory usage), * Specifying user access permissions (e.g., insert, replace, retrieve, delete), * Testing and correcting errors, * Creating production databases, * Monitoring database performance (e.g., distribution of records, memory usage), * Directing developers and analysts on changes to DBMS, * Reviewing and correcting code, * Answering user questions, * Coordinating with co-workers on cross-system impacts and cost estimates, * Performance tuning, and * Possibly training users. The incumbent is expected to be familiar with a wide variety of IT concepts, practices, and technologies. This position may lead and direct the work of others. This position is headquartered at the Hill Farms State Office building in Madison, WI.

About the Company

American Technology Consulting

Resume Resources

Free Resume Templates Free Resume Builder