Lead Database Administrator

Vitas Healthcare Miramar , FL 33023

Posted 3 months ago

Overview

Why VITAS Healthcare and What Do They Offer Me?

VITAS Healthcare is the nation's leading provider of end of life care. We provide our employees opportunities for professional growth, advancement and competitive benefits.

The Lead Database Administrator is responsible for maintaining and supporting the relational database systems in the LINUX and Microsoft Windows environments. The Lead Database Administrator is an integral part of the Information Technology Department and is responsible for the efficient and effective management of the corporation's electronic data. The Lead Database Administrator helps maintain highly available, stable, secure and recoverable databases. The Lead Database Administrator must create and ensure that all technical documentation, best practices and standards are accurate and followed.

  • To maintain highly available, stable, secure and recoverable database systems that meet or exceed established Service Levels.

  • Devise, execute, document and improve disaster recovery plans for Sybase and MS SQL Server databases.

  • Devise, execute, document and improve department standard operating procedures

  • To maintain a highly available and stable Sybase and MS SQL server environment through appropriate monitoring, control and maintenance.

  • Maintain stable test, training, reporting and production database environments.

  • Participate in a mentoring process to bring all DBAs up to a high degree of competency.

  • Lead projects orginated or assigned to the DBA department.

  • Participate in all phases of development projects that interact with the database systems.

  • Work with development staff on the use of database tools, techniques and concepts.

  • Develop and maintain standards on how to develop, test and performance tune stored procedures, triggers and SQL code.

  • Recommend, develop and maintain standards to effectively monitor system performance.

  • Maintain adequate backups of all critical databases according to disaster recovery procedures.

  • Keep current on all new DBMS releases to exploit the new functionality.

  • Coordinate database installation and testing of upgrades.

  • Provide support to the corporation in handling the daily scheduled database production jobs.

  • Prepare, execute and document Disaster Recovery procedures for all database systems and coordinate recovery activities with the Disaster Recovery team.

  • Ensure that metrics are evaluated as they pertain to performance, trend analysis and forecasting.

  • Ensure that passwords are changed at mandated intervals as outlined in published guidelines.

  • Review and ensure DBA Standard Operating Procedures are accurate with operations performed.

  • Verify and maintain that all databases are up and performing within service level agreements.

  • Provide on-going training to all DBAs through mentoring or formal training.

  • Support all database customers in a timely and efficient manner.

  • Participate in Disaster Recovery and Security Audits on all database systems.

  • Return e-mail, voice mail and pages in a timely manner

  • Travel as required.

  • Perform and assume other duties and responsibilities as may be required.

  • Monitor the progress of Service Levels and assigned projects and communicate deviations to the DBA Manager

  • Assist in the creation of standards and policies for the Enterprise in the use of the technology infrastructure

  • Evaluate Service Level Agreements and make recommendations to the DBA manager

Benefits Include

  • Competitive compensation

  • Health, dental, vision, life and disability insurance

  • Pre-tax healthcare and dependent care flexible spending accounts

  • Life insurance

  • 401(k) plan with numerous investment options and generous company match

  • Cancer and/or critical illness benefit

  • Tuition Reimbursement

  • Paid Time Off

  • Employee Assistance Program

  • Legal Insurance

  • Roadside Assistance

  • Affinity Program

Qualifications

  • Mininum 5 years DBA experience with Sybase and /or MS SQL server.

  • Prior experience performing database installations and upgrades.

  • Prior experience with Sybase replication is a plus.

  • Extensive experience with sql, stored procedure and trigger development and tuning is a must.

  • Ability to develop and maintain Unix shell scripts and cron jobs.

  • Working knowledge of network connectivities and interoperabilities of multi-platform environments.

  • Project management skills are required and the ability to use Microsoft Project.

  • Proven production support background of application databases in a 24 X 7 environment.

  • Strong problem solving and analytical skills are necessary for this position.

  • Database administration certification supplements the position skill base and is considered a plus.

  • Ability to express complex technical concepts effectively, both verbally and in writing.

  • Excellent time management and organizational skills are necessary for this position.

  • Ability to work independently without supervision.

  • Ability to work well with people from different disciplines with varying degrees of technical experience.

  • Excellent written and verbal communications skills.

