At least 5 years of related professional experience.
Ability to lead and coordinate with teams.
Ability to write and execute complex SQL queries to extract and process data.
Deep understanding of database structures, theories, principles, and practices.
Experience with Agile methodologies and processes in the software field.
Deep knowledge of diverse data sources, including government, open-source application programming interfaces, point-of-sale, and proprietary sources, and experience linking them.
Experience working 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, storage area network technologies, and input/output subsystems.
Experience with web services, application programming interface 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.
Ability to present ideas in user-friendly language.
Ability to prioritize and execute tasks in a high-pressure environment.
Demonstrated ability to create database and security standards for Microsoft SQL Server and MySQL environments.
Demonstrated ability to develop stored procedures, triggers, indexes, views, and other database objects for application development projects.
Experience developing and maintaining relational structures, including backup and recovery and log-shipping procedures.
Very strong experience setting up, configuring, maintaining, and troubleshooting MySQL and Microsoft SQL Server replication environments.
Very strong experience with MySQL storage engines, including InnoDB, MyISAM, and MEMORY.
Very strong experience tuning the performance of MySQL and Microsoft SQL Server databases for varied environments and user requirements.
Very good experience with UNIX, Linux, and similar platforms.
Ability to handle conflict, difficult situations, and urgent issues professionally.
Experience in database architecture, design, and implementation.
Responsibilities
Administer Microsoft SQL Server and MySQL databases.
Maintain database integrity, security, disaster recovery, and performance tuning.
Develop and enforce database administration and user standards and procedures.
Audit, modify, and amend system data using SQL commands, manual editing, and bulk import.
Oversee scheduling of database projects, database and transaction-log backups, notifications, and database replication between multiple SQL Servers and remote sites.
Assist developers in creating database objects and SQL commands to query databases properly.
Create scalable, extensible, and high-performance code.
Isolate, replicate, and resolve defects in a timely manner.
Design and develop advanced database solutions, including stored procedures, triggers, and other database objects.
Monitor and maintain the security and performance of relational databases.
Monitor long-running transactions and optimize query execution through index tuning and optimized SQL coding techniques.
Map conceptual design patterns for hierarchies and other complex non-relational data 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 existing environments and make tuning recommendations.
Design and tune new tables, databases, and environments for 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 database environments, including high availability, replication setups, and clustering.
Write database documentation, including data standards, procedures, definitions, and data-dictionary content.
Control access permissions and privileges.
Develop, manage, maintain, and test backup and recovery plans.
Perform capacity planning.
Communicate regularly with technical, application, and operational staff to ensure database integrity and security.
Work with Product Management, Engineering, Quality Assurance, and Client Support to deliver products within quality metrics.
Ensure data integrity complies with client needs and release criteria.
Ensure functional and design specifications support a reliable, stable, high-performance database system.
Support systems that communicate natively with different database platforms so users and enterprises can explore data and create visualizations.
Help design and build Pulse data warehouses and contribute to the vision, design, and implementation of the future Data Integration Hub.
Translate client user requirements into data flows and data mappings.
Identify business and technical impacts of user requirements and engage Product Team members with suggestions and solutions.
Perform other duties as required.
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
Additional Information
All your information will be kept confidential according to EEO guidelines.