Hi, Please check and let me know
Kindly Mail me at : abhis...@apetan.com *Sr. DevOps Engineer* *Seattle, WA* *4-6 month contract* *Market rate* *Phone then F2F* *Please only local candidates. They are looking to hire immediately.* Title: SQL Server DBA in Philadelphia, PA Mode of interview: Phone then F2F Legal Status: USC/GC/EAD Duration: Long Term Location: Philadelphia, PA Rate: DOE JD: *Key Responsibilities* · *Perform Database maintenance activities including system and DB patches, * · *Support critical outage incidents for triage and mitigation* · *Perform root cause analysis to understand why the outage/incident happened * · *Improve DB health monitoring by utilizing SQL Server and other monitoring tools like AppDynamics etc. * · *Provide compliance support (PCI and SOX) * · *Establish/modify SOPs for Level 1 support eye-on glass support * · *Conduct periodic analysis of existing DB instances and provid recommendations on improvements* · *Optimize DB performance where needed write and/or troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints)* · *Establish automation and reporting where needed utilizing SSIS and SSRS* · *Other responsibilities as assigned* *Qualification/Experience * · *Expertise and knowledge in MS SQL Server 2008 / 2012 / 2014* · *Experienced in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.* · *Experienced in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.* · *Ability to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention, help mitigate to ensure services are resumed and provide shot term and long term betterment recommendations.* · *Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.* · *Expert experience in implementing operational automation.* · *Strong knowledge on indexes, index management, integrity checks, configuration, patching. How statistics works, how indexes are stored, how they can be created and managed effectively.* · *Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)* · *SQL Development – ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )* · *Solid acquaintance with windows server, security delegation, SPNs, storage components.* · *Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )* · *SQL Database Operational support to tech users* · *Knowledge of 3rd party DBA tools and applications ( e.g redgate, idera, SCOM, Erwin ) is highly preferred* · *MCDBA / MCT certification is preferred* · *Knowledge in a scripting language like Powershell, VBScript, WSH is highly desireable.* *Education:* *Bachelor's Degree in Computer Science / Engineering or relevant discipline * Thanks Abhishek abhis...@apetan.com Apetan Consulting LLC -- You received this message because you are subscribed to the Google Groups "Vendors" group. To unsubscribe from this group and stop receiving emails from it, send an email to vendors+unsubscr...@googlegroups.com. To post to this group, send email to vendors@googlegroups.com. Visit this group at https://groups.google.com/group/vendors. For more options, visit https://groups.google.com/d/optout.
