Sql Server Dba Resume
Hoboken, NJ
SUMMARY
- 7+ years of experience in Database Administration and Development for very large and complex databases on SQL Server 2012, 2008 and SQL Server 2005/2000.
- Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
- Experience with SQL 2012 ALWAYS ON and upgrades from SQL 2008
- Implemented the new SQL Server 2008 R2 mechanisms like DDL triggers, data compressions, backup compression, online indexing, security with principals and securable.
- Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
- Experience in high availability SQL Server solutions, including Log Shipping, Replication, Mirroring and SQL Server Clustering.
- Expertise in database Backup, Recovery and Disaster recovery procedures (Logshipping, Mirroring, clustering, Replication and SRDF).
- Experience in Backing up, restoring the data base manually and also by scheduling the jobs and Maintenance Plans.
- Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer and also Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS).
- Experience in using different Transformation tools like DTS Packages, SSIS, BCP and BULK INSERT.
- Expertise in planning and implementing MS SQL Server Security and database Permissions.
- Experience in Query Optimization, Database Consistency Checks using DBCC Utilities, and Linked Servers and also analyzing the execution plan and index management for better Query Optimization.
- Experience in using DMV and dynamic management functions for finding out long running queries.
- Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, performance monitor, activity monitor, event viewer for performance analysis.
- Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
- Handling Memory configurations for SQL Server 2005 and SQL Server 2008 on Windows 2008.
- Experience in Data Migration from MS SQL server and from .
- Knowledge in Installing and configuring Cluster SQL Servers in Active/Passive environment.
- Administering SQL Server High Availability and Disaster Recovery strategies.
- Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
- Strong experience in mentoring team members and writing documentation.24 X 7 Production Database on Call Support.
- Good interpersonal skills, committed team player with team driven skills.
- Good communication skills, written and verbal presentation skills.
TECHNICAL SKILLS
Databases & Services: SQL Server 2000/ 2005/2008/2012 , MS - ACCESS, SSIS, Reporting Services, Business Intelligence, Database Tuning Advisor, SQL Server 2000/7.0, T-SQL, MSDE, OLAP, Query Analyzer, SQL Profiler, Performance Monitor, Index Tuning, Replication, DTS, BCP, Agent, Jobs,, ODBC, JDBC
Disaster Recover Tools: Log Shipping, and MSCS Fail over Clustering Services
Programming/Scripting: T-SQL Programming
Operating Systems: Windows XP/NT/ 2000/2003/2008 , Vista, UNIX
Microsoft Office suite: Word, Excel, Power Point, Outlook, Access, Visio, MS-Project.
Protocols: TCP/IP, HTTP, FTP, SSH, TELNET
Virtualizations: VMware vSphere client, ESX 3.0, 4.0 and ESXi4.1.
PROFESSIONAL EXPERIENCE
Confidential, Hoboken, NJ
SQL Server DBA
Responsibilities:
- Managed security on Production and Development environments.
- Monitored the complete environment for resource utilizations and to avoid any bottlenecks.
- Creating and maintaining various databases on Production and development environments usingSQLServer 2008/2012.
- Created jobs to import/ export data obtained from various States to update the GIS servers.
- Installed and configured SQL Server Reporting Services. Installed necessary Service Packs for SQL server 2005.Installed SQL server2005,2008and2012on a test environment to be the future production environment. Upgraded legacy 2000 databases to SQL server2005/2008.
- Involved inDatabase Backupandrecovery.
- Implemented high availability on the various servers usingreplication/mirroring.
- Tuned databases for better performance.
- Created and maintained various logins and managed security based on the required access.
- Implemented and tested the point in time recovery of the production databases.
- Involved in migrating share point from one server to the other.
- Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.
- Implemented high availability and disaster recovery using database mirroring with log shipping and Clustering.
- Optimized the performance of queries with modifications inT-SQLqueries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
- Loaded the data into another data sources (Oracle, SQL Server) usingSSIS.
- Created variousSSISpackages based upon the requirement.
- Created various reports usingSSRS.
- Scripting theDatabase Consistency Checks(DBCC), scheduling the scripts to run daily and weekly basis.
- Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes andfine tuningStored Procedures).
- Data migration usingDTSservices across different databases like Oracle, MS access & flat files.
- Contacted various users in gathering the requirements and documented the necessary changes.
- Analyzed variousbackupcompression tools available and made the recommendations.
- Created necessary templates for various requirements gathering anddocumentation.
Environment: Windows 2000/2003, MS SQL Server 2005/2008/2012 , ETL, Oracle10g/11g, SSRS, DTS, SSIS, SQL Server Profiler,VB.Net, T-SQL, Erwin 4.0, Erwin 3.5.2, Database engine tuning Advisor, IIS.
Confidential, Jersey City, NJ
SR SQL DBA
Responsibilities:
- Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server.
- Implementation of SQL Logins, Roles and Authentication modes as a part of security policies for various categories of user support.
- Implemented SQL Server high availability solutions including clustering, replication and log shipping.
- Worked in Active/Passive and Active/Active cluster environment.
- Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes.
- Experience in Database Backup and Recovery procedures.
- Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans.
- Using Performance Monitor/Profiler to solve Dead Locks/Long running queries.
- Migration of databases from SQL server 2000 to SQL server 2005.
- Disaster recovery and Log shipping of SQL Servers meeting the Service level agreements for the various customers.
- Experience in implementing different types of Replication models like Transactional replication.
- Successfully planned and implemented SQL Server 2005 Database Mirroring.
- Implemented Database Mirroring on SQL Server 2008 environments.
- Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
- Implemented transactional replication for data refresh.
- Providing 24x7 technical database supports for SQL Database systems.
- Experience in supporting and managing multiple Production, Staging & Development instances.
- Managed all Publisher, Distributor and Subscriber database environments for the replication.
Environment: MS SQL Server 2008/2005/2000 , Windows 2003/2000 Server Operating systems, IIS 6.0, .NET, T-SQL,SSIS, SSAS, XML.
Confidential, San Francisco, California
MS SQL Server DBA
Responsibilities:
- Performing SQL server daily health check and preparing a report based on it.
- Monitoring Disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.
- Handling creation of new SQL Server databases as per Client/Application Team request using Build Sheet Template.
- Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.
- Participated in DR installation and trouble shooting(Mirroring, Logs hipping and High availability Cluster.
- Applying Service Packs and Security patches for the Servers as released.
- Installed SQL Server 2005/2008 on Active/Passive and Active/Active clusters as part of Upgrade.
- Monitoring the Log Space for successful execution of all the specified jobs.
- Managing backups on a daily basis and recovery (as per request).
- Reviewing SQL Server and SQL Server Agent Error Logs.
- Monitoring of server performance by profiler during peak periods of server utilization.
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security policies and also preparing Auditing Reports for following auditing standards.
- Setting Perform counters for monitoring the server as per request about degraded performance from Application Team and then passing the trace files for L3 for an advanced review.
- Configuration and Maintenance of Log Shipping, Mirroring & Replication across different environments.
- Develop, implement and administer database policies and procedures and provide technical support and assistance to all database end-users.
Environment: SQL Server 2005, SQL Server 2008, Windows 2008, Windows 2003 EE, Cluster.
Confidential - Alpharetta, GA
MS SQL DBA
Responsibilities:
- Extensively involved in database mirroring, creating Back up Strategy. Resolving Dead locks and blocking issues.
- Extensively Involved in Designing (Logical and Physical) of Customer Database. Created & managed the Database Users, Login and Security.
- Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database. Removed fragmentation from indexes.
- Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using SQL.
- Creation of Jobs, Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail
- Administrator tasks such as managing users, roles, and profiles.
- Created Packages and jobs to perform filtering operations and to import the data on daily basis from the Oracle DB to SQL server.
- Provided support for Clustering environment, DTS packages and Transactional/Merge replication.
- Experienced in performance tuning using Windows performance monitor and SQL profiler of SQL server.
- Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using SSIS, BCP. Extracting, Transforming and loading of data using SSIS.
- Deployed and scheduled SSIS Package. Performed analysis and design of the application.
- Experience in with tools like Microsoft Reporting Services (SSRS). Created and deployed and scheduled report using SSRS.
Environment: SQL Server 2005/2000, (Query Analyzer, Enterprise Manager, SSIS packages, SQL Profiler), Clustering, MS Access, My SQL, MS Excel, MS Word, and Windows XP
Confidential
MS SQL Developer/ETL/SSIS/SSRS
Responsibilities:
- Wrote T-SQL statements using DML and DDL for retrieval of the data.
- Used DTS service for the data transformation from source to target database.
- Supported clustering and replication for servers.
- Created complex stored procedures, triggers and cursors in SQL Server.
- Developed source to target specifications.
- Maintained cluster servers to provide high availability.
- Developed stored procedures, functions, views and triggers.
- Created DTS package to schedule the jobs for batch processing.
- Scheduled the DTS packages using the Data transformation services SQL2005.
- Performance tuning to optimize SQL queries using query analyzer.
Environment: MS SQL Server 2005, MS SQL Server 2000, Windows Server 2003, SSRS, SSIS, Transact-SQL, DTS
Confidential
MS SQL Developer
Responsibilities:
- Involved in various stages of SDLC like Design (Logical & Physical), Development, Implementation and Testing.
- Designed application database on coded objects such as stored procedures and views.
- Utilized SQL scripts and complex queries to analyze and extract data.
- Supported business applications using T-SQL.
- Provided database coding support using SQL server environment.
- Tested the quality of application developers including data file for counterfeits.
- Normalized the status of new discovered processes and applications.
- Identified business needs and requirements including business securities.
- Modified existing applications to ensure data integrity and security.
- Performed disaster recovery plans for all data services.
Environment: MS SQL Server 2000, 2005, Windows Server 2003, 2000, SSIS, SSRS.