Database Administrator / Modeler

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 :