Database Administrator

Verinext•North Haven, CT

3d•Onsite

About The Position

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

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

Responsibilities

Continuous improvement and upkeep of an enterprise reporting database
Report creation and performing ad hoc queries
Analyze business reporting requirements and design data structures
Assess available data sources including external files
Organize data into a format appropriate for the proposed solution
Develop, maintain, and oversee daily, weekly, and monthly data import processes using SSIS or other relevant technologies
Document and update the data warehouse mappings regularly
Implement security protocols to maintain proper database protection
Serve as a cross-trainer and provide backup support for other IT department functions
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