Sr. Database AdministratorFull-time

Job Description

• This position administers Microsoft SQL Server and MySQL databases; responsible for database integrity, security, disaster recovery, and performance tuning;
• develops and enforces database administration and user standards and procedures; audits, modifies, and amends data in systems using SQL commands, hand-editing, and bulk import;
• oversees the scheduling of database projects, database and transaction log backups, notifications, and database replication between multiple SQL Servers and remote sites;
• assists developers in creating database objects and SQL commands to properly query databases; Fluent in backup / restore and log shipping procedures;

Creates documentation on database recovery and architecture.

• Consistently write scalable, extensible, and high performance code.
• Demonstrate a passion for solving complex problems and providing elegant solutions.
• Isolate, replicate, and resolve defects in a timely manner.
• Design and develop advanced database solutions including stored procedures, triggers and any other database objects.
• Monitor and maintain security and performance needs of relational databases.
• Monitor long running transactions and have the ability to optimize query executions with index tuning and optimized SQL coding techniques.
• Map out conceptual design patterns for hierarchies and other complex non- relational types of models.
• Install and maintain new versions and upgrades of SQL Server and MySQL, including large replication environments for data mining and mid-sized High Availability environments.
• Review and make recommendations for tuning existing environments.
• Design and tune new tables, databases and environments for both existing environments and new work.
• Monitor and support current and future environments.
• Create, maintain and update maintenance scripts for MySQL and SQL Server databases.
• Design, create and implement new database environments including high availability, replication setups and clustering.
• Write database documentation including data standards, procedures, and definitions for a data dictionary.
• Control access permissions and privileges.
• Develop, manage, maintain and test backup and recovery plans.
• Very good experience in capacity Planning.
• Communicate regularly with technical, applications and operational staff to ensure database integrity and security.
• Work with Product Management, Engineers, QA and Client Support to ensure product is delivered within quality metrics.
• Ensure Data Integrity complies with Clients’ needs and Release Criteria.
• Ensure functional and design specifications support the delivery of a reliable, stable, high-performance database system.
• Detail oriented with a strong ability to think abstractly and out of the box.
• Be results driven - prioritize, take initiative and take ownership.
• Accept changing priorities with the ability to rapidly adapt to change.
• Be able to work on a system that speaks natively to different database platforms, enabling individual users and enterprises to rapidly explore their data and author insightful visualizations.
• Help in designing and building Pulse Data Warehouses and contributes to the vision, design and implementation of our future Data Integration Hub
• Translate client user requirements into Data Flows and Data Mapping
• Identify business and technical impacts of user requirements and engage Product Team members and provide suggestions and solutions.
• Other duties as required

Qualifications

Required Skills and Experience :

• 5+ years of related professional experience.
• Ability to lead and coordinate with teams
• Ability to write and execute complex SQL queries to extract / process data.
• Must have a deep understanding of database structures, theories, principles, and practices.
• Experience in Agile methodologies and processes in the software field.
• Deep knowledge of various data sources (government, open source APIs, point-of-sale, proprietary sources, etc.) and experience in linking them.
• Must have experience with very large datasets.
• Experience analyzing data and information to drive decisions.
• Strong experience with Cloud Technologies.
• Knowledge and experience with computer hardware including Servers, Networks, SAN Technologies, I / O subsystems, etc.
• Experience in Web services and API integrations and Data Integrations.
• Understanding of, and experience with, server-client computing and relational database environments.
• Experience with data management and data processing flowcharting techniques.
• Very strong knowledge of reporting and query tools and practices.
• Good understanding of the organizations goals and objectives.
• Good interpersonal, written, and oral communication skills.
• Ability to present ideas in user-friendly language.
• Self-motivated and directed, with keen attention to detail.
• Able to prioritize and execute tasks in a high-pressure environment.
• Good written and oral communication skills.
• Demonstrated ability to create database and security standards for SQL Server and MySQL environments.
• Demonstrated ability to develop stored procedures, triggers, indexes, and views and any other database objects in support of application development projects.
• Experience in developing and maintaining relational structures including backup / recovery, log shipping procedures.
• Very strong experience with the setup, configuration, maintenance, and trouble-shooting with MySQL and SQL Server replication environments.
• Very strong experience with various MySQL engine types, include InnoDB, MyISAM, MEMORY.
• Very strong experience with performance tuning MySQL and SQL Server databases for a variety of environments and user requirements.
• Very good experience in UNIX, Linux and similar platforms.
• Excellent team player with skills to effectively communicate with a diverse team.
• Must be ability to handle conflict, difficult situations, and urgent issues in a professional manner.
• Self-starter with a strong sense of ownership and good follow through skills who displays a passion to test and deliver high quality software.
• Experience in Database Architecture, Design and Implantation.

Education Required :

• BS Degree in one of the following subject areas : Computer Science, Business Administration, Information Technology or related field preferred
30+ days ago