Database Engineer iContact
Information Technology Morrisville, NC, United States Database Engineer
Since 2003, iContact has helped small and medium businesses share their stories, ideas, and products through email and social marketing. We take what we know about our favorite small and medium businesses?a trendy boutique hotel in South Beach, the online poster store that helps us decorate our cubicles, even the local coffee shop you'll find us in on Saturday?and we build the online marketing features we know those businesses need to succeed. We then pair our tools with award-winning support and expertise, so our customers never have to go it alone. And we top it all off with great personality, energy, and a commitment to creating a positive wake in our community. iContact is a service of Vocus.
Vocus (NASDAQ: VOCS) is a leading provider of cloud-based marketing and PR software that helps businesses reach and influence buyers across social networks, online, and through the media. Vocus provides an integrated suite that combines social marketing, search marketing, email marketing, and publicity into a comprehensive solution to help businesses attract, engage, and retain customers. Vocus is used by more than 120,000 organizations worldwide and is available in seven languages. For more information, please visit www.vocus.com.
We are looking for a Database Engineer whose primary responsibility is to make sure that our MySQL databases are brilliantly designed, and are performing like a well-oiled machine. This position will be a part of the team that analyzes our (and fixes) our schema to make sure it's well designed, optimized for performance and scalability, and meets all of the standards that we will help to set. The Database Engineer will assist the Data Warehouse Engineers in building a data warehouse and a high-performance reporting solution with that data, so an understanding of how transactional data becomes analytical data would be extremely useful.
We're looking for an individual that can handle working in a fast-paced Agile environment; the ideal candidate will have a strong dedication to process, standardization, documentation. Such an individual should view producing good documentation and maintaining tight configuration management as mission critical activities, because as any good database person knows: database designs are a lot harder to change than software designs once they make it in to production. The Engineer needs to exercise independent judgment in developing methods, techniques, and evaluation criteria for obtaining results. This position requires a self-starter, willing to take on large and small challenges while operating under general supervision.
? Design, deploy and maintain all aspects of MySQL databases.
? Work with development teams to make the best schema designs that balance feature requests with performance concerns.
? Monitor and tune the performance of MySQL database servers.
? Analyze and make decisions about optimization of existing schema and queries for all database instances.
? Troubleshoot, perform problem isolation, and correct problems discovered in production databases.
? Design maintainable databases for highly available and reliable solutions to meet service levels.
? Follow change management procedures and help to create policies and best practices for all database environments.
? Ensure the development and use of an effective preventive maintenance program suitable to meet the operation objective of '99.9% availability'.
? Reduce or eliminate production problems by analyzing production usage information and using that information to come up with better designs.
? Frequently called upon to solve problems; has strong problem solving skills and the ability and desire to learn new technologies rapidly.
? Able to deal effectively with internal and external groups including development teams and vendors.
? Perform other duties as assigned
? Bachelor's Degree or equivalent experience in a Computer Science, Technical or related discipline
? 5 to 7 years of relevant experience
? Experience in database performance analysis, tuning and capacity planning.
? Ability to analyze and change schema design and articulate performance impacts.
? Experience working in a SaaS environment.
? Knowledge of database scalability principles.
? Ability to work with development teams in an Agile environment to develop new features and modify existing features with a 'design for the future' mentality for the schema.
? Some knowledge of database administration in a high-volume, highly-available Linux-based environment.
? Hands-on database troubleshooting experience, including tracking down problematic queries and configurations.
? MySQL specific implementation experience. While SQL is fairly standardized, knowledge of the specificities of MySQL is preferred.
? Interest or experience in using alternative database solutions, such as NoSQL technologies.
? Grasp of Linux system administration fundamentals in relation to applications and databases.
? Ongoing effort to maintain skills and knowledge at the state of the art level.
? Ability to maintain confidentiality with sensitive customer and internal information.
? Strong interpersonal, written and oral communication skills
? Proven ability to effectively prioritize and execute tasks in a team-oriented, collaborative work place
? Self reliant, articulate, approachable and comfortable with a rapidly changing environment
||Raleigh, NC |