Senior SQL Server Production DBA Job in Plano 75024, Texas Us
Company Overview:
MedAssets (NASDAQ: MDAS) partners with healthcare providers to improve financial strength by implementing spend management and revenue cycle management solutions that help control cost, improve margins and cash flow, increase regulatory compliance and optimize operational efficiency. MedAssets serves more than 180 health systems, 4,000 hospitals and 75,000 non-acute healthcare providers. For more information, visit www.medassets.com.
Job Purpose:
The Database Administrator is responsible for Production Database support for the Reimbursement Technologies applications.
Essential Duties Responsibilities:
- Implementing and supporting SQL Server Database Systems, Reporting Services, Analysis Services and Integration Services on enterprise and dedicated Windows servers to support MedAssets applications.
- Responsible for standards and design of physical data storage, maintenance, access, and security administration
- Optimizing database access and allocating/re-allocating database resources for optimal configuration, database performance, and system utilization.
- Experience in Oracle 10/11G is a plus.
- Responsible for the day to day database administrative tasks, such as: proactive monitoring, error checking, performance tuning, replication, trouble-shooting, back-up and recovery.
- Will require in areas such as database administration skills, SQL Server Clustering and SQL Profiler skills and experience with an emphasis on enterprise scale architecture.
- Investigating, reviewing, applying and testing all patches and bug fixes in the database environment and providing consultation on patch management, custom interface design and operational implementation.
- Managing user security and access to databases to provide controlled access environment.
- Work with application developers, data analysts, and database engineers to maintain database schemas.
- Participate in testing of all database-related changes
- Participate in planning, design, implementation, and testing of new and changing database configurations
- Provide DBMS and database knowledge to developers, business analysts, testers, and others as needed
- Develop queries, stored procedures, triggers, and scripts as needed
- Requires 2-3+ years of recent SQL DBA experience in a Data Warehouse (DW) environment.
- Candidates must have experience with SQL Server 2005/2008R2, tuning SQL Server for high-volume and experience with VLDBS, reporting and analytics.
- Participate in on-going evolution, improvement, and automation of DBA procedures
- Will be required to be on an on-call rotation with other DBAs
- Excellent knowledge of TSQL, Stored Procedures, Functions, Triggers, and Linked Servers.
Internal Responsibilities:
- Adheres to all company policies and procedures including, but not limited to those identified within the Standards of Business Conduct and the Employee Handbook, as may be amended from time to time. Adheres to all applicable laws and regulations and the company's governance/compliance program.
- Responsible for reporting violations of the company's policies and procedures, Standards of Business Conduct, governance program, laws and regulations through the company's Help Line or other mechanism that may be available at the time of the violation. Assists with internal control failure remediation efforts.
- Becomes knowledgeable of internal control responsibilities through training and instruction. Responsible and accountable for internal control performance within their area of responsibility. Participates in the internal controls self-assessment process.
- Ensures concerns with internal control design or performance and process changes that impact internal control execution are communicated to management.
Minimum Qualifications Competencies:
- Bachelor's Degree in MIS, IT, Computer Science or related field. Equivalent technical experience may be substituted for educational requirement
- 5+ years implementation of relational or proprietary databases with a strong understanding of SQL Server
- Physical and logical database design in a SQL Server environment
- Excellent understanding of computer hardware
- Experience with DTS to include Dynamic Properties, Global Variables, and the DTS object model is a plus
- Experience with EMC SAN technologies is a plus
- Experience as Network Administrator a plus
- Experience in non-database related Application Development a plus
- Excellent understanding of and experience with relational database architecture and database implementations/monitoring/maintenance with the primary focus on SQL server
- Strong T-SQL and stored procedure skills
- Ability to run traces, performance monitoring, blocking and good problem solving skills are required
- Have a good understanding of database support including backup and recovery
- Excellent written and verbal communication skills
- Highly numeric aptitude with excellent analytical skills
Travel: (No Travel)
Physical Demands:
The physical demands and work environment characteristics described here are representative of those that an employee must meet to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Physical Demands: While performing the duties of this job, the employee is occasionally required to move around the work area; sit; perform manual tasks; operate tools and other office equipment such as computer, computer peripherals and telephones; extend arms; kneel; talk and hear. The employee must occasionally lift and/or move up to 15 pounds.
- Mental Demands: Must be able to follow directions, to get along with others, and handle stress;
- Work environment: The noise level in the work environment is usually minimal.
MedAssets is an Equal Opportunity Employer and ensures its employment decisions comply with principles embodied in Title VII, the Age Discrimination in Employment Act, the Rehabilitation Act of 1973, the Vietnam Veterans Readjustment Assistance Act of 1974, Executive Order 11246, Revised Order Number 4, and applicable state regulations.