Sr. Database AdministratorFull time

Job description

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

Required Skill Profession

Computer Occupations