Sql Server Dba Resume
Hoboken, NJ
SUMMARY
- Microsoft Certified Professional (SQL Server) with 10 years of Professional experience. Experience in Design, Development and Database Administration of MS SQL Server 2016/ 2014/2 /2000 in Development/Test/Production environments
- Hands on experience in Installing, Configuring Microsoft SQL Server 2000/05/08/12/14 on 32/64 bit infrastructure in production, development and test environments
- Experience in Upgrade/Migration of several instances and databases from SQL Server 2005 to SQL Server 2008, SQL Server 2008R2 to SQL Server 2012 and 2014.
- Experience in Server Administration in various environments - Window 2000/ 2003/2008/2012 with Active Directory Services (AD, DNS, and DHCP).
- Experience in implementation of SQL Server 2012/2014 new features like AlwaysOn Availability Groups (AAG), In-Memory OLTP, Online Index Rebuilds, Central Management Server (CMS), Transparent Data Encryption (TDE), User-Defined Server roles.
- Managed and installed SQL Server Master Data Services (SSDS)in sql 2008R2/12/14
- Strong in monitoring and optimizing the Performance of Applications, databases, Stored Procedures, Queries and Indexes using Extended Events, SQL Profiler, Server Side Trace, Activity Monitor, Dynamic Management Views and Functions, Execution Plans, Performance Monitor, DBCC commands, Database Engine Tuning Advisor and other third party tools like Red Gate SQL Monitor, IDERA SQL Diagnostic Manager, Quest Spotlight.
- Strong in PowerShell scripting and automating day to day maintenance tasks using PowerShell scripts and improving SQL Server Maintenance Jobs performance.
- Experience in Source Control software Visual Source Safe and Team Foundation Server.
- Experience in programming tasks like developing Stored Procedures, Functions, and Triggers, ad-hoc queries for Reports, T-SQL batches, and procedures, PowerShell scripts.
- Experience in installing Hot fixes, Service packs on MS SQL Server 2005/08/12/14/16 across clustered and stand alone environment
- Experience in establishing strategies to manage data across servers using linked servers
- Created Database Maintenance Plan for optimization and integrity checks for all user and system databases
- Extensive experience with backup and restore procedures using native and third party backup tool like EMC Networker, SQL Safe
- Extensive experience with High availability and Disaster Recovery solutions including Failover Clustering, SQL Server Log Shipping, Replication and Database Mirroring
- Experience with SQL Server Surface Area Configuration to configure server level, instance level settings and their features
- Expertise with SQL Server Tools, including Enterprise Manager, Management Studio, Query Analyzer, Profiler, SQL Server Agent, DTS, SSRS, SSAS and SSIS
- Import & Export of various data formats using Data Transformation Services, DTSRun BCP, Bulk Insert and SQL 2005 Integration Services (SSIS) for data Exports and Imports
- Extensive knowledge in Creating Jobs, Alerts, operators, notifications and Scheduling DTS and SSIS Packages
- Experience in enforcing Minimal Privileges criteria in DB Security and creating Security Audits on production Databases having confidential data
- Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users
- Evaluate Error logs in Windows Event viewer, SQL Server Log, Activity monitor and Performance Monitor to determine and resolve various SQL Server issues
- Experience in designing and deployment of Reports for the End-User requests using Web Interface and SSRS (Ad-hoc Reporting).
- Gathered business requirements from the clients and converted them into functional requirements to support developers to build and robust and comprehensive product
- Created database install standard documents as needed as per industry standards.
- Experience in working on Virtual Machines with SAN.
TECHNICAL SKILLS
Databases: MS SQL Server 2016/ 2014/2 /2000 , Oracle 9i, 10g, 11g, MS Access 2000/2003, MySQL
Operating System: Windows Server 2012/2008/2003/2000 , AIX, Linux and Solaris
Languages/scripting: PL/SQL and T-SQL, PowerShell, VB script, Windows Batch
Virtualization: VMware 5.5/5.1/4.1, Microsoft Hyper-V
Web Technologies: Web Services, HTML, DHTML, Java, VBScript, IIS 7.5/7.0/6.0/5.0/4.0 , Application Server
Other Tools: VERITAS, IDERA Sql Safe, Crystal Reports, Test Director 7.0/7.5/8.0, PVCS Tracke7.0, Rational Clear Quest, MSTFS 2013/2010/2008 , Embarcadero DBArtisan 9.0.2, Redgate SQL Toolbelt, Spotlight, RDM, BIDS,SSDL,IDERA SQL DM,PPM, ServiceNow, BMC Pronet, BMC Patrol,CA Nimsoft, ServiceDeskManager, SolarWinds, Apex SQL compare,TestTrack.
PROFESSIONAL EXPERIENCE
Confidential, Hoboken, NJ
SQL Server DBA
Responsibilities:
- Managed and Administrated SQL Server 2008R2/12/14/16 Production and Non-Production servers.
- Assisted Windows Admin in order to determine Editions, Service Packs on Windows Server 2003/2008/2012 to configure High Availability Solutions and Disaster Recovery Strategy.
- Installation of SQL Server 2008R2/12/14/16 on Stand-alone and Clustered environment.
- Upgraded/Migrated SQL Server 2005/08/08R2 databases to SQL Server 2012/2014 databases
- Involved in Patching of SQL Server with latest service packs and applicable hot fixes for the entire SQL Server environment.
- Performed Database Backups using Backup Compression, Recovery Procedures and Disaster Recovery plans.
- Handled sharedpoint databases each from 10 to 200 GB with FullFarm size of 8 TB in Clustered environments.
- Capacity planning and Application Support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
- Setting up and Monitoring Replication, Database Mirroring and Log Shipping on Production, and Test servers
- Implemented SQL Server new features like Always-On Availability Groups (AAG), In-Memory OLTP, Policy Based Management, Resource Governor, Performance Data Collector, Transparent Data Encryption (TDE), and Multi Server Query on need basis.
- Created, scheduled database Maintenance Plans using PowerShell and SSIS Maintenance plan task and troubleshooting the failed jobs.
- Configured and deployed SSIS Packages from Test to Production Environments.
- Created, deployed and managed reports using SQL Server Reporting Services (SSRS).
- Used SCOM, Foglight, Solarwinds to monitor Servers, keeping the software-up-to-date, setting configuration and security policies.
- Extensively worked on SQL Profiler, Activity Monitor, Performance Monitor, Dynamic Management Views (DMVs), Dynamic Management Functions (DMFs) and Database Tuning Advisor (DTA) to tune the databases, servers and to identify the long running queries.
- Performed Online Index Rebuilds for Critical tables and helped in reducing locks, improving query performance and made tables available during index rebuild operations.
- Reviewed Stored Procedures developed by the developers and gave recommendations for the code modifications for Production.
- Optimizing performance of individual queries at the lowest granularity level by analyzing Execution Plans and estimating their cost of execution.
- Used Performance Monitor to Help Identify SQL Server Hardware Bottlenecks.
- Involved in setting up Report Server for SQL reporting purposes.
- Managed Security using SQL Logins, Roles and Security Modes for various users.
- Used ServiceDesk Manager, IBM Rational Clear quest, TestTrack as a ticketing system to move DDL/DML changes to different databases.
Environment: SQL Server 2016/14/12/08 R2/08,Windows Server 2012/08/03 server, WSFC, BIDS, SQL Profiler, Performance Monitor, T-SQL, PL/SQL, TFS, SSIS, SSRS,SSDT, VB.NET, ASP.NET, C#.NET, VM ware, Foglight, ERWIN, System Center Operations Manager (SCOM), MS Office, SQL Mon, SCCM, PowerShell, PPM, ServiceDeskManager, SolarWinds, SQLSafe, Apex SQLCompare, TestTrack.
Confidential, Jersey City, NJ
Senior SQL Server DBA
Responsibilities:
- Administrated and manage SQL Server 2008R2/2012/2014 Production and Non-Production servers.
- Assisted Windows Admin in order to determine Editions, Service Packs on Windows Server 2003/2008/2012 to configure High Availability Solutions and Disaster Recovery Strategy.
- Installation of SQL Server 2008R2/2012/2014 on Stand-alone and Clustered environment.
- Upgraded/Migrated SQL Server 2008/08R2 databases to SQL Server 2012/2014 databases
- Involved in Patching of SQL Server with latest service packs and applicable hot fixes for the entire SQL Server environment.
- Performed Database Backups using Backup Compression, Recovery Procedures and Disaster Recovery plans.
- Handled from 50GB to 1.5TB Size databases in both Stand-alone and Clustered environments.
- Capacity planning and Application Support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks.
- Setting up and Monitoring Replication, Database Mirroring and Log Shipping on Production, and Test servers
- Implemented SQL Server new features like Always-On Availability Groups (AAG), In-Memory OLTP, Policy Based Management, Resource Governor, Performance Data Collector, Transparent Data Encryption (TDE), and Multi Server Query on need basis.
- Created, scheduled database Maintenance Plans using PowerShell and SSIS Maintenance plan task and troubleshooting the failed jobs.
- Configured and deployed SSIS Packages from Test to Production Environments.
- Created, deployed and managed reports using SQL Server Reporting Services (SSRS).
- Used SCCM to monitor Servers, keeping the software-up-to-date, setting configuration and security policies.
- Extensively worked on SQL Profiler, Activity Monitor, Performance Monitor, Dynamic Management Views (DMVs), Dynamic Management Functions (DMFs) and Database Tuning Advisor (DTA) to tune the databases, servers and to identify the long running queries.
- Performed Online Index Rebuilds for Critical tables and helped in reducing locks, improving query performance and made tables available during index rebuild operations.
- Reviewed Stored Procedures developed by the developers and gave recommendations for the code modifications for Production.
- Optimizing performance of individual queries at the lowest granularity level by analyzing Execution Plans and estimating their cost of execution.
- Used Performance Monitor to Help Identify SQL Server Hardware Bottlenecks.
- Involved in setting up Report Server for SQL reporting purposes.
- Managed Security using SQL Logins, Roles and Security Modes for various users.
- Used servicenow, PPM 2010/2013 as a ticketing system to move DDL/DML changes to different databases.
Environment: SQL Server 2014/2012/2008 R2,Windows Server 2012/2008/03 server, WSFC, BIDS, SQL Profiler, Performance Monitor, T-SQL, PL/SQL, TFS, SSIS, SSRS,SSDT, VB.NET, ASP.NET, C#.NET, VM ware, Litespeed, ERWIN, Redgate, MS Office, SQL Mon, SCCM, PowerShell, PPM, ServiceNow, BMC Pronet, BMC Patrol,CA Nimsoft.
Confidential, New York, NY
SQL Server DBA
Responsibilities:
- Managed and Administrated the SQL Server 2008/05/00 production and Non-production servers.
- Assisted Windows Admin in order to determine editions, service packs on Windows Server 2003/2008 to configure custom High Availability Solution and Disaster Recovery Strategy
- Installation of SQL Server 2008/05 on Windows Server Clustered environment.
- Worked on Conceptual, Logical, Physical data modeling and Performance Analysis
- Performed backup using backup compression, recovery procedures and disaster recovery plans
- Handled up to 800 GB Size databases over clustered environment.
- Used SQL Server Surface Area Configuration to configure server level and instance level settings capacity planning and application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks
- Setting up and Monitoring replication, Database mirroring and Log shipping on Production, and Test servers
- Expert in SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector, Transparent Data Encryption (TDE), Object Search, IntelliSense, Activity monitor and Multi Server Query
- Upgraded SQL Server 2005/00 databases to SQL Server 2008/05 databases including DTS to SSIS packages
- Created, scheduled database maintenance plan using SSIS Maintenance plan task.
- Configured and deployed SSIS Packages from Test to Production Environments.
- Created, deployed and managed reports using SQL Server Reporting Services(SSRS)
- Extensively worked on Profiler, Performance Monitor, dynamic management views (DMV), dynamic management functions (DMF) and database tuning advisor (DTA) to tune the databases, servers and query tuning.
- Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, indexes, views, tables, re-indexing, structure modifications and functions
- Reviewed stored procedures developed by the developers and gave recommendations for the code modifications for production
- Optimizing performance of individual queries at the lowest granularity level by analyzing Execution Plans and Estimating their cost of execution
- Used Performance Monitor to Help Identify SQL Server Hardware Bottlenecks
- Managed Security using SQL Logins, Roles and Security Modes for various users
Environment: SQL Server 2008R2/08/05/00, Advanced Windows 2008/03 server, XML, VSS, BIDS, SQL Profiler, Performance Monitor, T-SQL, PL/SQL,DTS RUN, TFS, SQL*Loader, SSIS, SSRS, SSAS, VB.NET, ASP.NET, C#.NET, VM ware, TSM,LDAP, Litespeed, ERWIN, ER/studio, Spotlight, Redgate, Big Brother, MS- Excel, SQL Mon
Confidential, Dublin, OH
SQL Server DBA
Responsibilities:
- Designed and implemented 24x7 Enterprise SQL SERVER Production clusters
- Built Disaster recovery site using high availability log shipping technologies with in 5 mints time frame
- Data Modeling, Architectural Design & Implementation
- Enabled server side tracing using SQL profiler to fine tune the application
- Developed Backup Policies using security standards
- Design and Implementation of Business Intelligence applications using SQL Server 2005 Integration Services (SSIS), SQL Server Reporting Services.
- Writing T-SQL queries, Views, Stored Procedures and User Defined Functions.
- Troubleshooting performance issues, fine-tuning queries and stored procedures.
- Database backup and restore operations
- Resolved production performance issues
- Implemented Database auditing strategies using Database triggers
- Using BCP and DTS utility for Meta data transfer across servers
Environment: SQL Server 2008/05/00, Advanced Windows 2003 server, XML, VSS, BIDS, SQL Profiler, Performance Monitor, T-SQL, PL/SQL, TFS, SQL*Loader, SSIS, SSRS, SSAS, VB.NET, ASP.NET, C#.NET, VM ware, TSM, Litespeed, ERWIN, ER/studio, Spotlight, Redgate, MS- Excel, SQL Mon
Confidential
Database Developer/Administrator
Responsibilities:
- Involved in the installing and configuring SQL SERVER 2000 in clustered environment
- Designed and developed databases using SQL SERVER 2000
- Prepared high level and detail database design documents for development modules
- Prepared unit test plans and DFDs and process level diagrams for the Code development
- Wrote stored procedures for Search engines and updating database.
- Used triggers, cursors and error handling in development
- Designing and implementing Backup/Restore Strategies for the SQL database.
- Prepared new indexes and tuned the indexes for complex table JOINs
- Monitored SQL Server and system performance using tools provided by SQL Server 2000 on Windows NT 4.0
- Optimized existing stored procedures, database triggers and SQL scripts on Server level
- Helped development team to audit Front - end application calls to SQL Server to create efficient Queries, Indexes, Views and Stored procedure
- Install, setup and maintain Replication Server
- Developing ASP/HTML User Interface (UI) design
- Configured client workstation with client OS and permissions for users and user groups
- Monitored activity logs and system activity
Environment: SQL Server 2000, V.B 6.0,Visual Source Café, Visual InterDev, HTML,ASP, JAVA SCRIPT,VB Script, IIS 5.0, Crystal Reports And Windows 2000 Advanced Server