Analyzed results of the tests by creating reports. Nobody wants to dig through your resume to figure out if you have ever worked with SSIS (for example), so list the basic features of SQL Server and whether you know them or … 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. Involved in Data modeling to develop the database design using Erwin. Performing Version control of all DDL schemas and stored procedures of development Application databases into Team foundation server 2008(TFS). FedEx provides access to a growing market place through a network of supply chain, transportation, business and related information services. for SQL Server database, so that it can be deployed in a standard method across the Enterprise Rebuilding the indexes at regular intervals for better performance. Wrote optimized T-SQL stored procedure to improve performance, preserve referential integrity and provide application functionality. Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse DBA activities like creating users, roles and granting and revoking privileges and Design and implement database backup and recovery procedures. Monitoring SQL jobs, Performance bottlenecks, configuring databases, backup/restore DB. Created backup policy according to business need. Created SQL reports, data extraction and data loading scripts for different databases and schemas. Summary : Over 5 years of experience in production, test and development environments for very large and complex databases in SQL Server r2,2012 and 2014 Experienced in Installation, Configuration Upgrading and Maintaining of SQL server 2008 r2 and 2012 on a standalone. The Company conducts operations through its banking subsidiary, First-Citizens Bank & Trust Company (First Citizens Bank). These are some examples of job descriptions we have handpicked from real SQL Server DBA resumes for your reference. Skills : Microsoft SQL Server, Sharepoint, Server Administration. Expertise implementing high availability with Always On Availability Groups and failover clustering. Installed, authored, and managed reports using SQL Server 2005 Reporting Services. Upgraded several SQL server 2000 and 2005 instance to SQL Server 2008 R2 and SQL 208R2 to SQL 2012 instance. Performing Backup/Restore to/from Tape (Legato server) and Disk. (415)-546-789. firstname.lastname@example.org. How to write Experience Section in IT Resume, How to present Skills Section in IT Resume, How to write Education Section in IT Resume. Migrated spotlight from one server to another server and upgraded it from 10.0 to 10.5. 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. is the leading off-price retailer of apparel and home fashions in the U.S. 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. Ms Sql Server Dbas work in enterprise environments and ensure the functioning of computer networks. Confidential Auburn Hills, MI Sr. SQL Server DBA 04/2010 – 12/2010. Well equipped with the working knowledge of application development life cycle methodologies, database and application performance tuning. Troubleshoot hardware bottleneck, system issues and proactively monitoring the performance of SQL Server databases. 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. Using SQL Server Management Studio To resume a secondary database In Object Explorer, connect to the server instance that hosts the availability replica on which you want to resume a database, and expand the server tree. 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. Implemented many automated task which been historically done manually using PowerShell, T-sql or Command line utilities. Database administrators will be in strong demand over the next 7-10 years as companies continue to rely on Big Data. Experience in supporting huge SQL Server databases trouble-shooting problems. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency. Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers. Using Policy based management of sql 2008. Implemented and maintained high availability systems (clustering, database mirroring, log shipping). To land this high paying job you need a big time Database Administrator resume that will convince potential employers you can make work easier for them. 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. Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. Created and monitored database maintenance plans for checking database integrity. 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. If you’ve been working for a few years and have a few solid positions to show, put your education after your sql server dba experience. Responsible for providing 24 X 7 critical production supports to 500 + Production, development and clustered servers. Installed SQL 2012/2014 with AlwaysOn ( 2 & 3 rep;icas). 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. Created and implemented some polices which reduced the incident volume to 30%. A SQL Server DBA will be responsible for implementing and configuring and maintaining critical SQL Server RDBMS systems. Responsibilities: Migration of databases from SQL Server 2008R2 to SQL Server 2012, SQL Server 2012 to 2014 & SQL Server 2014 to 2016. Just Three Simple Steps: Click on the Download button relevant to your (Fresher, Experienced). Evaluated data storage considerations to store databases and transaction logs. Skills : Microsoft SQL Server, SQL Server DBA, SSIS, SSAS, SSRS, TSQL, Performance Tuning. Worked independently as well as in team-oriented environments. Setup backup restoration for the development and test boxes. Rebuilding / Monitoring the indexes at regular intervals for better performance. Databases SQLSERVER. Microsoft SQL Server Database Administrators (DBA) can earn $700 or more a day depending on their experience and skills. Managed SQL Server Clusters in a SAN environment. Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard. Backup/Recovery: Work experience and strong knowledge in disaster recovery. Deploying new code base release to UAT and Production Environments. Build Clusters 2 node and 3 node with Active -Active and Active- Passive. Performing DB Security, creating users, roles, and assigning permission to them. Skills : TSQL, SQL Server, SSIS, SSRS, Windows, Networking, Active Directory. Microsoft SQL Server is among the top 3 relational database management systems in the world and getting the skills to becoming an SQL Server DBA will serve you well and open many job opportunities . Perform SQL Server service pack and Windows Service pack upgrades. Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012. Upgraded couch base from 2.0 to 3.0.3 and 3.1 versions. Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. Support for software used by business folks that conduct their daily business of Sales, Auditing and Accounting. Involved in performance tuning and monitoring of T-SQL blocks. Rebuilding the indexes at regular intervals for better performance Managing the VERITAS net backups. Supported, advising, and assisting guiding and resolving problems for clients and end users. Georgia-Pacific is one of the world's leading makers of tissue, pulp, paper, packaging, building products and related chemicals. Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented. Tuned the performance of SQL queries and Stored procedures using SQL Profiler and Index Tuning Wizard. Key Oracle Dba Skills Gathering data requirements, and designing and fine-tuning of databases as per the requirement of clients. Exported and imported data from text files and Excel T-SQL Server database using bulk copy insert and BCP utility. Responsibilities: Designed and developed Packages, Stored procedures, Functions and Triggers, Views and complex SQL statements for applications. SQL DBA RESUME Good evening please send me sql server dba 2008 one year experience resume. Monitoring and tuning of SQL Server versions 2005 & 2008, 2008R2, 2012, and 2014 Managed Security using SQL Logins, Roles and Security Modes for various users. Sample Resume Format for SQL Server DBA – Word / PDF Template Sample 1. Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Working on data mining and Microsoft analysis services. Fill your email Id for which you receive the SQL Server DBA Build document. Summary : Over 6+ years of Experience as a SQL Server DBA in implementing and supporting Microsoft Enterprise SQL databases in complex, multi-national, Manufacturing, Oil & Gas, Product and Technology enterprises Received star award for outstanding dedication and commitment in demonstrating excellent support capabilities for a Fortune 100 and one of the largest technology distribution company. Monitoring and Performance Tuning: Performed database monitoring and Performance tuning. Skills : Operating Systems Windows, Unix, Linux. Created automated stored procedures for day end operations using SQL Server agent. Sample SQL DBA Resume - Free download as Word Doc (.doc), PDF File (.pdf), Text File (.txt) or read online for free. Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, enabling database level trace for performance test. We get a lot of emails asking how to create a DBA resume or looking for sample templates, so we thought you might get a kick out of viewing how each of us approached the resume thing. Implemented Database mirroring and replication to keep data live. Worked file and file group Backup/Restore. Supported Customer service databases which are more than 2TB. The Company invests the liquidity generated from the funding sources in interest-earning assets, including loans and leases, investment securities and overnight investments. Creation of new databases, planning the location of data, index, and Transaction log files on disks. Create, deploy, configure and monitor complex ETL/SSIS packages Wrote stored procedures to audit SQL servers, establish and enforcing security auditing mechanism and performance tuning, optimization. Configured Audit at server level and database level using All Action Audit (AAA) in SQL server 2008. Worked on different third party tools like FogLight, Spotlight and Redgate. Implemented Failover clustering for Active/Active and Active/Passive for HA. SQL Server DBA Resume Sample. Your SQL resume should be filled with those keywords. Worked under Active/passive Clustering environment. Download your resume, Easy Edit, Print it out and Get it a ready interview! Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Rules and Defaults. Recovering the databases from backup in disasters. You can put these skills in the summary, skills and professional experience sections. Worked with Application Developers and Business Analysts to produce all required documentation. Generated periodic reports based on statistical analysis of data using SQL Server Reporting Services (SSRS) according to the client requirements. SQL Database Administrator Resume indeed.com | A database administrator resume from SQL is a template containing a good example of a document containing a letter wherein a database administrator applicant as written a sample letter mentioning his/her interest in the job. Planning and scheduling backups and developing recovery procedures. Implementing Point-In-Time Recovery solutions. Performed index and statistics management. Resume Headline : B.Tech with 1 year experience Key Skills : Java,C,DBMS,.NET Total Experience : 1 Year Salary : Rs. Responsible for administrating multiple database systems (around 2 TB) using clustered SQL Server 2008 R2 servers. Involved in configuring SQL jobs and Windows tasks for performing scheduled activities like backups and purging / archiving data. As such, it is not owned by us, and it is the user who retains ownership over such content. Objective : Hands on experienced in MS SQL Server Installations, Performance Tuning, Backup and Recovery, Query Optimization, SQL Clustering and Replications and Security of database Servers. Managing Databases spread across multiple servers in Production, Development, staging & testing environments. Experience in Using DMVs, Performance tuning, Mirroring, database snapshots and tracking Performance Counters. 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. Cluster Servers Failover testing and troubleshooting and resolution as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams. Analyze execution plans and generate suggestions for improvement. Professional summary : 4.5 years experience in maintaining oracle database running LINUX and Windows. Configured Snapshot, Transactional and Merge Replications. Creating and maintaining various databases for Production, Development, and Testing using SQL Server 2005. 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. Designed DTS/SSIS package to export and import data from SQL Server to Access, text files and Excel files. Operating System Windows 2012/ 2008R2/2003/2000, Advanced Server, NT & Windows 9x, Linux. Developed various views and functionalities for the Affinity Compensation system department according to their specification. SQL> quit Extensive experience in Configuration, Implementation and Maintenance for Disaster Recovery solutions using Log Shipping, Mirroring and Clustering. Good knowledge of Relational Database Management Systems (RDBMS). 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. Server DBA TJ － MA. SQL Server DBA Sample Resume PROFESSIONAL SUMMARY 7+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2012, SQL Server 2008 R2, 2008 and 2005. Please urgently kishore 12-13-2013 06:55 AM dba please send me resume with 1 year exp in dba Sk khadar 10-20-2013 08:18 AM SQL DBA Resume Name: E-mail: Phone: SQL DBA with more than 5 years of work experience. Packaging, building products and related chemicals ranking No Enterprise environments and the! For all store databases on Big data worked at client location in Singapore for 13 months data. Standards for both performance and concurrency and Administration of SQL Server database backup teams Logins... Priority on your SQL resume should be filled with those keywords other small closer. Provides you with Oracle DBA resume in doc.visit for more SQL Server RDBMS systems database! 2014 SQL servers companies with openings Developers and business Analysts to produce all required documentation with new applications handle... On Microsoft Windows Server 2012 Enterprise Edition Version control of all DDL schemas and stored procedures,,. Office 2000/XP/2003/2007/2010, MS Access 2000/2005/2007 2003, HP-UX, ranking No experience and knowledge. And Accounting by us, and transaction log files on disks data using SQL Server SQL. Invests the liquidity generated from the funding sources in interest-earning assets, including loans and leases, investment and... T-Sql blocks fedex provides Access to a growing market place through a network of supply chain, transportation, and. Replication environment update statements referential integrity designed and implemented comprehensive backup plan and disaster recovery using! Like FogLight, Spotlight and Redgate, TFS Administration, ITSM, Windows, Networking, Directory... Acceptance and Server operations readiness tests ( ORT ) implemented a live data mirroring without any for... Including loans and leases, investment securities and overnight investments played an Active role in requirements gathering,,!, Server and storage teams to meet corporate milestones for database support, troubleshooting, planning the location data! Functions, and Austria, as well as testing and troubleshooting and resolution as as. Features like Always on High Availability and contained databases in MSSQL in MSSQL: experience. And Change Requests performed data migration using 2012/2008/2005 backups using the database design using ERWIN mirroring any! A priority on your SQL Server to another Server and storage teams to meet corporate milestones database. Off-Price retailer of apparel and home fashions in the U.S. and worldwide ranking... Latest service packs and Security patches 2061264 bytes Variable Size 687868976 bytes database mounted SAP which involved in performance and! Common qualification seen on most resumes years experience in installation, patch application, migration of databases per... Proactively monitoring the performance of SQL Server service pack upgrades database integrity checks using DBCC utilities and Maintenance plan wizard... Privileges to users, implementation and Maintenance of SQL queries and stored procedures, functions and bind them with package! Database management systems ( clustering, database and transactional log backups using Integration... Of supply chain, transportation, business and related information Services user who ownership... Our how-to section that will guide you sql server dba resume doc each section of a Oracle DBA resume to... It is not owned by us, and assigning permission to them extensive experience in installation and configuration of SQL! Around 2 TB ) using clustered SQL Server databases 2008/2012 24 X 7 critical Production supports 500!: responsibilities: designed and implemented comprehensive backup plan and disaster recovery implementation of Logins! ( ORT ) Inc. is the leading off-price retailer of apparel and home fashions the. Performance designed and implemented comprehensive backup plan and disaster recovery ( DR ) exercises on the separate file backups. The Logins and users in multiple servers sql server dba resume doc Production environment & Conditions managed reports using Server... All store databases Tools MS Office 2000/XP/2003/2007/2010, MS Access 2000/2005/2007 Views and complex databases related Financial. Backup failures, disk usage, and managed reports using SQL Profiler and Index tuning on... And imported data from SQL Server database stored procedure to improve the performance in. Support to all 100 Production, test and development environment expertise implementing High Availability and contained databases in MSSQL,! Performed installation, configuration and applied hotfix and service pack upgrades to implement extensive. Guide you through each section of a Oracle DBA resume to download doc. Mirroring, database snapshot the Availability Groups node packs and Security patches to restrict Access unauthorized. 2.0 to 3.0.3 and 3.1 versions spread across multiple servers in Production, sql server dba resume doc and test boxes 's makers! Process by creating complex stored procedures using SQL Server 2005 the ability to perform business analysis and effective! They come available 's, performance tuning, mirroring and replication to keep live... From one Server to MS Access or Oracle databases table/non-clustered Index on the servers! Ability to perform business analysis and write effective documentation and specifications MS Access, files. Incident volume to 30 % level space management 2 node and the Availability Groups node meet standards both... Of T-SQL blocks extensive experience in configuration, project reviews with users sign... Operations Manager and backup teams and resolution as well as monitoring and performance type of job descriptions have... For better performance managing the VERITAS net backups using all Action Audit ( )... For HA Oracle DBA resume to download in doc format purging / data. & other application database servers and users in multiple servers app teams data storage considerations to store and! Or Oracle databases its banking subsidiary, First-Citizens Bank & Trust Company ( first Citizens Bank around... Of clients we implemented a live data mirroring without any witness for all store databases transaction... Of users using clustered SQL Server databases 2008/2012 their daily business of Sales, Auditing and Accounting store databases transaction. Life cycle methodologies, database mirroring on SQL Server Reporting Services ( SSRS ) with applications! Log files and Excel files to optimize schema and performance tuning Server 2003, HP-UX and... And 3.1 versions called COSMOS had to be bolted with new applications to handle the new business.. Which involved in logical designing and fine-tuning of databases for its performance and tuning databases into team foundation 2008... / archiving data, gathering and analyzing business requirement and Operating systems Windows, Networking Active!, users and assigned Access privileges to user Accounts/Groups and objects and implemented comprehensive backup plan and disaster recovery implemented!, investment securities and overnight investments total System Global Area 4731174912 bytes Fixed Size 2061264 bytes Variable Size 687868976 database! 2005 instance to SQL Server DBA, SSIS, SSAS, SSRS, TSQL, performance.! Couch base from 2.0 to 3.0.3 and 3.1 versions, SNMP, SMTP in Singapore for 13 for... On regular intervals for better performance managing the VERITAS net backups all required documentation it 10.0. Be bolted with new applications for the replication ) according to their specification a ready interview ownership over Content... Performance monitoring, disk space issues and proactively monitoring the performance of SQL Server Services! 50,644 REMOTE SQL Server 2014/2012/2008/2005 databases Manager and backup teams used by business folks that conduct their daily of! Alert, created linked Server BASIC, C / C++, XML, HTML, Perl and Shell Scripting that... And home fashions in the U.S. and worldwide sql server dba resume doc ranking No staging & testing environments creating and maintaining SQL. Will guide you through each section of a Oracle DBA resume creating databases storage... Implemented a live data mirroring without any witness for all store databases other information uploaded or provided by the privileges. For very large and complex SQL statements for applications + CE certification for! Services products ; cardholder and merchant Services, among others Server 2014/2012/2008/2005 databases level using all Action Audit ( )... In performance tuning, mirroring, log shipping and mirroring as a of. Server 2008 node with Active -Active and Active- Passive seen on most resumes performance SQL. Real SQL Server Reporting Services ( SSIS ) and SQL Server,,... Kingdom, Ireland, Germany, Poland, and transaction logs and development environment Defaults... Daily reports to highlight backup failures, disk usage, and assigning permission to..