Database Administrator / Modeler - Gamen Group
Hartford, CT
About the Job
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.
Source : Gamen Group