Database Administrator

Location: North Haven, Connecticut, United States

Department: Professional Services

Workplace: on_site

Employment Type: contract

Description

Responsible for the continuous improvement and upkeep of an enterprise reporting database, which includes report creation and performing ad hoc queries. Analyzes business reporting requirements, designs a data structure to meet those needs, assesses available data sources including external files, and organizes data into a format appropriate for the proposed solution. Develops, maintains, and oversees daily, weekly, and monthly data import processes using SSIS or other relevant technologies. Documents and updates the data warehouse mappings regularly. Implements security protocols to maintain proper database protection. Serves as a cross-trainer and provides backup support for other IT department functions.

This is a contract-to-hire opportunity with one of Verinext's clients. The position requires five days/week onsite. Once every 5-6 weeks will need to be on call on a Sat for a half day

Requirements

• Identify data sources, design database schemas, map files to these schemas, integrate data using ETL processes, monitor daily data loads, document data flows, and ensure database security.
• Execute ad hoc queries and stored procedures for developers, and develop standardized reports for business users.
• Create and update databases, products, and reports based on client requirements and functional specifications.
• Ensure the integrity and availability of databases, troubleshoot database issues, and implement data backup and recovery solutions.
• Design, develop, and manage relational databases to optimize performance and maintain data security.
• Utilize advanced SQL expertise to generate and write reports supporting analytics.
• Perform other duties as assigned.

Qualifications and Requirements:

• Experience:  3-5 years of similar or related experience.
• Education:  Appropriate industry experience or a (B.S. or M.S.) in Computer Science or Computer Engineering.

Technical Skills:

• SQL Expertise: Proficient in using SQL for querying and managing databases effectively.
• Database Design: Knowledgeable in designing database schemas, including normalization and indexing techniques.
• Database Management Systems (DBMS): Hands-on experience with platforms such as MySQL, PostgreSQL, SQL Server, and SQL Server Integration Services (SSIS).
• Data Modeling: Skilled in developing data models that align with and support business processes.
• Performance Optimization: Competent in enhancing database performance and resolving related issues.
• Reporting: Utilize SQL proficiency and reporting tools like CRMBI to create, write, and optimize reports that address business requirements.
• Backup and Recovery: Well-versed in data backup procedures, recovery strategies, and disaster recovery planning.
• ETL Processes: Experienced in managing Extract, Transform, Load (ETL) operations for seamless data integration.
• Security: Familiar with database security measures to ensure the protection of data integrity and privacy.

• Project Management: A fundamental knowledge of project management principles is required.
• Adaptability: Openness to learning new technologies and adjusting to evolving requirements is essential.
• Documentation: Capability to clearly document database structures, processes, and procedures.
• Interpersonal Skills: High levels of trust and diplomacy are necessary, along with standard courtesy and tact. The role involves motivating or influencing others, which demands both diplomacy and trust.

**ETL, SNOWFLAKE, Kubernetes, Azure Shop, T-Sequel, Sequel Server, Data Engineer, Sequel Server**

Benefits

• Retirement Plan (401k, IRA)
• Work From Home
• Health Care Plan

Equal Employment Opportunity:
The Company is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other protected characteristic under applicable law.

Employment Disclaimer:
This job description is not intended to create an employment contract. Employment with the Company is at-will, meaning employment may be terminated by either the employee or the Company at any time, with or without cause or notice, subject to applicable law.

Duties Subject to Change:
The Company reserves the right to modify, add, or reassign duties and responsibilities at any time based on business needs.

Confidentiality:
This position may require access to confidential or sensitive information. Employees are expected to maintain confidentiality and comply with all Company policies and applicable security requirements.