Location : Lawrence, KS

Duration : 6 Months CTH

Experience : 5-7 Years

Position Summary:

• The Database Administrator is responsible for complete database management, primarily supporting multiple application development teams to implement and support data-oriented application efforts.
• The DBA position also participates in the development and design of database strategies, system monitoring, capacity planning, backup and recovery, security and auditing, performance tuning/monitoring, installations, and upgrades.

• Solid understanding of database design principalsAt least 5 years of experience as a DBA with a minimum 1 year experience with PostgreSQL 8.3, 8.4Solid understanding of query execution plansGood SQL scripts skill including SPs, PSQL scriptingGood performance tuning skillsAbility to proactively identify, troubleshoot and resolve live database systems issues.
• Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore
• Experience in replicationHands-on experience on database administration, backup recovery and troubleshooting in co-location environments
• Experience with NoSQL databases (Mongo, Cassandra, Hadoop, Redis) preferred
• Experience with Database refactoring/migration tools a plusStrong experience with the following technologies:Operating Systems: Linux and WindowsProgramming Languages: Python and Shell ScriptingPreferred experience with: TOAD, SQL Developer, PgAdminStrong experience with load balancing and high volume, high availability environments
• Minimum 3 years experience with software development lifecycle (SDLC)Minimum 1 year experience working on Agile Methodologies / FrameworksExperience in planning, scope identification, estimating work effort and producing quality deliverables on time and within budget
• Skills:Strong analytical and problem solving skills with ability to clearly articulate solution alternativesAbility to coordinate multiple projects and participate in varying levels of programming effort.
• Team PlayerAbility to gather business requirements and develops the conceptual design and technical design for multiple projects concurrently.
• Ability to solve complex issues that cross team boundaries.
• Ability to troubleshoot systems, performance and environmental concerns.
• Ability to communicate effectively with a variety of audiences including project management, developers, and business systems analysts.
• Knowledge:Strong working knowledge of Unix/Linux systems administration and troubleshooting
• Strong knowledge and hands on experience related to mission critical backup and recovery

• Works with the development, IT, and PMO teams to maintain all development and test database instancesWorks with DevOps and Developers to build and implement automated processes for migration of schema changes and data changes through development, test and productionAssists the development team as necessary with query optimizationIdentifies database requirements; analyzing department applications, programming, and operations; evaluating existing systems and designing proposed systems; database creation and maintenance, ongoing performance optimization, and end user support.Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specificationsMaintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware productsAssists users by conducting training; providing information; resolving problemsSupports database functions by designing and coding utilitiesMaintains quality service by establishing and enforcing organization standards including change management