Sr. Sql Server Dba Resume
Hoboken, NJ
SUMMARY
- 7+ years of IT experience in Database Administration, Design Development and Support of SQL Server 2014/2012/2008 R 2/2008/2005/2000 in Production, Test, Development and ClusterServer Environments.
- Experience in applying latest and service packs security patches.
- Experience in maintaining and keeping the SQL Server inOptimal Performance.
- Experience in Writing the SQL queries, Stored Procedures, Functions, and Views.
- Experience in creating and deploying RFC (Request for change).
- Worked on 2012 Always on High Availabilitynodes and theAvailability Groups.
- Experience in RDBMS database design, performance tuning and monitoring, optimization, backup and recovery in SQLServer2000 andSQLServer 2005/2008/2012.
- Worked on Ticketing System Remedy, Service desk and magic.
- Creating and Managing Virtual Machines in Windows Azure and setting up communication with the help of Endpoints and also VM Migrations from Transitional hosts on Canada Boxes.
- Experience in usingSQLServerTools like DTS, Import/Export Wizard,SQLServerEnterprise Manager,SQL Server Management Studio, SQLProfiler, DTA andSQLQuery Analyzer.
- Scheduled weekly jobs and Maintenance tasks for better performance, created the alerts with Database Mail SMTP
- Migration experience from MSSQLServer2000 to MSSQLServer2005/2008, MSSQLServer2005 to MSSQLServer2008 & SQL Server .
- Analyzed Performance using Performance monitor in order to identify the bottleneck and create performance counters such as CPU, memory, Capacity planning, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
- Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
- Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
- Experience in Power shell for automation.
- Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.
- Extensive in Performance Tuning & Index Tuning and Defragging Disaster Recovery Planning, Security Management, Managingserverand clients.
- Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQLServer and failover clustering.
- Good experience withSQLServer2005/2008 Online Database Indexing and Recovery. Solid experience on high availabilitySQLServersolutions, including Replication Models (Snapshot/Transactional) andSQLServerclustering (Active - Active, Active-Passive).
- Expert in using Bulk Copy Program (BCP).
- Build ETL processes utilizing SSIS and DTS, including FTP data from remote location, transform and Data Transformation Services (DTS) packages and SSIS (integration services) with MSSQLServer 2005/2008/2012.
- Designed and developed tables, functions, stored procedures and triggers in SQL Server 2008R2/2012.
TECHNICAL SKILLS
Databases: MS-SQL Server 2005/2008R 2/20012/2014 , MS Access 2003
Languages: C, C+, VB Script, Java Script, HTML, XML
SQL Server Tools: Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyser, Export & Import, Precise i3 for SQL Server
Operating systems: Windows 2008/2003
Software Packages: MS Office 97/2000/XP,2003,2007, MS Outlook 2003,2007,Visio
PROFESSIONAL EXPERIENCE:
Confidential, Hoboken, NJ
Sr. SQL Server DBA
Responsibilities:
- Involved in Planning for Upgrades and Migration of major systems from SQL Server 2008 R2 to 2012/2014.
- Involved in Mapping data for safe and secure Data Transfer
- Installed, managed and administrated the MS SQL Server 2008R2/2012 Production and Non Production Servers
- Monitored Log shipping/Transactional Replication and trouble shooting of errors
- Extensively worked on Profiler, Perform Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning
- Used Database Consistency Checks - DBCC commands for database maintenance
- Detected and Resolved Locks and Deadlocks using the Trace Flags and Native tools like Profiler and the Activity Monitor
- Running Index Tuning wizard for optimal query performance.
- Performed all aspects of database administration, including backups andrecovery
- Handled orphaned users while moving databases.
- Automated most of the DBA Tasks and monitoring stats.
- Created a mirrored database for reporting using Database Mirroring with high performance mode.
- Worked on 2012 Always on High Availabilitynodes and theAvailability Groups.
- Responsible for SQL Server Edition upgrades and SQL Server patch management.
- Created Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
- Creating and managing schema objects such as Tables, Views, Indexes and referential integrity and converting them into technical specifications.
- Creating databases and logins and users with permissions in SQL server 2008.
- Proactively monitored, determined and solved issues at SQL/database
- Automated most of the DBA Tasks and monitoring stats.
- Created a mirrored database for DR using Database Mirroring with high performance mode.
Environment: SQL Server 2014/2012/2008 R2 Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7), Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/ 2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, Sybase, DB2 UDB
Confidential,Washington, DC
SQL Server DBA
Responsibilities:
- SQL Server 2008R2/2012 Database Administration.
- Involved in Module development.
- SSIS package design and module design.
- Physical design and implementation SQL Server databases.
- Involved in creating SSIS packages for importing data from text file to database tables.
- Work with Dev team and involved to provide technically support.
- Used SSIS to populate data from various data sources and also in the creation of packages for different data loading operations for applications and to export data from other sources to SQL databases
- Worked on 24x7 On-Call rotation.
- Installed, managed and administrated the MS SQL Server 2008R2/2012 Production and Non Production Servers
- Migration of SQL Server 2008R2 in place as well as side by side to MS SQL Server 2012
- Hands on experience in handling RFC (Request for Chance) creating and deploying the RFC.
- Work on Remedy ticketing tool (Going through ITSM process)
- Experience in writing SQL queries and optimizing the queries in SQL Server 2008R2.
- Scheduled weekly jobs and Maintenance tasks for better performance, created the alerts with Database Mail SMTP.
- Creating and Modifying Tables, T-SQL Stored Procedures, Views, Indexes, User-defined Functions, and Triggers as required.
- Create triggers to keep track of changes to the fields of tables when changes are made.
- Ensure all database environments (Development, QA, UAT and Production) are in sync (DB Refresh when requested).
- Created DB objects such as Tables, Stored Procedures, Views and Triggers as required.
- Used SSRS to create reports that draw content from a variety of data sources
- Define DB scripts versioning system to keep track of database versions for all environments
- Prepared the reports for the day-to-day as well as weekly/monthly purposes
- Actively participated in determining the database schema, database schema changes, implementation plan for database schema releases in coordination with developers and data modelers in adherence with Organization policies
- Worked on installation of ESM MSSQL Server Module on Production and Non Production Servers
- Monitored Log shipping/Transactional Replication and trouble shooting of errors
- Extensively worked on Profiler, Perform Counters, DMVs, DMFs and DTA to tune the databases, servers and query tuning
- Worked on ESM Remediation removing, fixing violations using Windows ESM Console on Production and Non Production Servers
- Implemented Database Mirroring and Transactional Replication as a part of DR plan
- Rebuilt indexes with different fill factors and update statistics manually
- Running Index Tuning wizard for optimal query performance
- Performed all aspects of database administration, including backups andrecovery
- Handled orphan users while moving databases.
Environment: SQL Server 2008 R2/2012 Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7), Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/ 2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, Sybase, DB2 UDB
Confidential
SQL Server DBA
Responsibilities:
- SQL Server 2005/2008R2 Database Administration
- Installed, managed and administrated the MS SQL Server 2008R2 Production and Non Production Servers
- Creating MySQL databases as well as administration including maintenance and backups etc.
- Excel at developing and implementing reporting and data solutions, including custom user interfaces.
- Plan, design, and implement application database code objects, such as stored procedures and views in VB.NET.
- Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
- Involved in all phases of the project.
- Monitored Log shipping/Transactional Replication and trouble shooting of errors
- Documented Database environment, Escalation procedures, issues, Installation procedures, Disaster recovery procedures In Database Management Prod Guide.
- Managed Security like windows andSQLLogins, Roles, permissions for various users.
- Worked on Troubleshooting Mirror, Log shipping and Transactional replication synchronization issues.
- Worked on Troubleshooting Application and Backup jobs failed issues andSQLcluster installation and cluster resources failed issues.
- Upgrades to SQL Server 2008 and guiding the development and application team to fully utilize SQL Server 2008 enhancements.
- Monitoring via SQL modules like Diagnostic manager for performance issues like excessive locking, table scans, deadlocks, fragmentation and other bottlenecks.
- Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
- Extracted data from various sources like SQL Server 2005/2008, Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
- Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and to troubleshoot SQL Server related CPU, memory, Disk I/O, and other resource contention.
- Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases.
- Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
- Performed all aspects of database administration, including data modeling, backups andrecovery.
Environment: SQL Server 2008 R2/2008 Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7), Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/ 2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, Sybase, DB2 UDB
Confidential,Detroit, MI
SQL Server DBA
Responsibilities:
- Installed SQL Server 2008r2 on Standalone and Clustered Environments.
- Upgraded /Migrated of SQL Server from version r2.
- Installed Microsoft Service Packs/Patches/Hotfixes.
- Configured and administered SQL Clusters (Active/Passive, Active/Active), Database Mirroring, Replication and Log shipping.
- Conducted Backup and Restore of Databases and Schedule Maintenance plans to perform regular Backups.
- Performed Attach/ Detach, BCP, Import & Exports and Copy Database Wizard.
- Created Tables, Stored Procedures, Views, Triggers, Cursors and Complex Queries on SQL Server 2005/2008.
- Query Optimization and Performance tuning for optimization like maintaining/creating indexes, Create/Update Statistics, Tuning SQL queries.
- Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
- Trouble shoots Memory Errors/Query Processing and usage of Memory and resolving errors pertaining to insufficient Memory.
- Trouble shoots and resolved Blocking, Deadlocks and Long Running Queries.
- Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
- Developed, deployed and monitored SSIS Packages including upgrade from DTS to SSIS.
- Created Reports using SSRS 2005/2008.
- Utilized DMV’s, Data partitioning and Performance Dashboards reports with SQL Server2005.
- Configured Snapshot, Transactional and Merge Replication of SQL Server databases and Troubleshoots Replication Problems.
- Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
- Created various Jobs, scheduled & ran jobs and trouble shoots the failed jobs.
- Provide 24X7 support for the Critical issues like Server Failures and Database inconsistencies like Database Log File full, Suspect, Offline, Missing log files etc.
Environment: Windows 2003, MS SQL Server 2005/2008/2008 r2, T-SQL, Visual Studio.Net 2003, Crystal Reports, LITESPEED, MS Access, DTS, BCP, SSIS, SSAS, SQL Profiler.
Confidential, Chicago, IL
SQL Server DBA/ Developer
Responsibilities:
- Installation ofSQLServer2005 with latest Service Packs.
- Worked in Active/Passive Clustered Environment.
- Writing stored procedures for report generation in migration process and replication.
- Implemented the migration ofSQLServer .
- Wrote severalSQLScripts such as finding long running queries, blocking sessions, archiving data from production to archiveserverand populating reporting data.
- Experience in monitoring software tools used to monitor the environment effectively.
- Successfully implemented Database Mirroring inSQLServer2005 for high availability.
- Maintain both DEVELOPMENT and PRODUCTIONserverin sync.
- Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
- Involved in Monitoring Performance of different productionservers.
- Worked in 24x7 production environment.
- Working with the end user gathering requirements for the system.
- Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
- Creating Logins and Roles with appropriate permissions.
- Prepared and documented Backup & Restore Plans.
- Creating and Maintaining Database Maintenance Plans.
- Extensively involved in designing the SSIS packages to export data of flat file source toSQLServer database.
- Involved in analyzing the system for setting up newserverandserverconfiguration.
Environment: Windows 2000/2003server, MSSQLServer2000/2005, Erwin, MS Excel, Dell/EMC CX3/CX Series SAN Arrays.