Senior DBA - SQL Server at WIRB-Copernicus Group
Posted in Other 30+ days ago.
This job brought to you by America's Job Exchange
Type: Full Time
Location: Plymouth Meeting, Pennsylvania
ePharmaSolutions is currently seeking a Database Administrator (DBA) to support our growing company. This individual will be responsible for the design, implementation, management, and tuning of any database management systems and assisting with any DBMS-related infrastructure work.
Install and maintain the DBMS server operating systems as well as all supporting software.
Implement short- and long-term strategic plans to make certain network capacity meets existing and future requirements.
Implement and maintain policies, procedures, and associated plans for DBMS resource administration and appropriate use.
Maintain DBMS accounts, groups, permissions, etc. as necessary.
Conduct research and make recommendations on DBMS products, services, protocols, and standards in support of network procurement and development efforts.
Design, implement, manage, and tune database management systems (DBMS), including Microsoft SQL Server, Oracle, and MySQL.
Troubleshoot database-related issues as necessary.
Recommend tools and practices to enhance performance and insight.
Create documentation to supplement organization’s knowledge, increase consistency, and facilitate ongoing management.
Assist and advise where necessary on all aspects of DBMS management, including regular maintenance activities, backups, and disaster recovery.
Design, manage, and audit database security.
Act as gatekeeper to ensure that promoted code changes do not compromise data integrity or degrade performance.
Tune database code prior to implementation.
Educate developers on database coding best practices and team members on all aspects of database management.
Bachelor's degree and/or equivalent experience
7 years' experience in this specialty
Microsoft SQL Server expertise in versions 2005 through 2012, including:
Database and query performance optimization
Hardware subsystem performance optimization
Database, server and inter-server SQL security
SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services (SSIS, SSAS, and SSRS)
Microsoft Alwayson Availability Groups 2012 R2
Microsoft Cluster Services 2008 R2
SQL Server Profiler, Database Engine Tuning Advisor, Performance Monitor
SQL Server Dynamic Management Views
Sr. level knowledge of the following concepts:
T-SQL database programming
SQL Server maintenance plans
SQL Server stored procedures, triggers, and indexes
Microsoft Active Directory authentication and authorization
Windows Server 2003-2012 operation
Robust medical, dental and vision plans - within 30 days of your employment.
19 PTO days and 9 paid holidays annually
Matching 401K program
ePharmaSolutions is the industry’s leading provider of eClinical solutions, helping sponsors and contract research organizations (CROs) to streamline and accelerate the conduct of clinical trials. For over a decade, ePharmaSolutions’ technologies and services have enabled clinical research sites to achieve their goals, by fostering compliance and efficiency within the site selection and management process.
We are an Equal Opportunity Employer. Minorities, females, veterans, and individuals with disabilities are encouraged to apply.