Hi, Please check and let me know
Kindly Mail me at : abhis...@apetan.com 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 "Citrix and Sap problems" group. To unsubscribe from this group and stop receiving emails from it, send an email to citrix-and-sap-problems+unsubscr...@googlegroups.com. To post to this group, send email to citrix-and-sap-problems@googlegroups.com. Visit this group at https://groups.google.com/group/citrix-and-sap-problems. For more options, visit https://groups.google.com/d/optout.