Sql Server Dba Resume
Dallas, TexaS
VAMSHIPROFESSIONAL SUMMARY:
- Detail oriented IT professional with 8+ years of proven expertise in supporting and optimizing performance of SQL Server 2014/2012/2008R2/2008/2005/2000 as Database Administrator and Developer.
- Expertise in installing MS SQL Server 2000, 2005 and 2008.
- Migrated MS SQL server 2000 to 2005/2008, SQL Server 2012/2014 and applied Patches, hot fixes, and Service packs to update different versions of MS SQL server.
- Worked on32 bit and 64 bitSQL Server andMSCSConfigurations.
- Administered multipleSQL InstancesonCluster environmentfor Server Consolidation projects built onSANusingRAIDlevels
- Proficient inconfiguring, implementing, and monitoringdifferent types ofHigh Availability & disaster recovery scenarios like Replication, log shipping,Database mirroring and clustering.
- Experience in Server administration in various environments - Window 2000, 2003, 2008 and 2012 with Active Directory Services (AD, DNS, and DHCP).
- Expert in Performance tuning by index defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning
- Expertise in configuring, monitoring, tuning, documenting and troubleshooting at server level, database level and package level.
- Exquisite skills in database Backup, Restore, Recovery, Linked Servers, Database Maintenance Planning.
- Experience in implementation of SQL Server new features like AlwaysOn Availability Groups, Contained Databases, Change data capture (CDC), online index rebuilds, Central management server, Transparent Data Encryption (TDE), User-Defined server roles.
- Hands on experience in creating Maintenance plans, scheduling SQL Server Jobs, Automatic administrative task and Configuring Database Mail.
- Expertise in writing good standard T-SQL queries, stored procedures, Indexed views, User Defined Functions (UDL), Triggers Distributed Queries and Common Table Expressions.
- Strong in planning and implementingDatabase Securityby creating users, Roles, and assigning permissions to them.
- Explicitly used third party tools like Lite Speed, Fog light and Red gate.
- Well experience in Query Optimization, Client/Server connectivity, Performance Tuning, Database Consistency Checks using DBCC utilities, DMV’s.
- Well experienced in dealing with Normalization technique for OLTP and OLAP systems for creating Indexes, Constraints and Table.
- Used Joins and Sub Queries for the simplification of complex queries including more TEMPthan one tables and defined relationship between multiple tables based on Primary key and Foreign Key constraints.
- Experience in Data ETL (Extraction, Transformation and Loading) using SSIS (SQL Server Integration Services) in SQL Server 2012 with Import/Export Data, Bulk Insert.
- Good understanding of Normalization /De-normalization, Normal Form and database design methodology.
- Experience in Software Development Life Cycle (SDLC), Analyzing and Designing systems using Structured Methodologies (ERD) along with extensive noledge of Relational Database Management Systems with in-depth of T-SQL.
- Worked on configuring SQL Server with minimum privileged access.
- Hands on experience on various SQL Server tools and IDE to work with database and BI based applications like SQL Server Management Studio, Profiler, Business Intelligence Development Studio and Visual Studio.
- Good experience in SQL Server Business Intelligence Development Studio to create SSRS reports, SSIS packages and SSAS with OLAP.
- Good experience in resolving SQL Server blocking and Dead Lock Issues.
- Excellent Problem Solving Skills, Communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.
- Good working noledge in .Net Framework 2.0/3.0/3.5, C#, ASP.Net, VB.Net
TECHNICAL SKILLS:
Languages: T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, C# ASP. NET, DHTML, Java Script.
Operating Systems: Windows 95/2000/2003/2008/XP/VISTA/7, Sun Solaris 9, LINUX, UNIX, Red Hat, VM ware ESX servers.
Data Bases: MS SQL Server 2014/2012/2008R2/2008/2005/2000, Oracle9i/ 10g/11g, MYSQL, MS Access.
ETL & Reporting Tools: DTS, SSIS, SSRS, SSAS, Crystal Reports.
DB Utilities: SQL Server Management Utility, Query Analyzer.
Application Software: Visual Studio 2005/2008, Visual Source Safe, TFS, MS Office Suite
Data Base Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, Index Tuning Wizard, BCP, DTS, Import/Export Wizard, SQL Server Management Studio, SSIS, SSRS, SSAS, Visual Studio, BIMS, MS Dynamics AX.
Data Modeling Tools: Erwin, Red gate, Lite speed, Idera.
PROFESSIONAL EXPERIENCE
Confidential - Dallas, Texas
SQL SERVER DBA
Responsibilities:
- Installed MS SQL Server 2005, 2008 R2, 2012, updating with latest service packs and security patches.
- Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
- 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.
- Implemented the Data Partitioning for large tables in SQL Server 2008.
- Created custom log-shipping to manage Disaster Recovery and Production Support restores
- 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.
- Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
- Worked file and file group Backup/Restore.
- Maintained the database consistency with DBCC at regular intervals
- Implemented SQL Server 2012 new features like Always on Availability Groups for high availability of multiple databases in place of database mirroring.
- Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
- Involved in logical designing and physical designing the databases using ERWIN.
- Performing DB Security, creating users, roles, and assigning permission to them.
- Worked on SQL server 2008 T-SQL new features such as MERGE statement and Date time offset Data type.
- Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
- Extensively worked on SQL Server Integration Services (SSIS).
- Implemented new topics like CLR integration on Development server.
- Solving the Bugs Reflected by the Testing team
- Used Performance Monitor/SQL Profiler to analyze long running /slow queries and tune the same to optimize application and system performance.
- 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.
- Worked on different third party tools like FogLight, Spotlight and Red gate.
- 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
Environment: MS SQL Server 2008R2/2012/2014, T-SQL, BCP, SQL Profiler, Windows 2003/2008 Server, MS Access, Windows XP/2008/2003/2000, Visual Basic 6.0, VSS, ERWIN, XML, SQL Profiler.
Confidential, Minneapolis MN
SQL Server DBA
Responsibilities:
- Worked on Client/Server tools like SQL Server Management studio (2005), SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server.
- Migrated SQL server 2000 databases into SQL server 2005 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
- Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers.
- Migrated DTS packages into SSIS packages.
- Handled up to 2 TB Size databases with clustered and standalone environment
- Configured Transactional replication on migrated server.
- Wrote the packages using SSIS in SQL2005.
- Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
- Setup and configured AlwaysOn Availability Groups for DR and Reporting on SQL server 2012.
- Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
- Integrated SQL traces with Performance log to have better graphical analysis to find system bottlenecks.
- Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
- Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
- Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
- Used DTS packages to move logins and jobs from one server to another server.
- Used log shipping for synchronization of database.
- Good experience in data modeling and metadata services.
- Monitoring SQL server performance using profiler to find performance and deadlocks.
- Created Stored Procedures, Triggers, Views and Functions for the Application.
- Extensive testing on the Performance of the Stored Procedures.
Environment: TSQL,MS SQL SERVER 2000/2005/2008/2012,SSRS, QUERY ANALYSER, VISUALSTUDIO 2005, VB.NET,C#,WINOWS SERVER 2008,IIS,SSAS.
Confidential, Albertville, AL
SQL DBA
Responsibilities:
- Installation of SQL Server 2008/2005, service packs, hot fixes, security patches, lite speed.
- Implemented and maintained Database mirroring as a Disaster Recovery Solution
- Worked on the migration of SQL Server 2000 to SQL Server 2005
- Used Data Partitioning, Snapshot Isolation in SQL Server 2005
- Update statistics, database integrity check and Backup operations
- Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages
- Designed and implemented comprehensive Backup plan and disaster recovery model
- Worked extensively in Query Analyzer and Profiler for tuning queries using variable for characteristics and query costs
- Created and modified Stored Procedures and Functions to generate reports
- Used log shipping for synchronization of database
- Implemented AWE /PAE switches for SQL Server to grab more TEMPthan 4 GB RAM
- Practical experience in managing the internal and external MS SQL database security.
- Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
- Responsible for creating user groups and assigning permissions.
- Optimized stored procedures and indexed query using Index Tuning Wizard.
- Worked on database Design and Architecture based on business user requirements and performed Normalization (Third Normal Form) and De-Normalization.
- Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
- Setup and maintained Linked Servers.
- Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
- Involved in validating credit card number using regular expressions.
- Provided back-end support for functional testing and performance testing.
Environment: MS SQL Server 2000/2005 ETL, DTS, SSIS, Windows 2003 Server, ERWIN, MS Access, Toad, Excel.
Confidential
SQL DBA
Responsibilities:
- Responsible for developing automation of maintenance jobs, tuning SQL Server locks and indexes configurations, administering SQL Server security.
- Carried out Reporting using Crystal Reports on SQL Server 2005 databases
- Created Logins for the users, granted database privileges as per the request and security guidelines of the organization.
- Experience in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
- SSRS Administration including configuration, security management, trouble shooting and monitoring.
- Experienced in using Dimension Usage, Aggregations, Calculation and Perspective on a Cube.
- Developed, implemented, and tested backup and recovery plans
- Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.
- Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
- Experienced with SQL Server 2005 profiler, SQL Server management studio and Business intelligent development studio.
- Worked with the system administrators, network, backup, and storage engineers to migrate all databases, procedures, and reports into a central data warehouse as a continuous effort
- Implementing Disaster Recovery for minimal downtime using backups, restore, and replication.
- Involved in restore operations to refresh the data from production to test servers.
- Support a production system setup comprising of Sybase ASE servers, Replication Servers
- Thorough analysis and testing of database objects & T-SQL statements before deployment to the production server.
- Performed compression of historic data for VLDB and compressed backups to save disk space.
- Upgraded SSIS Packages from SQL Server 2005 to SSIS packages in SQL Server 2008 database.
- Experienced with creating database maintenance plans for efficient operations.
- Involved in upgrading from SQL Server 2000 to SQL Servers 2005.
Environment: SQL Server 2000/2005, T-SQL, SSRS, SSAS, ASP.NET, Crystal Reports 10.0.
Confidential
SQL Server DBA/Developer
Responsibilities:
- Created Database tables with constraints and relationships between multiple tables.
- Created Views, User Defined Functions and Triggers.
- Extensively used the VB coding and HTML usage.
- Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
- Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
- Responsible for creating Stored Procedures and Scheduled to run them by creating SQL Agent Jobs.
- Performed various data transfers between various servers using BCP and DTS.
- Supported team in resolving in DTS and T-SQL related issues.
- Involved in performance tuning and query optimization.
- Performed Database and Performance testing for the database objects.
- Created backup/restore and disaster recovery plans for production servers.
- Backing and Restoring of Databases on Scheduled basis.
- Involved in documenting the entire technical process.
- Supported technical teams involved with MS SQL issues and operations.
- Involved in the maintenance of the database.
Environment: SQL Server 2000, Oracle 8i, VB 6.0, Windows 2000, Erwin, IIS 5.0, Crystal Reports 9.0 and Microsoft Reporting services 2.0.