We provide IT Staff Augmentation Services!

Sql Server Resume

King Of Prussia, PA

SUMMARY
Over5+yearsexpertise as DBA in Microsoft SQL Server 7.0/2000/2005/ 2008/200R2/2012 management and performance tuning, System analysis, Design, deployment, and experience on development and testing ETL.

  • Expertise in Troubleshooting, Installation, configuration, Backup /recovery, database security, Data Transformation Services (DTS), Database design, query optimization, Security administration, Replication, mirroring, log shipping and clustering
  • Experience with Storage Area Networks (SAN) and utilizingSANdisk space in a Windows Environment
  • Familiar with Virtualization technology and running Windows inside a Virtual Machine
  • Experience in transitional replication both configuration and troubleshooting.
  • Experience in overhauling improperly designed database schemas including improperly merged entities, improper references between entities, references on the many-side entity failing to reference the full unique key of the one-side entity, and first & second normal form violations.
  • Experience with ETL processes for importing vendor data for e-commerce products, assimilating bulk job postings, SHRM member loads and re-loads, and integrating corporate acquisitions\' entire databases.
  • Experience in disaster recovery, performance tuning, and migration from 2000 to 2005 and 2008
  • Expertise in configuring and maintaining SQL Server Active/Active and Active/Passive cluster.
  • Experience in installing MS SQL multiple instances in windows cluster environment.
  • Monitoring: Disk space, log space, publishers latency, waits, index fragmentation and generating all the reports .
  • Experience in installing multiple instances of SQL failover cluster on SQL 2005 & 2008
  • Extensive expertise in implementing High availability: Mirroring, Log shipping and Replication.
  • Implemented different types of replication models: Snapshot, Merge and Transactional.
  • Capacity planning, Performance tuning, Disaster recovery, trouble shooting backup /restore procedures
  • Experience in handling in large (VLDB) including T-SQL coding, Full-text indexing, stored procedures.
  • Data modeling tools: SQL Diagram, Erwin and Database security with SOX Compliance Standards.
  • Expertise in using ETL tools DTS and SSIS, Batch processes, Import, Export, Backup
  • Experience with SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services) and SSAS
  • Developed reports using Crystal reports 9i and SQL Server Reporting Services (SSRS).
  • Fluent in SQL Commands for resolving deadlocks and blocking issues.
  • Monitoring: Idera, Performance monitor (perfmon), SQL Profiler for monitoring instances, Debug T-SQL statements, identifies slow running queries.
  • Expertise in writing and debugging Stored Procedures, Triggers, Cursors and T-SQL coding.
  • Experience in working with global clients and handling high priority production issues over Email/phone
  • Worked as Tier 3 level DB Engineer and Troubleshooting customer escalations and providing solutions to Tier 1 and Tier 2 DB support team.
  • Experience in implementing Microsoft’s experimentation platform on various concepts of databases.
  • Erwin Data Modeler R7 and Model Manager used for implementation of data modeling
  • Strong knowledge of C#, XML, IIS and .NET framework.
  • Experience in using various third party tools: SQLBACKUP, SQL diagnostic manager, SQL COMPARE.

Education:
Masters of Sciences- Computer Engineering
Bachelors of Technology -Engineering in Electrical and Electronics Engineering

Skill Acquired:
Languages: T-SQL, XML, HTML.
Databases: MS SQL Server 2000 and 2005, 2008 MS-Access, oracle, IBM DB2, ORACLE
Operating Systems: Windows 2000/2003/2008 Exchange Server, Windows NT, Solaris 8 and 10, UNIX, Red hate linux, ubuntu, suse linux, wintel (IA 64, 32)
Version control Tools: Visual Source Safe, Rational Clear case, IBM TIVOLI, MOSS
Web Servers: IIS 5.0/6.0, Apache, Tomcat, and Web sphere.
Database Tools :DTS, SSIS, Enterprise Manager, SQL profiler, Tuning Advisor, surface area configuration,
Modeling tools: Erwin3.5/4.0 and Microsoft Visio 2003, windows performance tool
Other tools: SQL Backup (Red gate), Idera SQL safe, SQL compare, SQL Diagnostic Manager, light speed
Data warehouse: OLAP, MS analysis server, Data mining server, Multi dimensional cubes, Star & Snow flake schema, SQL Data Transformation services (DTS),MSSQL Reporting Services, Integration services, crystal reports and CIZER

