Vantiv Principal DBA in Lowell, Massachusetts
Do you want to see your work have a direct impact on the business? Do you enjoy working with a top-notch team and being an integral part of a profitable and growing company? If so, then Vantiv is the place for you. Vantiv provides a leading in-house payment management platform (SaaS -- Software as a Service) that serves high-volume merchants such as GoDaddy.com and Overstock.com. Our customers demand high availability, reliability, and quality. As our new Database Administrator, you will help to deliver these essentials by ensuring the smooth operation of all DB2 development, performance improvement, SAN storage, shell scripting and maintenance of production database systems. Whether your expertise lies in DB2 or Oracle, we'd love to hear from you if you're a smart, seasoned Database Administrator with experience building and supporting high-uptime RDBMS systems in a production environment. This senior-level position spans all of the functional areas in IT and reports to the Manager of Database Architecture.
Integrity of Production Databases
Work with Infrastructure, Architecture, and Engineering to identify and correct performance and scalability problems in the production databases
Own the "care & feeding" aspects of the DB2 production databases -- performance monitoring, re-orgs, efficient backup strategy, updating index statistics, etc.
Tune the production database, and work with Infrastructure to best utilize available hardware
Growth Of Database Architecture
Design and implement database solutions to architectural goals such as: second site replication, 10x growth in transaction volume, data warehouse / reporting database
Work with the Platform Technology Team in prototyping solutions to different architectural problems
Consult with Linux & Networking teams on hardware purchasing strategies to help them grow the database architecture
Development and Logical Design
Work with the Platform Team and Engineering to oversee the design of critical areas of the data model
Provide support and mentorship to engineers in all aspects of logical database design, creating and tuning queries, etc.
Administer all databases in test and development environments
4+ years' experience with DB2 or Oracle in a Linux/Unix environment, including design, implementation, and tuning.
Strong problem solving and analytical skills
Experience with DB2 or Oracle performance tuning and troubleshooting tools and techniques
Experience building and supporting high-uptime RDBMS systems in a production environment
Excellent verbal and written communication skills
Ability to effectively prioritize and execute tasks within a dynamic environment
Continued awareness of developing and emerging technologies with a willingness and ability to learn new technologies
DB2 LUW V9.7, V10.5 , VLDB for OLTP, data warehousing, shell and perl scripting a plus
BS in IT or Computer Science