InvenTrak™ Point of Sale Products

InvenTrak™ Login
Forgot Password? \| Register

DBA

DBA Job Description:

The Database Administrator will interface with multiple members of the development team on a technical and customer service level. The DBA should demonstrate an enterprise view and understanding of systems and technologies. The DBA is responsible for database design, installation, maintenance, monitoring, and upgrades of database systems. This includes documenting systems in accordance with company standards. The DBA serves as a point of escalation and review for issues or concerns identified by the customer or the monitoring system on a 24x7 basis.

The DBA will help develop solutions to improve database environments and enhance server reliability and performance. The DBA provides sales support to assist in determining customer needs and projecting requirements based on customer input. The DBA is responsible for designing database solutions to best meet customer needs, as well as making and presenting recommendations to improve existing infrastructures.

Responsibilities:

• Estimate MySQL database capacities; develop methods for monitoring database capacity and usage
• Transaction SQL and stored procedure development.
• Function as point person for troubleshooting MySQL server, database instances, DB API, and server system performance and administration-related issues.
• Performance tuning for the company’s databases; database and SQL tuning
• Implement and maintain disaster recovery plans for critical production databases and applications
• Provide script automation for performance monitoring, maintenance, replication, cluster status and failover operations, and disaster recovery mechanisms.
• Provide software and hardware system architecture, design, implementation, support and tuning to create a stable, high performance, multi-database service environment.
• Identify and troubleshoot database performance issues, including application layer and system level analysis, to ensure optimal performance and scalability.
• Oversee customer facing production databases and data warehouse systems within a 24/7 environment
• Ensure 24/7 DB and DB API service uptime, and provide 24/7 escalated on-call support on rotation.
• Establish policies and procedures pertaining to the database management, security, maintenance and utilization.
• Assist customers with their data integration efforts.

Qualifications:

• Min. BS Computer Science or equivalent

• Min. 2 years experience as a DBA or equivalent. Must have experience in MySQL, performance tuning in a customer facing production environment (24x7x365) with increasingly complex DBA assignments meeting the 24x7 operational requirements

• Experience designing, developing, tuning, optimizing, deploying and updating multiple MySQL instances with critical 100% uptime requirements

• Experience with database administration, storage management, database disaster recovery solutions, performance monitoring, tuning, database integrity & security

• Experience with and knowledge of database programming concepts including SQL, stored procedures, and triggers

•Experience with analyzing and troubleshooting the interaction between databases, operating systems, and applications particularly in the areas of performance and resource usage

• Demonstrated knowledge and understanding of DB scoping, profiling, scaling and fault tolerant operation

• Experience with open source/Linux development and production environment is CRITICAL, including knowledge of storage technologies with Linux: RAID, NFS, SAN, etc.

• Ability to provide support for development, test, and production environments, including setup of new servers, databases, and objects within the database

• Working knowledge of web technologies (HTML, XML, wikis, content management systems)

• Strong understanding of performance optimization at query, schema, service, OS, and hardware level. Knowledge of system H/W trade-offs including CPUs, RAM, RAID and fault tolerant architectures

• Ability to work independently; prioritizing and managing workload autonomously in a rapid-paced distributed environment

• Excellent written and verbal English language skills

If you are interested please email This e-mail address is being protected from spam bots, you need JavaScript enabled to view it