CLIENT: Confidential
TYPE: CONTRATOR
February 2012-Present
Dublin OHIO

  • Established security and replication procedures and to Demonstrates expert understanding of database performance tuning, data backup, recovery and security processes/ procedures
  • Designed and implemented Upgrade process(migration) from SQL SERVER 2000/2005 to SQL SERVER 2008R2 which has been coordinated by SAN team and Database teams.
  • Performance Tuning: Optimize server through wait stats: Like fixing and reducing parallel Execution, Multi-Tasking Waits, IO waits, Backup and Restore Waits, Locking Waits, Database Log Waits, Waits on External Resources.
  • Mentored Team of Three Jr. SQL SERVER DBAs
  • Developed long-term and short term goals for production databases and for application teams
  • Worked with application team to create and enhance coding standards, quality assurance policies and database architectures.
  • Created and enhanced the data models for existing and new database in Test and development environments.
  • End to End ownership on any performance issues on both Database level and server level issues.
  • Monitored database level and server level details which includes optimizing store procedures, and top high level resource intensive queries
  • Implement a complete end to end solution for disaster recovery through Log shipping which archives all the data and makes available at other data centers through high level protection with proper security configuration.
  • Optimized Physical storage (SAN) while implementing a proper monitoring technique using tools like perfmon and third party tools like Idera.
  • Responsible on Release management which to follow the standard Release management process for deployment and implementation
  • Responsible for validating and editing change control or change requests to ensure compliance including verification checks and fallback procedures
  • Proved 2nd level escalation contact for troubleshooting with end to end ownership for technical support carried out in compliance with security audits.
  • General Administration: Configure, create, and troubleshoot all SQL Server components such as SQL Server properties, database properties, table/column properties, SQL Server agent jobs, DTS packages, database maintenance plans, error logs, alerts, and security.
  • Design, implement, and execute database backup/restore strategy based on service level requirements.
  • Acted as gatekeeper on production systems – Review and optimize database changes prior to production setup for errors and optimal performance.
  • Database objects migration – Transfer and synchronize data records, triggers, SPs, tables, databases, SQL Server agent jobs, DTS packages, etc. amongst different SQL Servers promptly and with minimum supervision.
  • Installation, upgrade, and patching of Microsoft SQL Server suite of products (7.0, 2000, 2005, 2008, 2008 R2).
  • System monitoring – Strong and practical knowledge of the following:
  • Performance tuning – Identify performance bottlenecks (i.e. poor written queries, hardware issues, etc.) and recommend corrective course of action.
  • Extensive use of SQL Server tools such Profiler, and DTS Designer, etc.
  • Windows Operating System – Diagnose and troubleshoot OS components that may impact SQL Server availability, such as memory, CPU, disk space, security, etc.
  • Proficient in using OS tools such as Perf Mon, Computer Management, Event Viewer, etc.
  • High Availability Solutions – Strong knowledge of the following:
  • Windows Clustering – Support active/active and active/passive clusters. Manage cluster resources and troubleshoot errors.
  • Create and maintain standby databases, log-shipping, or database mirroring. Participate in planning and execution of recovery activities.
  • Upgrading to SQL SERVER 2008 failover clustering
  • Administering a SQL Server 2008 Failover clusterlike Disk Maintenance (Adding a Disk to the failover cluster, putting a clustered disk into Maintenance mode),
  • General node and Failover cluster maintenance-Monitoring the clustering nodes, Adding a node to the failover cluster, Evicting a Node, Destroying a cluster, Changing Domains
  • Clustered SQL Server Administration
  • Changing the service account or service account passwords, Managing performance with multiple instances, uninstalling a failover clustering instance, changing the IP address of a failover clustering instance, renaming a failover clustering instance, patching a SQL Server 2008 failover clustering instance.
  • Virtualization and Failover clustering
  • Supported SQL Server Failover Clustering and virtualization Support
  • Considerations for Virtualizing Failover Clusters- Choosing a virtualization platform, determining the location of guest nodes, Performance, licensing
  • Windows Server 2008 R2 and Virtualization- Creating a virtualized Failover Cluster, create the virtual machine, install windows on the VMs, create a domain controller and ISCSI target, configure the cluster nodes. Finishing the windows configuration and cluster.

