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 hardware including Servers, Networks, SAN Technologies, I/O…