Job Description :
Position Summary: This position requires strong experience in both database architecture and administration of MySQL databases. The Database Administrator will drive strategy and innovation for enterprise data management utilizing relational database technologies. Additionally, they will provide technical leadership while working directly with project teams to architect, design, implement and continuously improve database solutions. The Database Administrator is also responsible for installing, configuring, maintaining and monitoring performance and capacity of all databases in our production, development, and QA environments.
Essential Duties and Responsibilities: include the following and other duties may be assigned:
Work directly with project stakeholders to identify and understand business, technology, and architecture requirements
Design and document databases ensuring system scalability, security, performance and reliability, including creation and enforcement of development standards
Provide technical leadership and guidance to project team members
Participate in hands-on development of systems solutions including SQL query development and optimization
Development and modification of data extraction, transformation and loading procedures as required
Perform data modelling
Analyze system performance and do root cause analysis of problems, perform database tuning and implement improvements
Install and perform routine maintenance on new and existing databases including patch and release management
Monitor database space and capacity, estimate sizing and growth requirements and provide remediation recommendations to management
Design and implement data security procedures including encryption methods
Design and manage database replication, backup and recovery processes
Research and evaluate emerging technologies for applicability and adoption
Qualifications: To perform this job successfully, the individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions:
Ability to work independently, take initiative, and contribute to new ideas required in a diverse, fast-paced, deadline-driven team environment
Experience installing, configuring, maintaining and monitoring MySQL databases
Experience measuring, analyzing and tuning the performance of MySQL database applications
Detailed knowledge of logical and physical data modelling and design based on customer requirements
Experience developing and implementing data replication schemes
Experience with middleware technologies such as ODBC and JDBC, and with ORMs such as Hibernate and Entity Framework
Experience measuring, analyzing and tuning the performance of MySQL database applications
Experience writing and optimizing SQL queries
Experience using Unix/Linux/Windows operating systems and shell scripting
Knowledge of database security, encryption, SSL and user profiles
Knowledge of Business Intelligence/Data Warehouse solutions and ETL tools
Experience with cloud deployment and SaaS a plus
Microsoft SQL Server experience is desirable
PHP experience a plus
Knowledge of PCI DSS requirements is a plus
Analytical skills, with strong problem solving ability
Excellent written and verbal communications skills
Education/Experience:
Bachelor’s degree or higher in Computer Science or related field
7+ years database administration experience
5+ years database architectural experience
Experience with MySQL databases is essential
Experience writing SQL queries is essential
Experience with MS SQL server and/or MongoDB is desirable
Knowledge of Payment processing preferred