CLIENT: Confidential
SQL SERVER DBA
December 2011-Feburary2012
King of Prussia PA

Responsible for 159 production servers, 220 Quality assurances (QA), 110 Demo, 440 Test servers where I worked up to 1.4 TB database (single database)

  • Wrote automated backup and highly configurable index /statistics maintenance stored procedures for both the DEV an client production sites in a VLDB environment
  • Automated bugs/white list apply in all Prod/Sandbox and Pre-Prod environment
  • Setting up Log shipping & Replication(Transitional) on Production environment
  • Individually implemented Transactional Replication process (push) for updating 180 subscribers with 100 publishers.
  • Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures
  • Create models for new database development and/or changes to existing ones
  • Respond to and resolve database access and performance issues
  • Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements
  • Installed MS SQL Server2000/2005/2008 on Windows 2003/2008 servers, applied service packs, security fixes
  • Resolve database performance issues, database capacity issues.
  • Develop database procedures, triggers and SQL scripts for development teams.
  • Created Scheduled jobs to execute multiple DTS package to extract data from multiple Rockwell and Avaya switches from the southeast regions call centers.
  • Involved in setup of the clustered SQL server environment at VLDB.
  • Monitored log space of all the instances with generation of reports.
  • Extensive experience with VMWARE consolidated environment
  • Worked extensively on SQL queries, stored procedures and functions.
  • Used Reporting service (SSRS) to publish data to the end user via HTML, PDF, Excel, and CSV formats.
  • Created Integration Services (SSIS) to perform multiple data extractions from IEX TotalView application.
  • Helped to adapt the data load SSIS packages from one client that uses Oracle for use in a new client that uses Sybase. The SSIS packages utilized variables, expressions, loops, and scripts.
  • Monitor databases for errors and perform problem determination when necessary.
  • Troubleshooting security issues like orphan logins and common issues related to database and server level.
  • Review existing T-SQL code, to locate performance issues and develop improved T-SQL processes.
  • Worked with load balancing backend processing applications allowing teaming of SQL Server engines to facilitate grid computing of web traffic user request to maintain 24x7 uptime and tight SLA response time.
  • Support Development staff with SQL Server related tasks and along with review of code to prevent and resolve database bottlenecks.
  • SQL server profiler-used as an auditing tool for security proposes to capture traces, restricting the events and diagnosing problem queries.
  • To improve the ongoing process –Implemented Microsoft experimentation platform so that we can compare the with the original model to the suggested model as to get the pitfalls form the system.
  • Automated tools for moving files between cross domains using batch scripts
  • Demonstration of In-built features of SQL Server including but not limited to: Security and processing how to code T-SQL , create programming objects (Databases, Tables, Stored procedures, Functions and Jobs)
  • SSRS-Configured Report server virtual directory/configured report manager virtual directory/configured windows service identity/configured web service identity/configured the Report server databases, SharePoint integration, working with Report server Encryption keys, Initializing the Report server Instance, Configuring Email settings, Configuring the Execution account.
  • Involved in database upgrade planning from SQL Server 2000 to SQL 2008(where it covers 2005 to 2008 too)
  • Configuring Indexes for Maximum Performance-Configuring Index statistics, Exploring Fragmentation Considerations, Implementing fill factor administration, determining when to rebuild or reorganize an index , sorting indexes in the tempdb, using the database engine tuning advisor
  • Conducting the health check for every 3 months-By using tools like SQLH2, SQLDIAG, and SQL2005 BPA
  • Troubleshooting performance problems-on SQL profiler, system monitor(in the windows server 2003 operating system) and performance monitor(in the windows vista and windows server 2008), also known as perfmon, Dynamic management view(DMVs), SQL Server Extended Events (Extended Events) and the data collector, which are new in SQL server 2008.

