Job Title: SQL Database Administrator

Location: Florham, NJ (2 days onsite per week)

Duration: 12 month

USC/ GC / H4EAD

Job Purpose:

The DBA will be responsible for the design and implementation of scalable, supportable & secure data management solutions. The Data Architect will provide thought leadership to a cross-functional team to determine how to adopt cloud computing in client environments. The Data Architect will provide oversight of work products delivered by Infrastructure and Application DBAs. The Data Architect will collaborate with Enterprise Architect and Database Administrators and Database Developers to create standardized delivery of data management solutions that are aligned with enterprise strategy and architecture.

Essential Duties & Responsibilities:

• Strong T-SQL database development skills
• Good understanding of the features available in SQL Server to achieve a scalable database solution
• Strong SSIS / or ETL tools development skills
• Some experience with PowerShell with motivation to learn
• Experience designing and coding full database solutions from development to deployment
• Convert business requirements into technical solutions working with development team to implement
• Looking for self-motivated candidates who are hands on at their current positions and have hunger to learn new technologies
• Awareness of web, database, and object-oriented software technologies
• Experience in hands on design, prototyping, development, configurations, testing and other implementation activities
• Strong technical background, analytical, and problem-solving skills are required
• Must possess strong communication and interpersonal skills
• Ability to work collaboratively within a team environment and capable of delivering under aggressive timelines
• Oversee the migration of data from legacy systems to new solutions

• Examine and identify database structural necessities by evaluating performance, monitoring, operations, applications, and programming
• Convert business requirements into technical solutions working with development team to implement.
• Examine and identify database structural necessities by evaluating performance, monitoring, operations, applications, and programming.
• Identify and help prioritize functional improvements in the SaaS platforms.
• Contribute to technical team to assist in delivering a flexible and scalable solution.
• Provide oversight and mentorship to other team members.
• Security and data integrity in a HIPAA compliant organization.

• Data warehouse experience and tools (Azure)
• Experience with reporting tools (Cognos, SiSense a plus)

Minimum Qualifications & Competencies:

• BS or MS in Computer Science, Information Technology, or related field
• Should have hands 8 to 10 years of experience with database development using SQL Server
• SQL Server, T-SQL, query optimization tools and techniques, data modelling techniques, and relational database design
• Good understanding of the features available in SQL Server to achieve a scalable database solution
• Experience architecting and building Data Warehouses, Data Marts
• Various database development technologies, such as SQL Server, SQL Replication, Azure SQL Database, Azure Data Warehouse, including SSMS, SSRS, SSIS / or ETL tools, and OLTP/OLAP features
• Understanding of data modeling, data lakes, data driven insight, data quality and governance
• Experience designing and coding full database solutions for web applications from development to deployment
• Experience in hands on design, prototyping, development, configurations, testing and other implementation activities
• Strong technical background, analytical, and problem-solving skills are required
• Experience with reporting tools (Cognos, SiSense a plus)
• Ability to work collaboratively within a team environment and capable of delivering under aggressive timelines
• Must possess strong communication and interpersonal skills
• Looking for self-motivated candidates who are hands on at their current positions and have hunger to learn new technologies
• Able to work in a fast-paced, dynamic environment
• Capable of incident resolution during major incident process
• Good time management and prioritization skills; self-starters especially welcome

• Maturity and ability to take responsibility for gathering additional information on requirements and design to effectively establish testing for the applications and processes

• Dedicated to excellence in quality, reliability, and thoroughness in all work tasks; detail-oriented with consistent follow-through
• Knowledge of emerging technologies
• Experience in pharmaceutical industry a plus