Database Associate located in Milwaukee, WI. Our client is a government agency looking for high-quality talent to make a difference. They are known to respect a traditional work week and often extend contracts for added job security and stability.

Job Description:

• The Database Associate provides support for the Information and Technology Management Division (ITMD) Microsoft SQL Server database servers, storage, client software, and configuration to support and improve ITMD's database systems.
• The Database Associate maintains various mission-critical production databases.
• Working in a team environment, the person in this position continually employs strategies for improving the database operating efficiency.

Responsibilities:

• Monitor and maintain database server hardware, virtualized servers, operating systems, and database software.
• Provide functional support in areas such as user accounts, SQL queries, batch data loads, table and view definitions, and end-user support.
• Provide general assistance, maintenance, backups, and database administration.
• Perform backup procedures for operating systems and databases to ensure recoverability.
• Provide general assistance, maintenance, and database administration.
• Safeguard the integrity of databases, including daily monitoring to ensure high availability of production and carrying out performance tuning and troubleshooting.
• Recover and restore production, development, and test databases.
• Perform relational database management system (RDBMS) tasks related to MS SQL Server and Oracle.
• Create and maintain accurate documentation.
• Write, edit, and test SQL batch files and use Procedural Language/Structured Query Language (PL/SQL).
• Provide PeopleSoft application support to end-users.
• Schedule and automate database processing and tasks.
• Stay apprised of changing technology; research and test application and support software and recommend infrastructural changes to improve the operating efficiency of the databases.

System Administration:

• Interact with vendors for efficient implementation/operation of new software products or systems and for resolution of any adaptation issues.
• Interact with automation management, network administrators, system analysts, and software engineers to assist in resolving problems with software products or departmental software systems.
• Interact regularly with managers, users, vendors, and agencies to field queries and questions.

Knowledge, Skills, Abilities & Other Characteristics:

Technical:

• Knowledge of and skill using SSRS (SQL Server Reporting Services).
• Ability to administer, support, and maintain MS SQL Server databases.
• Ability to use MS Windows Server and Linux.
• Ability to generate database reports and queries.
• Ability to manage servers in a storage area network (SAN) and virtual environment.
• Ability to troubleshoot complex database-related issues.
• Ability to create and maintain system documentation.
• Ability to create detailed plans for testing and implementation that others can understand and use effectively.

Communication:

• Written communication skills and documentation skills to write general correspondence as well as detailed reports, specifications, and procedures that can be used to create programs and interfaces.
• Verbal communication skills to be able to train and present technical information to users in a constructive and effective manner.

Interpersonal and Customer Service:

• Ability to interact with and work cohesively with other staff, department heads, officials, outside agencies and vendors.
• Ability to work well independently and to function as part of a team.

Critical Thinking, Planning, and Judgment:

• Ability to meet strict deadlines to deliver database reports.
• Ability to take initiative to solve complex problems with minimal supervision.
• Ability to recognize when a problem must be addressed at a higher level.
• Ability to remain calm under pressure and when responding to emergency situations.
• Ability to maintain confidentiality and have high ethical standards.
• Responsible stewardship of resources.

Top Skills & Years of Experience:

4 to 7+ years of experience in the following:

• Bachelor's degree in computer science, management information systems (MIS), mathematics, or a closely related field from an accredited college or university.
• Two years of professional experience administering, supporting, maintaining, and restoring SQL database applications, performing duties related to the essential functions of this position.

Nice to have:

• Experience administering MS SQL Server database(s) and/or being an MS SQL Server Database Administrator (DBA).
• Experience using MS Windows Server and Linux.
• Experience managing servers in a storage area network (SAN) and virtual environment.
• Related certifications, such as Microsoft SQL Server.

About MARS Solutions Group:

MARS Solutions Group provides a range of opportunities for meaningful work by understanding that employment fit is a combination of people, process, and technology. We leverage our experienced and compassionate team to bring humanity to matching you with the right advanced technology role, and stay connected with you to help you attain your professional goals.