CLIENT: Confidential
SQL SERVER DBA
TYPE: CONTRATOR
May2011-November2011

Responsibilities:

  • Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
  • Clustering: Troubleshooting on both SQL Server and windows level clustering
  • Designed and developed SQL Server Integration Services (SSIS) for data migration.
  • Implemented database maintenance plan for new SQL server 2005 databases.
  • Implemented data partitioning for new SQL Server 2005 databases (Created partition function, partition scheme mapped to a partition function and created the table on the partition scheme)
  • Set up alerts, operators, SQL Mail, SQL Agent Mail, and notifications.
  • Implemented and configured IIS services , 6.0 and 7.0
  • PowerShell-Implemented windows management instrumentation task(WMI) like Browsing the WIN32 WMI classes, checking Disk space, checking what services are running on a server, IS IIS Running on your SQL Server.
  • PowerShell- implemented Browsing the SMO classes, List the members of the sysadmin role on a server, List the local administrators on a server, find a login or AD group on Multiple servers, check for failed SQL Ages jobs on multiple servers and Miscellaneous Tasks like Finding a port number, generate a random password, etc.
  • Set up and schedule jobs that perform backups and database structure checks
  • Monitored MS SQL servers for errors and performance degradation.
  • Performed all aspect of database administration, including backup, recovery, and replication for SQL server 2005.
  • As part of a team, analyzed the business requirements and systematically designed a database. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the importation and exportation of data using SSIS
  • SSRS-configured the report server Databases, SharePoint integration, working with Report server Encryption keys, Initializing the report server instance, configuring E-mail and execution account.
  • SSRS-used Reporting services administration tools like Report manager and command line.
  • SSRS-Administering Reporting services site settings-configuring-Reporting services site name, My reports feature, report history, report execution timeout, report execution logging.
  • SSRS-Reporting services security-Administering Item roles, system roles
  • SSRS-Administering shared data sources and reports like-creating a shared data source, configuring shared data source credentials, securing the shared data source, publishing and viewing Reports, viewing and changing the report data source, viewing and changing report properties, administering a report-specific data source and creating linked reports with troubleshooting reporting services.
  • Maintained the database consistency with DMV’s/DMF’s at regular intervals
  • Analyze some of the long running slow queries & tune the same to optimize application and system performance.
  • Created and maintained ERD diagrams
  • Used SQL server profiler for performance tuning analysis services, to track full text queries by using profiler.
  • Migrated database object using SSMA (SQL Server Migration Assistant)
  • Involved in database upgrade planning from SQL Server 2000 to SQL 2008(where it covers 2005 to 2008 too)
  • Administering Indexes- creating clustered indexes/Non-clustered index, Disabling/Deleting/enabling and Rebuilding Indexes. Implementing Index Maintenance and Maintenance plans
  • SQL Query Analyzer: windows server 2000-Quickly created commonly used database objects from predefined scripts(templates), executed and debugged stored procedures(T-SQL debugger), Debugged query performance problems(Show execution plan, show server trace, show client statistics, Index Tuning wizard)
  • SQL enterprise manager-windows server 2000-Defined groups of server running SQL Server, Register Individual servers in a group, configure all SQL server options for each registered server, Create and administer all SQL server database objects, logins, users, and permissions in each registered server, Define and execute all SQL server administrative tasks on each registered server with test SQL statements, batches and scripts interactively by invoking SQL Query Analyzer

CLIENT: Confidential
TYPE:CONTRATOR
Secaucus New Jersey
Feburary2011- May2011
SQL SERVER DBA(Operational database administrator)

