Database Administrator

Database Administrator North Haven, CT Job Details Contract 1 day ago Benefits 401(k) Work from home Qualifications Data model design Performance tuning Computer science Data Integration (Data management) Computer Science Data modeling projects Technical documentation Bachelor of Science Database backup and recovery Mid-level Database security management Technology security practices 3 years SQL Data Architecture Design (Architecture design skills) Database management Project management Bachelor's degree Continuous improvement Master of Science Requirements analysis Improving database performance Computer Engineering Master's degree in computer science SSIS Business requirements Master's degree in computer engineering Bachelor's degree in computer science Ad-hoc reporting Analytics IT disaster recovery planning Full Job 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. 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, Postgre

SQL, 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. 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.