Please see job description below.
The Advisory Board Company
Keywords: Postgres, MySQL, SQL Server, Linux, Windows
What You'll Be Doing:
- Manage Postgres and SQL Server databases databases through multiple product lifecycle environments, from development to mission-critical production systems, for applications with data warehouse and OLTP components
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
- Provide 24x7 support for critical production systems on an on-call rotation basis
- Perform scheduled maintenance and support release deployment activities after hours
- Refine and automate regular processes, track issues, and document changes
- Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
- Assist developers with complex query tuning, schema refinement and index management
- Assist in development of project plans and task lists
- Share domain and technical expertise, providing technical mentorship and cross-training to peers
- Bachelor’s Degree
- 5+ years of professional experience
- Experience operating a large scale production database environment
- Technical and troubleshooting skills with relational databases (Postgres, SQL Server)
- Experience in independently performing root cause analysis and coming up with recommendations
- Experience in performance tuning, query optimization, replication techniques, clustering, LDAP authentication, partitioning and security issues
- Experience with backups, restores, recovery
- Experience with database security concepts, including access, auditing, and encryption.
- Knowledge and experience in Open Source solutions to include vetting patches, applying patches to the database and the open source tools, libraries, and daemons.
- Knowledge of High Availability and Disaster Recovery for Postgres and Mysql
- SQL Development (psql and tsql) experience with ability to write and troubleshoot SQL code (stored procedures, functions, tables, indexes, constraints)
- Experience with system monitoring tools
- Bachelor’s Degree in Computer Science, Engineering or related field
- Professional experience as a DBA working on Window and Linux platforms
- Experience with logical and physical data modeling
- Postgres certification
- Knowledge of Industry standard ETL and BI tools and exposure to data warehousing architectures, service oriented architectures.
- Experience in healthcare or a HIPAA compliant environment including data de-identification
- Database operations experience in an Agile development environment
- Experience with other relational databases (Oracle, MySQL) and NoSQL databases.
- Ability to lead others as well as guide and mentor less experienced personnel
- Ability to troubleshoot problems that arise
- Ability to organize and plan work independently
- Ability to work in a rapidly changing environment
- Ability to multi-task between different activities and teams
- Ability to communicate effectively both orally and written
About The Advisory Board Company:
The Advisory Board Company (NASDAQ: ABCO) is a global technology, research and consulting firm
partnering with 180,000 leaders in 4,500+ organizations across health care and higher education. We combine the expertise of our 3,000+ employees around the world to find solutions to the most pressing challenges in health care. Our performance technology
products offer user-friendly, Web-enabled dashboard platforms with tremendous analytic capabilities that generate more than $500 million in realized value annually for our members. These solutions focus on strategically important areas, including physician
alignment, revenue cycle, accountable care, and surgical profitability. We thrive on innovation and the knowledge that we are creating real change in an industry that matters to everyone.
Consistent with our belief that our employees are our most valuable resource, The Advisory Board Company offers a competitive benefits package.
- Medical, dental, and vision insurance, dependents eligible
- 401(k) retirement plan with company match
- 20+ days paid time off and 14+ paid company holidays
- Daytime leave policy for community service or fitness activities (up to 10 hours a month each)
- Wellness programs including gym discounts and incentives to promote healthy living
- Dynamic growth opportunities with merit-based promotion philosophy
- Benefits kick in day one, see the full details here
The Advisory Board Company is an Affirmative Action and Equal Opportunity Employer. EOE AA M/F/Vet/Disability. <![if !vml]><![endif]>*LI
Associate, Career Management
The Advisory Board Company
512-681-2616 direct | 512-609-1150 fax
Ranked as one of Forbes’ Most Innovative Growth Companies
See how else we’re being recognized.