Sr SQL DBA/Developer
InSource, Inc - philadelphia, PA
Apply NowJob Description
Sr SQL DBADeveloper Philadelphia, PA 19103Do not apply if you are a 3rd partyC2CVisa candidate, or, if you live outside PA, NJ or DE. No 3rd parties please. Hybrid role (1 day onsite in Philadelphia, PA 19103), 4 days work-from-home.6-months Contract-to-HireSend resume to asim dot ghosh at insourcenow dot comPosition SummaryThis 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.ResponsibilitiesAdvanced 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 statisticsfragmentation.Creation of SQL Server performance documentationbest 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:BABS 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 dustry-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.
Created: 2024-10-13