SQL Server Database Administrator Resume Example
Love this resume?Build Your Own Now
SQL SERVER DATABASE ADMINISTRATOR
Profile
SQL Server Database Administrator Over 8 years of working experience in SQL Server Database Administration, Performance Analysis, Database Design, Development and Support of SQL Server 2012/2008/2005 in Production, Development, Test, Cluster and Replication Server Environment. A highly qualified, goal-oriented IT professional with extensive experience with SQL Server 2012/2008/2005 Database Administration in 24x7x365 environment.
Core Qualifications
|
Professional Experience
10/2015 to Current
SQL Server Database AdministratorDeloitte － Rosslyn , WA
- Installed SQL 2012/2014 with AlwaysOn ( 2 & 3 rep;icas).
- Good hands on issues with the AlwaysOn.
- Build Clusters 2 node and 3 node with Active -Active and Active- Passive.
- Well equipped with the working knowledge of application development life cycle methodologies, database and application performance tuning.
- Expert in installation and configuration of MS SQL Server 2014/2012/2008/2005 Databases.
- Extensive experience in SQL server 2005 servers to 2008, SQL server 2008 servers to 2012 including Replication and clustered SQL Servers and as well as side-by-side upgrade process.
- Experience in Planning and executing disaster recovery (DR) exercises on the DR servers.
- Expertise in mentoring and setting up High availability environments like active-active and active-passive clustering, Database Mirroring, Replication (Snapshot, merge, transactional), Log shipping, setting up servers from scratch on clustered environment, Linked servers.
- Responsible to follow the company guidelines / regulations to ensure company data is held in a secure manner, including electronic access or in written format.
- Gathering data requirements, and designing and fine-tuning of databases as per the requirement of clients.
- Complete Administration of MS SQL Server Databases is my primary responsibility Increased the Server Availability time with optimum level of Database Recoverability by incorporating the SQL server Differential backup and LOG Backup.
06/2015 to 10/2015
SQL Server Database AdministratorDeloitte － Rosslyn , WV
- Georgia-Pacific is one of the world's leading makers of tissue, pulp, paper, packaging, building products and related chemicals.
- If you're a consumer, you may recognize our household brands, such as Brawny® paper towels, Quilted Northern® bath tissue and Dixie® cups and tableware.
- If you're in the construction business, you're probably familiar with our engineered lumber products, gypsum panels and other quality building materials.
- Responsibilities: Installing, configuring and administration of SQL Server Databases 2008/2012.
- Performed patching to maintain current versions of SQL.
- Worked On AlwaysON Environment.
- Created AlwaysOn with two replica and three replica.
- Good hands On Log shipping and Mirroring.
- Implemented Log shipping and mirroring as a part of HA and DR.
- Supported Customer service databases which are more than 2TB.
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Played an active role in requirements gathering, blueprint, design , configuration and documented Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency Complete documentation about the database Created groups, roles, users and assigned access privileges to users.
- Scheduled jobs and alerts using SQL Server Agent.
- Documented HA and DR strategies.
- Actively Participated in DR Test.
- Implemented Robocopy process with SQL Agent to automate the file transfer Environment: MS SQL Server 2008/2008R2/2012, Business Intelligence - MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), SQL Agent, SQL Profiler, Comm Vault, Database Mail, T- SQL,Windows2003/2008 server, SQl sentry, Visual Studio.
11/2013 to 06/2015
SQL Server DBAIron Mountain － Reston , VA
- BancShares) is a financial holding company.
- The Company conducts operations through its banking subsidiary, First-Citizens Bank & Trust Company (First Citizens Bank).
- First Citizens Bank operates around 570 branches in 18 states.
- The Company provides treasury services products; cardholder and merchant services, and wealth management services, among others.
- The Company invests the liquidity generated from the funding sources in interest-earning assets, including loans and leases, investment securities and overnight investments.
- Responsibilities: Worked on 2005, 2008 ,2012 and 2014 versions of SQL Involved In Building out New secondary Data- center servers, by configuring SQL 2005/2008/2012 with DR Strategy.
- Performed Server installation and configuration using SQL Server 2008 R2/2012/2014 Geo-Clustering with 2 and 3 nodes(multi-subnet) Experience working in Active/Passive, Active/Active cluster environment.
- Expertise implementing high availability with Always On Availability Groups and failover clustering.
- Implemented Database mirroring and replication to keep data live.
- Supported Financial Crimes and Risk Management Databases for Suspicious activity monitoring, case Management which are about 1.5TB in PROD Environment and 3TB all together in DEV/QA and UAT environments.
- Also Supported Bank Operations Database which are about 3TB in PROD and also other small application closer to Terabyte of data.
- Managed unstructured data in SQL Server 2008 using filestream.
- Involved in configuring SQL jobs and Windows tasks for performing scheduled activities like backups and purging / archiving data.
- Monitoring SQL jobs, Performance bottlenecks, configuring databases, backup/restore DB.
- Worked on Configuring data files; log files and Tempdb as per RAID features.
- Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users Query tuning and performance optimization for the database.
- Creating mail profile and Setting up Alerts using SQL Mail Experienced in resolving deadlock and blocking issues for concurrent users Applying SQL server patches and Migration to different versions of SQL.
- Worked on Auditing the logins and users in multiple servers.
- Daily Tickets and other Deployment/New Application Rollout's and Change Requests Performed Data Migration using 2012/2008/2005.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency Database space management/OS level space management.
- Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, enabling Database level trace for performance test.
- Experience with converting Microsoft Excel, Microsoft Access, text files and other formats into a SQL Server database.
- Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, enabling database level trace for performance test.
- Environment: MS SQL Server, Database Mail, T- SQL,Windows2003/2008/2012 server, MS Excel, MS Access, TSM, Idera, CommVault, SCOM.
03/2012 to 10/2013
Server DBAIron Mountain － MN
- The TJX Companies, Inc.
- is the leading off-price retailer of apparel and home fashions in the U.S.
- and worldwide, ranking No.
- 103 in the 2015 Fortune 500 listings, with $29.1 billion in revenues in 2014*, more than 3,300 stores in 7 countries, 3 e-commerce sites, and approximately 198,000 Associates.
- We operate T.J.
- Maxx and Marshalls (combined, Marmaxx), HomeGoods and Sierra Trading Post, as well as in the United States; Winners, HomeSense, and Marshalls (combined, TJX Canada) in Canada; and T.K.
- Maxx in the United Kingdom, Ireland, Germany, Poland, and Austria, as well as HomeSense in the U.K.
- combined, TJX Europe).
- Responsibilities: Installing, configuring and administration of SQL Server Databases 2008/2012.
- Worked under Active/Passive and Active/Active cluster environment.
- Analyzed results of the tests by creating reports.
- Performed patching to maintain current versions of SQL.
- Worked On AlwaysON Environment.
- Implemented transactional replication and mirroring on part of AlwaysOn Availability Group.
- Actively participated in migration of databases from 2005 to 2008 and 2012.
- Supported Customer service databases which are more than 2TB.
- Expertise in designing databases and capacity planning.
- Working on data mining and Microsoft analysis services.
- Analyzed results of the tests by creating reports Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Played an active role in requirements gathering, blueprint, design, configuration, project reviews with users and sign offs.
- Rebuilding the indexes at regular intervals for better performance.
- Updating/Deleting Filestream Data.
- Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
- Monitored and modified Performance using execution plans and Index tuning.
- Rebuilding the indexes at regular intervals for better performance Managing the VERITAS net backups.
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency Complete documentation about the database Designed and created databases, tables, views, store procedures and triggers.
- Developed various views and functionalities for the Affinity Compensation system department according to their specification.
- Designed and developed file loading process by creating complex stored procedures, functions and bind them with DTS package for logical execution.
- Created DTS packages for migration of data from SQL Server to MS Access or Oracle Databases.
- Wrote optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
- Created groups, roles, users and assigned access privileges to users.
- Exported and imported data from text files and Excel T-SQL Server database using bulk copy insert and BCP utility.
- Tuned the performance of SQL queries and Stored procedures using SQL Profiler and Index Tuning Wizard.
- Scheduled jobs and alerts using SQL Server Agent.
- Environment: MS SQL Server 2012 Enterprise Edition ,MS SQL Server 2008 Enterprise Edition, ETL, VB Script, T- SQL, MS Excel, MS Access, Crystal Reports 11, Oracle.
02/2010 to 03/2012
SQL Server DBAIron Mountain － Saint Paul , OR
- FedEx provides access to a growing market place through a network of supply chain, transportation, business and related information services.
- This project was for building new applications for the FEDEX APEC Tariff Database.
- The existing application called COSMOS had to be bolted with new applications to handle the new business requirements.
- Responsibilities: Designed and developed Packages, Stored procedures, Functions and Triggers, Views and complex SQL statements for applications.
- Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Rules and Defaults.
- Worked with development team to optimize schema and performance.
- Supported, advising, and assisting guiding and resolving problems for clients and end users.
- Created automated stored procedures for day end operations using SQL Server agent.
- Created jobs, alerts to run SSIS packages periodically.
- Designed DTS/SSIS package to export and import data from SQL Server to Access, text files and Excel files.
- Performed Server installation and configuration using SQL Server 2005/2008/2012.
- Worked under Active/passive Clustering environment.
- Created the automated processes for the activities such as database backup processes using the Integration Services.
- Setup backup restoration for the development and test boxes.
- Automated processes using SQL Server jobs.
- Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard.
- Created and monitored database maintenance plans for checking database integrity.
- Generated periodic reports based on statistical analysis of data using SQL Server Reporting Services (SSRS) according to the client requirements.
- Created Windows Logins and privileges to User Accounts/Groups and objects.
- Used DBCC commands to troubleshoot issues related to database consistency.
- Worked with Application Developers and Business Analysts to produce all required documentation.
- Environment: MS SQL Server 2005, MS Access, Windows Server 2003, HP-UX.
12/2008 to 01/2010
SQL Server DBABickford Senior Living － Salem , MI
- Target Corporation is one of the Leading consumer retail chain stores in the United States with over 1600 Stores across the nations, which serves basic household, pharmacy, foods, clothing and furniture needs of the consumers.
- They have got a mixed environment (SQL 2000, 2005 and 2008) with around 5600 SQL instances and around 20000 databases being used by all the applications.
- Responsibilities:.
- Installed MS SQL Server 2005 and 2008, updating with latest service packs and security patches.
- Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
01/2005
SQL
- Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers.
- Patch applications.
- Installed and administered two node cluster Active/passive on Microsoft Windows Server 2003 R2 Enterprise Edition SP2 on SAN environment Worked on SQL 2008 data Compression and saved 8.0 TB of disk space.
- Using Policy based management of sql 2008.
- Created and implemented some polices which reduced the incident volume to 30%.
- Worked extensive with database design team and development team for database design and implementation, used Erwin and Visio for database design and SQL 2008 for development.
- We implemented a live data mirroring without any witness for all store databases.
- Worked on enhanced security features Data encryption.
- Configured Audit at server level and database level using All Action Audit (AAA) in SQL server 2008.
- Performing Version control of all DDL schemas and stored procedures of development Application databases into Team foundation server 2008(TFS).
- Expert in implementing the DDL triggers, Created DDL triggers to prevent accidental table drop and also to restrict access for unauthorized user.
- Used DataPartitioning, File and file group backups in SQL Server 2005.
- Performing Backup/Restore to/from Tape (Legato server) and Disk.
- Created custom log-shipping to manage Disaster Recovery and Production Support restores Worked in Huge Replication Environment.
- Scheduling the DBCC commands to run daily, weekly basis.
- Developed automated tasks for daily, weekly and monthly database maintenance such as database backup, database integrity verification and indexing using Control-M agent and SQL Server Agent.
- Expert in Using DMV's, Performance dash board, Mirroring, database snapshot.
- Worked file and file group Backup/Restore.
- Involved in logical designing and physical designing the databases using ERWIN.
- Forward engineer tool used to generate DDL scripts from physical model.
- Performing DB Security, creating users, roles, and assigning permission to them.
- Used Online Indexing and online Restoring in SQL 2005 Used Performance Monitor/SQL Profiler to analyze long running /slow queries and tune the same to optimize application and system performance.
- Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
- Evaluated data storage considerations to store databases and transaction logs.
- Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
- Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
- Worked on different third party tools like FogLight, Spotlight and Redgate.
- Review T-SQL code to verify it meet standards for both performance and error handling according to DBA standards.
- Created Logon trigger to validate users connecting through different applications.
- Supporting 24/7 Production Environment.
- Environment: MS SQL Server 2008/2005, Enterprise Edition ,Business Intelligence Development Studio(BIDS) - SQL Server Integrated Services (SSIS) , DTS, SQL Agent, SQL Profiler, Database Tuning Advisor , Database Mail, Notification Services, T- SQL , Windows 2003 server.
Education
Bachelor's of Computer ApplicationsJ.N.T.UIndia
Skills
application development, Auditing, automate, Backup, banking, BASIC, bind, blueprint, Business Intelligence, C, C++, capacity planning, capital markets, case Management, Case Tools, Clustering, CPU, encryption, Crystal Reports, client, clients, Customer service, Version control, Data Analysis, Data Migration, data mining, DTS, DBA, Databases, Database, database design, designing, DHCP, Disaster Recovery, DML, documentation, DNS, e-commerce, engineer, ERWIN, ETL, XML, features, Financial, FTP, HP servers, HP-UX, HTML, Indexing, investments, Legato, Linux, Managing, market, materials, Memory, mentoring, Access, Microsoft Access, MS Access, Ms Access 2000, Microsoft Excel, MS Excel, Excel, Mail, MS Office 2000, MS Outlook 2000, SQL 2000, Windows 9, Microsoft Windows, Windows, 2000, NT, Migration, Enterprise, Network, OS, Operating System, optimization, Oracle, DB, packaging, Perl, Policies, processes, Programming, quality, QA, Quest, RAID, Read, reporting, requirement, requirements gathering, retail, Risk Management, routing, SAN, Scheduling, securities, Servers, scripts, Shell Scripting, shipping, SMTP, SNMP, specification, sql, MS SQL Server, SQL Server, statistical analysis, statistics, Strategy, supply chain, Tables, Tax, TCP/IP, T-SQL, T- SQL, TSQL, transportation, treasury, troubleshoot, Trouble shooting, troubleshooting, TSM, Unique, Upgrade, VB Script, VERITAS, Visio, Visual Studio, wealth management, Windows Server, written
DISCLAIMER
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
Resume Strength
- Completeness
- Formatting
- Word choice
- Strong summary
- Clear contact info
- Typos
Resume Overview
School Attended
- J.N.T.U
Job Titles Held:
- SQL Server Database Administrator
- SQL Server DBA
- Server DBA
Degrees
- Bachelor's of Computer Applications
Similar Resumes
