Database Administrator / Modeler

Hartford, CT

30+ days ago

Job Description

Looking for Industry-Leading Database Administrator / Modeler:

Are you an expert in database design and development who has a solid working knowledge of one more analytic tools including SAS, Alteryx, Tableau, Qlikview and programming languages such as C++, .NET, R, Java, Python, Perl etc.? Do you enjoy providing clients with the most efficient, technology-based solutions available? Are you committed to converting leading edge ideas into tangible results? If your answer is yes, please read on…

The Data Administrator/Modeler will be responsible for the design, creation, maintenance, backup, restore, and upgrade of Microsoft SQL Server (64 bit, 2005, 2008, 2012) databases as well as Oracle 11g client development databases. The Data Administrator/Modeler will manage third party external data sources, maintain technical relations with the vendors and build databases and applications to allow client service teams to access the data for enrichment and analytics purposes.

Responsibilities:

Design, size and document database architecture.
Build database schema, tables, procedures and permissions.
Set up data sharing and disk partitioning.
Create shell scripts for task automation.
Analyze, consolidate and tune database for optimal efficiency and performance.
Monitor systems and platforms for availability.
Oversee backup, clustering, mirroring, replication and failover.
Restore and recover corrupted databases.
Install and test upgrades and patches.
Implement security and encryption.
Troubleshoot and resolve production/development support issues.
Perform database management software system upgrades.
Control user access to databases and ensure connectivity to databases.
Develop disaster recovery procedures and documentation.
Design and implement database security model.
Fulfill ad hoc data analysis and data matching requests.
Review SQL code for compliance with coding and performance standards.
Perform database management software system upgrades.
Manage third party external data sources used by analytics teams for analytics, data enrichment and matching.
Represent advisory teams in client side technical meetings.
Translate business requirements into a logical and physical data models.
Develop and enhance database standards and integration with analytics tools.
Work closely with cross-functional development teams to help establish and enforce data quality standards and documentation across the analytics function.
Maintain relationships with external data providers and act as technical and data knowledge liaison with data providers.
Maintain knowledge of various data sources serving as the database expert and primary liaison for client teams.
This position may require up to 25% travel.

Qualifications:

8 or more years of database administration and application development experience supporting Microsoft SQL Server, Oracle 11g and data analytics tools and technologies.
Long-term hands on experience as a SQL Server/Oracle DBA in both a Transactional and Data Warehousing environment in addition to extensive data modeling experience.
Knowledge and understanding of Oracle 10g, 11g including Import/Export functionality
Experience installing, configuring, troubleshooting, and supporting Windows 2008-2012 and Oracle 11g Servers.
Practical experience using SQL Server 2008-2012 database management tools, which includes Enterprise Manager and SQL Server Management Studio, Query Analyzer, SQL Server Profiler and Data Transformation Service and/or SQL Server Integration and Reporting Services.
Experience building a Server Cluster and installing SQL Server in a Clustered environment (Active/Active) for all versions of SQL Server.
Logical and physical database design.
Experience with Quest Lite-speed for Backup compression.
Well versed with writing and tuning PL-SQL procedures and DTS/SSIS packages.
Knowledge of SAS and Alteryx products is highly desired; however, experience supporting analytics type projects is a requirement
Experience with store databases columnar (such as Kognitio) and working in a massively parallel processing (MPP) environment a plus
Proficient usage and experience with advanced query language.
Proficiency in solution development and methodology using industry standard tools.
MCSE or MCDBA Certification preferred but not required.
Exceptional written and oral communication abilities including strong interpersonal skills with the ability to present ideas in user-friendly language both written and oral
Strong technical documentation skills
Successful experience working in a team-oriented, collaborative environment
Proven analytical and problem-solving abilities
Bachelor’s degree in computer information systems, science, engineering or equivalent field.

Numbers & Facts

Location

Hartford, CT

Skills

Access Controlunmatched
Analysis Skillsunmatched
C++ Programming Languageunmatched
Code Reviewsunmatched
Coding Standardsunmatched
Communication Skillsunmatched
Cross-Functionalunmatched
Cryptographyunmatched
Customer Relationsunmatched
Customer Support/Serviceunmatched
Data Administrationunmatched
Data Analysisunmatched
Data Modelingunmatched
Data Qualityunmatched
Data Recoveryunmatched
Data Transformation Services (DTS)unmatched
Data Warehousingunmatched
Database Administrationunmatched
Database Architectureunmatched
Database Designunmatched
Database Management Software/Systems (DBMS)unmatched
Database Optimizationunmatched
Database Programmingunmatched
Database Programming Languagesunmatched
Database Technologyunmatched
Disaster Recoveryunmatched
Disk Partitioningunmatched
Documentationunmatched
Failoverunmatched
Identify Issuesunmatched
Import/Exportunmatched
Industry Standardsunmatched
Information Scienceunmatched
Information Technology & Information Systemsunmatched
Information/Data Security (InfoSec)unmatched
Interpersonal Skillsunmatched
Javaunmatched
MCDBA - Microsoft Certified Database Administratorunmatched
MCSE - Microsoft Certified Systems Engineerunmatched
Microsoft .NETunmatched
Microsoft SQL Serverunmatched
Microsoft SQL Server DBA (Database Administration)unmatched
Microsoft Windows System Administrationunmatched
Oracle 11iunmatched
Oracle Databaseunmatched
Oracle Database 10gunmatched
Oracle PL-SQLunmatched
Parallel Computingunmatched
Perl Programming Languageunmatched
Presentation/Verbal Skillsunmatched
Problem Solving Skillsunmatched
Procedure Developmentunmatched
Production Supportunmatched
Programming Languagesunmatched
Public/Media/Press/Analyst Relationsunmatched
Python Programming/Scripting Languageunmatched
Qlikunmatched
Quality Metricsunmatched
Query Analysisunmatched
Quest LiteSpeedunmatched
R Programming Languageunmatched
Replication and Remote Mirroringunmatched
Requirements Managementunmatched
SQL (Structured Query Language)unmatched
SQL Server Integration Services (SSIS)unmatched
SQL Server Reporting Services (SSRS)unmatched
Scripting (Scripting Languages)unmatched
Server Clustersunmatched
Server Supportunmatched
Software Developmentunmatched
Software Patchesunmatched
Software Upgradesunmatched
Statistical Analysis System (SAS)unmatched
Systems Administration/Managementunmatched
Tableauunmatched
Team Playerunmatched
Technical Writingunmatched
Unix Shell Programmingunmatched
Vendor/Supplier Relationsunmatched
Willing to Travelunmatched
Windows Server 2008 R2unmatched
Writing Skillsunmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder

Database Administrator / Modeler

Job Description

Numbers & Facts

Skills

Be found by employers

Level up your application

Professional resume templates

Free resume builder