Responsibilities:

  • Solved two critical performance issues in aggregate T-SQL queries that caused the data load for EncounterPro and Pend Analyzer to monopolize the CPU on the SQL Server for many hours.
  • Optimized the database and application performance of the IC-Chart electronic health records system addressing poorly written queries, missing or poorly designed indexes, and excessive ADO web-DB round-trips.
  • Wrote complex data scrubbers, particularly on the isapisal table (audit log for HIPAA and CCHIT stuff).
  • Wrote ad-hoc queries and stored procedures for numerous ad-hoc and production reports utilizing heavy-duty T-SQL aggregate queries with many joins and derived tables.
  • As part of a team, analyzed the business requirements and systematically designed a database. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the importation and exportation of data using SSIS.
  • Supported in Deploying Network Load Balance, configuring the NLB NIC and installing.
  • Installed new MS SQL Server 2005 and maintained 10 servers (Total size of the db around 5.1 TB).
  • Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
  • Designed the entire logical and physical model with 100 + tables using Visio, ERWin
  • Enforced referential integrity via creation of constraints on database objects
  • Designed and developed SQL Server Integration Services (SSIS) for data migration.
  • Implemented database maintenance plan for new SQL server 2005 databases.
  • Implemented data partitioning for new SQL Server 2005 databases (Created partition function, partition scheme mapped to a partition function and created the table on the partition scheme)
  • Set up alerts, operators, SQL Mail, SQL Agent Mail, and notifications.
  • Capacity planning- worked on preparing service level agreements(SLA) while defining average response time, 90 percent response time, maximum response time, uptime requirement, Disaster recovery time
  • Set up and schedule jobs that perform backups and database structure checks
  • Monitored MS SQL servers for errors and performance degradation.
  • Performed all aspect of database administration, including backup, recovery, and replication for SQL server 2005.
  • Maintained the database consistency with DMV’s/DMF’s at regular intervals
  • Analyze some of the long running slow queries & tune the same to optimize application and system performance.
  • Migrated database object using SSMA (SQL Server Migration Assistant)
  • Involved in database upgrade planning from SQL server 2000 to SQL server 2005

CLIENT: Confidential
SQL SERVER DBA
TYPE: FULL TIME
Eagan Minnesota
April2010-Janurary2011

Responsible for daily maintains issues, taking care of ticketing system, release management process, monitoring the productions servers

  • Set up alerts, operators, SQL Mail, SQL Agent Mail, and notifications.
  • Implemented and configured IIS services , 6.0 and 7.0
  • Implemented windows management instrumentation task(WMI) like Browsing the WIN32 WMI classes, checking Disk space, checking what services are running on a server, IS IIS Running on your SQL Server.
  • PowerShell- implemented Browsing the SMO classes, List the members of the sysadmin role on a server, List the local administrators on a server, find a login or AD group on Multiple servers, check for failed SQL Ages jobs on multiple servers and Miscellaneous Tasks like Finding a port number, generate a random password, etc.
  • Set up and schedule jobs that perform backups and database structure checks Viewer, etc
  • Monitoring SQL server performance using profiler to find performance and deadlocks.
  • Designed & implemented comprehensive Backup plan and disaster recovery strategies.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Working with SQL Server Integration Services in 2005 for moving DTS packages.
  • Rebuilding the indexes at regular intervals for better performance
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
  • Complete documentation about the database
  • Created and maintained ERD diagrams
  • Monitoring SQL server performance using profiler to find performance and deadlocks and blockings.
  • Export or Import data from other data sources like flat files using Import/Export of DTS
  • Recovering the databases from backup in disasters
  • Analyze long running slow queries & tune the same to optimize application and system performance.
  • Writing Stored Procedures / Transact-SQL scripts.
  • Creating / Scheduling Jobs, Alerts & Reports (Excel).
  • Monitoring Locks, Blocking and other general DBA duties.
  • SQL server profiler-used to generate workloads and test performance of databases and used the SQL server profiler to gather workloads over at least a 24-hour period
  • Analyze long running slow queries & tune the same to optimize application and system performance.
  • SQL enterprise manager-windows server 2000-Defined groups of server running SQL Server, Register Individual servers in a group, configure all SQL server options for each registered server, Create and administer all SQL server database objects, logins, users, and permissions in each registered server,
  • Define and execute all SQL server administrative tasks on each registered server with test SQL statements, batches and scripts interactively by invoking SQL Query Analyzer

Skills Used:MS SQL Server 2005/2000 with clustering, T-SQL, Win 2003, Oracle 8i, and Visual Basic 6.0 , SQL enterprise manager.

Hire Now