Sr SQL DBA/Developer (W2 ONLY)

Sr SQL DBA/Developer (W2 ONLY)

Do not apply if you are a 3rd party Visa/C2C/1099 candidate, or, if you currently live outside PA/NJ/DE . No 3rd party referral. This is strictly a W2 role, C2C/1099 is not available.

Must work1 day onsite every week during the contract period (6-12 months or so). When it converts into an FTE role, it will be 3 days onsite every week in Philly.

Send resume to asim dot ghosh at insourcenow dot com

Position Summary

This person will work 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.

Responsibilities

• 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:

• BA/BS in Computer Science, Information Systems, etc. or equivalent work experience.
• 10+ years’ related IT experience working as a SQL Server database administrator and familiarization with related technologies and tools.
• 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.
• The candidate should have Database Development experience in large scale environments with high transaction volumes such as ecommerce or banking.