Sr Database Administrator -dPx

Company: Allscripts
Location: Melville
Posted on: May 13, 2022

Job Description:

Job Description Welcome to Allscripts Our Mission is to be the most trusted provider of innovative solutions that empower all stakeholders across the healthcare continuum to deliver world-class outcomes. Our Vision is a Connected Community of Health that spans continents and borders. With the largest community of clients in healthcare, Allscripts is able to deliver an integrated platform of clinical, financial, connectivity and information solutions to facilitate enhanced collaboration and exchange of critical patient information. We are the Digital Patient Experience (dPx) software development team. We create new and innovative solutions that empower patients and healthcare providers to effectively manage all aspects of healthcare through mobile, web and interactive solutions revolutionizing healthcare engagement today. As agile practitioners, our team creates a competitive advantage through dramatically improved productivity and customer satisfaction enabled through our native cloud software applications. The dPx team is a highly skilled and motivated full-cycle software development & support organization. Position Summary: Our candidate for this role is a subject matter expert well versed in database administration and engineering practices and principles including planning, building, tuning, and maintaining database systems, technology, and infrastructure. As a technical specialist, this individual will work closely with our software architecture, information architecture, software development and DevOps teams providing technical guidance and expertise relating to data, databases, and supporting systems in solving complex problems and creating innovative solutions. Responsibilities: Oversee maintenance, configuration, and implementation of our DBMS Design, architect, and build databases from business requirements Develop DB innovation, strategies, processes, and best practices Map out the conceptual design for a planned database Establish, manage, control, and monitor access permissions and privileges Transforming / mapping conceptual application schemas to specific data model Maintain data standards and adherence to all regulatory and compliance requirements Ethically handle private data and healthcare data (PII / PHI) Work engineering staff on database design changes to meet business requirements Define and implement changes and improvements for database maintenance or protection Support software developers with database operations including the development of complex SQL, writing, and troubleshooting complex stored procedures Install, setup and test new versions of the DBMS Develop, manage, and test back-up and recovery plans in conjunction with DevOps team Define and implement storage, replication, partitioning and archiving procedures Monitoring DB system performance / associated hardware and software Reporting on metrics regarding usage and performance Optimize current DB systems to ensure quality system performance including index tuning, disk optimization, partitioning schemes, and various other methods where / as appropriate Perform sizing and capacity planning Maintain data integrity and security, manage roles and permissions of database users Generate traces, execution plans, identify performance issues, deadlocks / contention and remediate Manage in both production and non-production database environments Set up and maintain database infrastructure supporting Analytics / BI processes Author database documentation, including data standards, procedures, and definitions for a data dictionary (metadata) Qualifications: Bachelor's degree in computer science or a related field, MS preferred 6 years' experience managing enterprise level database environments Advanced certifications (e.g., MCDBA, DBS-C01) preferred Strong background implementing distributed applications across cloud platforms Strong fundamentals, including OOD, data structures, interface protocols, design, and networking concepts Experience in backend, server, and API development, including application and database / data development and architectures Background including MySQL, No SQL databases, and in-memory databases Uses of normalization methods and design methodologies Deep working knowledge of full stack software development tools and methodologies, experience in Scrum / Agile methodologies preferred Strong interpersonal, organizational and communications skills Experience mentoring, supporting, and developing other software engineers by providing advice or coaching Skills: Microsoft SQL Server and Cosmos DB DB performance troubleshooting skills DB monitoring and DB performance tuning and associated tools (e.g., Azure SQL DB / Azure SQL Managed Instance, SQL Profiler) SQL and stored procedures Query optimization and index management ETL development and data integration Transactional replication, setup, troubleshooting, and creating replication scripts Backup and recovery, HA / DR implementation (e.g., mirroring, log shipping, failover, etc.) Code reviews for SQL best practices and identifying inefficient query structures Other database related technologies (e.g., Elasticsearch, Sequelize, Redshift, Snowflake, PostgreSQL, etc.) Azure cloud technology stack preferred Agile scrum development Travel Requirements: May require local travel May require other occasional travel for business needs Working Arrangements: Work is performed in a standard office environment with minimal exposure to health or safety hazards May require after hours on call support Must have received or be willing to receive the COVID-19 vaccine by date of hire to be considered for employment with Allscripts. Visa Sponsorship is not offered for this position. At Allscripts, our greatest strength comes from bringing together talented people with diverse perspectives to support the technology needs of 180,000 physicians, 1,500 hospitals and 10,000 postacute organizations across the globe. Allscripts offers a comprehensive compensation and benefits package, including holidays, vacation, medical, dental, and vision insurance, company paid life insurance and retirement savings. Allscripts' policy is to provide equal employment opportunity and affirmative action in all of its employment practices without regard to race, color, religion, sex, national origin, ancestry, marital status, protected veteran status, age, individuals with disabilities, sexual orientation or gender identity or expression or any other legally protected category. Applicants for North American based positions with Allscripts must be legally authorized to work in the United States or Canada. Verification of employment eligibility will be required as a condition of hire. Allscripts is proud to be an equal opportunity workplace dedicated to pursing and hiring a diverse and inclusive workforce. From a "VEVRAA Federal Contractor" We request Priority Referral of Protected Veterans This is an official Allscripts Job posting. To avoid identity theft, please only consider applying to jobs posted on our official corporate site. Thank you for reviewing this Allscripts opportunity Does this look like a great match for your skill set? If so, scroll on down and tell us more about yourself

Keywords: Allscripts, New Haven , Sr Database Administrator -dPx, IT / Software / Systems , Melville, Connecticut