Sr. Database Administrator

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

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…