Company:
A2C
Location: Philadelphia
Closing Date: 24/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Overview
Enterprise level Microsoft application/sql server environment requires sql server application and dba server integration set up- will be joining our DW implementation team on greenfield SQL server DW build.
The Environment
- High availability production applications and servers
- Microsoft product stack: sql server, .net. , ssis/ssrs/ssas.
- MDM and Big Data
- Cloud-aws
- Tableau BI
The Role
As the lead dba, you will be focused on both production/application support (70-30 split), as well as database design. Will be primary contact for all application development tasks as it pertains to ssis/ssrs/ssas
Job Description:
- The position will work directly with various IT associates including Application Development, Server Admin, Networking, Database Administration, and others to optimize application / database performance.
- Candidate should have hands on experience with large scale environments and high transaction volumes.
- The ideal candidate should have extensive Java experience.
- Experience with Mule would be a plus, but not required.
Specific Duties:
- Advanced Database Development experience with Microsoft SQL Server Database.
- Experience with Senior level Database Administration support. (e.g., Installing / Upgrading / Backup and Recovery / Configuring / SSMS / SSIS / SSRS / Always on Failover Clustering / Performance Tuning / Troubleshooting).
- Evaluating SQL Server Query performance.
- Providing guidance on query redesign, index modifications, database configuration changes, and database related application process improvements.
- Utilizing Idera SQL Diagnostic monitor, Query Store, SQL Server Profiler, Dynatrace and Query plans to evaluate and tune database queries.
- Evaluating index statistics/fragmentation.
- Creation of SQL Server performance documentation/best practices for consumption by SQL Server Database Development and Database Administration teams.
- Participate in evaluations and recommendations for associated database solutions based on business requirements and user needs.
- Provide performance monitoring and measuring of all database components and provide input on capacity and performance planning.
- Escalate issues for technical assistance as required.
- Participate in basic to moderately complex database tuning efforts as required.
- Apply administration best practices in daily operations.
Qualifications:
- Industry-recognized technical certification preferred (e.g. SQL, MCDBA)
- Working Knowledge of database file structure, retrieval and access methods, and performance analysis.
- Demonstrated analytical skills, excellent written and verbal communication skills, judgment, and the ability to work effectively with clients and IT associates in a collaborative and cooperative manner.
- Basic Understanding of the development process and business process.
- Ten (10) or more years’ related IT experience working as a SQL Server database administrator and familiarization with related technologies and tools.
- The candidate should have Database Development experience in large scale environments with high transaction volumes such as ecommerce or banking.
.
Share this job
A2C
Useful Links