Education

  • Associate or BS or BA degree in comp
icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Informatica Administrator

Spirit Airlines

Posted 1 week ago

VIEW JOBS 9/6/2019 12:00:00 AM 2019-12-05T00:00 Overview The Informatica Admin will perform installation, maintenance, troubleshooting, patching, administration, performance tuning, upgrading of Informatica Power Center application and database servers. Will define, develop and document standardized monitoring procedures for data integration processes. Provide 24/7 support of Informatica Power center environment. Responsibilities * Responsible for the implementation and maintenance of database systems. * Create virtual machines (VMs) hosted on-prem or in the cloud as part of supporting research data management. * Provide guidance to the team about which database solutions best meet current needs, and keep current with developments for data storage techniques, privacy and security methods, and access control methods. * Support, maintain, manage, and test the security and integrity of databases capable of storing large amounts of data from many different sources. * Responsible for ETL, data mapping, and data integration documentation including documentation of business processes and how data is stored. * Maintain strong working knowledge of released products and take ownership for identifying product improvements. * Learn to use and support proprietary software. * Provide support of Informatica suite platform administration both on-prem and in the cloud. * Provide for external application access to Informatica services and other customization tasks by using the services integration framework. * Implement best practices within the IT organization specific to the Informatica solution strategy. * Configure Informatica suite per developer requirements and workbenches to build data models and configure and execute the data management processes to including landing, staging, trust, load, match, and merge. * Participate in providing 24x7 coverage to ensure applications availability including the ability to troubleshoot, evaluate, assess and remediate multi-tiered technical applications. * Develop best practices around managing Informatica configurations. Qualifications * Informatica Admin Certification – Preferred * Microsoft Professional – Preferred * 2-5 years experience in relational database concepts with hands-on experience with MSSQL, OR Oracle. * 2-5 years experience in database programming With T-SQL or PL-SQL. * 3-5 years experience working with ETL tools (SQL Server Integration Services, Informatica Power-center, Azure or Azure Data Factory) and technologies. * NoSQL databases, C#, Python, and SPARK SQL a plus. * BS/BA in Computer Science, Information Systems, engineering or related field. * MS/MA in Computer Science, Information Systems, engineering or related field preferred. * Experience working with Informatica Power Center – 10.2 * Understanding of Informatica Data Quality – IDQ * Experience in Informatica Power Exchange * Experience in Informatica Web Service Hub * Knowledge of Power Shell. * Understanding of batch and streaming data integration methodologies. * Operational (24/7) creative, out of the box thinker. * Able to work in a fast pace agile environment with multiple competing deadlines. * Very detail oriented with the ability to handled multiple priorities in an organized manner. * Strong problem solving skills. * Out of the box thinker with a creative mindset. * Understands dimensional and star schema Data Warehouse modeling techniques. * Advanced working knowledge of data marts, operational data stores, and data lakes. * Knowledge of API Development – Point to Point API Integration. * Please be advised that you will be asked to complete a required assessment to be considered for this position. This assessment will be emailed to you after you apply. Please be sure to check your Spam folder and/or junk mail if you do not receive it.* We offer a competitive salary and comprehensive benefits to our team members including medical, dental, STD, LTD, life insurance, 401(k), paid time off, travel benefits and much more. We strive to maintain a professional, yet friendly environment and promote professional and career development for our team members. EEOC Statement Spirit Airlines is an Equal Employment Opportunity employer. All aspects of employment are governed on the basis of merit, competence and qualifications without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity or any other category protected by federal, state, or local law. Spirit Airlines Miramar FL

Lead Database Administrator

Vitas Healthcare