We provide IT Staff Augmentation Services!

Sql Server Dba Resume

4.00/5 (Submit Your Rating)

Oakland, CA

SUMMARY

  • 8+ years of experience as SQL Server Database Administrator/Developer/Designer.
  • Experience in installing, configuring, upgrading and maintaining servers of all versions of Microsoft SQL Server 2014/2012/2012 R 2/2008/2005.
  • Experience in SQL, T - SQL to create Table, Database, writing Query, Joining Tables, Store Procedure, Views
  • Experience in creating packages, Jobs, Sending Alerts using SQL Mail
  • Participated extensively in interaction wif users, team lead, DBA’s and technical manager to understand teh requirements of teh system.
  • Successfully upgraded from SQL 2008 to SQL 2012 wif side-by-side approach.
  • Wrote several SQL Scripts such as finding tables that has identify columns, finding tables that do not has primary key.
  • Expertise in Administration, Database Design, Performance Analysis, Complex Databases up to 2 Terabytes and implemented policies/procedures for ensuring teh security and integrity of teh databases.
  • Involved in design and enhancement development of applications for OLTP, OLAP, and DSS using dimension modelling wif Teradata and Oracle
  • Worked on new SQL server 2012 features like Contained Databases, Security Principals and AAG (Always on Availability Groups).
  • Experience in working wif Data and Backup compression, Performance Data Collection, Transparent Data Encryption which were new in 2008R2 version of SQL.
  • Optimizing Indexes for better performance using SQL Query Plans at Query Analyzer and Index Tuning wizards.
  • Expertise in Creating Linked Servers between different Servers in SQL environments and also between 32 and 64 bit servers to access database objects in remote locations.
  • Experience in working wif performance monitoring tools to monitor teh memory used, long running queries, consistency errors.
  • Efficient in working on Clustering, troubleshooting production issues and raising high availability.
  • Experience in working on SQL server Replication, Backup/Recovery, Disaster Recovery and Planning. Hands on experience wif Database Mirroring and Log Shipping.
  • Monitoring teh event logs and Server error logs using DBCC utilities for troubleshooting purposes.
  • Hands-on experience wif SQL Server 2008 new features like Change Data Capture (CDC), Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
  • Experience in using Performance Monitor/Profiler to resolve Dead Locks and long running queries.
  • Efficient in performing database consistency checks using DBCC Utilities and handling data corruption in user databases and identifying teh bottlenecks caused by complex queries using Activity Monitor, SQL Profiler and Performance Monitor.
  • Experience in verifying teh stored procedures created by developers, modifying and fine-tuning teh scripts for better performance using Database tuning advisor.
  • Installing and creating various types of reports using SSRS and packages using SSIS.
  • Expertise in writing and debugging Stored procedures, Triggers, Optimizing Code and Improving efficiency in databases including Re-indexing, Updating Statistics and performing other maintenance tasks.
  • Expertise in reading and understanding execution plan and fixing query to execute wif low cost using various operators depending on teh scenario.
  • Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Setting up SQL Server 2005, 2008 on MS VirtualPC, VMWare 5.5.
  • Intensively worked on Auditing for extracting data from Databases.
  • Experience in Import-Export, and Backups.
  • Good team player, strong interpersonal and communication skills combined wif self-motivation, initiative and teh ability to multitask

TECHNICAL SKILLS

Relational Databases: SQL Server 2014/2008R 2/2008/2005/2000 , MS Access.

Tools: and Packages: SQL Server Management studio, SSIS, SSRS, SSAS, DTS, Microsoft Visual Source Safe, SQL Query Editor

Languages: T-SQL, HTML/HTML 5,CSS 3, PL/SQL, XML,SQL

Operating Systems: Windows 2012/vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Web Technologies: HTML, XML, XSL, IIS (4.0/5.0/6/0)

Application Packages: MS Office, MS Outlook (Microsoft Office Suite), VMWare 5.5

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), Performance Point Server 2007

PROFESSIONAL EXPERIENCE

Confidential, Oakland, CA

SQL Server DBA

Responsibilities:

  • Installation and maintenance of SQL Server database systems. Maintaining teh database systems includes ensuring successful backups, resolving system issues, opening cases wif technical support to resolve issues, monitoring success and failure of automated jobs, monitoring system availabilities, updating system documentation, system and database recovery, etc.
  • Ensuring database systems are up-to date by reviewing, planning, testing, and installing database security patches and service packs.
  • Migration of application code and objects from development/test environments to production.
  • Working wif development teams to perform application and database tuning.
  • Defining and maintaining database and code standards and naming conventions for teh organization to ensure consistency in database and code development.
  • Migration of databases from SQL Server 20 /2014.
  • Set up, test, and maintain business continuity/disaster recovery infrastructure for databases and applications including documentation of Disaster Recovery Plan (DRP).
  • Created DTS and SSIS packages to Extract and Load data on SQL Server from diverse source (flat file, excel, xml and oracle)
  • Providing highly available database and application infrastructure according to business continuity requirements using SQL Clustering, Load-balancing, etc.
  • Setting up and monitoring transactional replication, Database mirroring on Production and QA servers.
  • Experienced in AWS EC2\RDS and SQL Azure.
  • Participated in daily SCRUM standups and agile process and iteration planning meetings.
  • Responsible for monitoring and troubleshooting Log Shipping.
  • Creating processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle (SDLC).
  • Extract Transform Load (ETL) deployment using SQL Server Integration Services (SSIS).
  • Creating new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQLin Development and Production environment.
  • New SQL Server 2008 R2 installations on VMware host servers and Hypervisor environments.
  • Migrating Standalone servers to VMware administration of all VM servers .
  • Exposure to cloud technologies like AWS and Microsoft Azure.
  • Tuning queries which are running slow using Profiler and Statistics by using different methods in terms of evaluating joins, indexes, updating statistics and code modifications.
  • Checking Database Health by using DBCC commands and DMVs.
  • Daily routine Database Administrator (DBA) tasks like handling user's permissions and space issues on production and semi-production Servers and handling maintenance Jobs.

Environment: MS SQL Server 2014/2012, Agile, Enterprise Edition, Oracle, SSIS,SSRS, TOAD, SQL Plus, OLAP, OLTP, T-SQL, Windows 2012 R2, MS Excel, MS Access, Unix, MS Visual Studio.Net, VB, XP,Crystal Reports XI.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

  • Installed SQL Server 2005/2008R2/2012 Servers on windows 2003/7/8/8.1 Platform.
  • Created jobs and monitored job history for maximum availability of data and to ensure consistency of teh databases.
  • Managed database backup and recovery, created database objects including tables, triggers, views, stored procedures, indexes, defaults and rule.
  • Optimized quarries which includes: performance tuning, query tuning, and index tuning using
  • Expert in creating a server, attaching volumes and configure teh server settings in AWS environment.
  • Worked in Virtual Machine (VM) and installed teh main versions of VM VMware VsphereClient.
  • DBCC commands, Wizards and SQL Profiler.
  • Migrated MS Access database into MS SQL Server. Migrated Oracle, MySQL, Sybase database into MS SQL Server 2008. hand experiences wif Amazon AWS, RDS(SQL Server and MySQL) and S3/EBS storages; Excellent knowledge wif SAN storage and Storage Capacity Planning.
  • Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
  • Granted database access privileges for different users and user groups.
  • Developed and deployed DTS, SSIS packages to transform data from Excel file to SQL Server database.
  • Creating complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and statements for applications by using T-SQL.
  • Involved in teh collection of statistics on important tables to has better plan from Teradata Optimizer.
  • Performed database consistency checks at regular intervals.
  • Monitored SQL Server activities through profiler.
  • Developed backup & restore scripts for SQL Server as needed.
  • Deployed database mirroring and Replication.
  • Deployed SSRS packages.
  • Strong SQL Server Developer Skills including writing Transact-SQL Queries, stored procedures, user defined functions, views and Good understanding of Normalization /De-normalization, Database design and modeling (logical and physical).
  • Monitored server space usage and generate reports.
  • Hands on experience as a MS-SQL/ Sybase database administrator and in full administrator cycle of a data warehouse, including requirements gathering, design, implementation & maintenance.
  • Experienced in AWS (Amazon Web Services) cloud data center.
  • Developed standards for SQL Server maintenance/updates.
  • Designed and implemented database maintenance plan.
  • Handled monthly database refresh in QA-Test environment for testing of new deployments and build.
  • Assisted in Batch processes using Fast Load, BTEQ, UNIX Shell and Teradata SQL to transfer cleanup and summarize data.
  • Evaluated data modelling, database administration, and database backup and recovery tools and made recommendations.
  • Configured Email notifications for Jobs, Schedules, batches, and alerts.
  • Maintained Disaster recovery strategies for teh database and fail-over methods.
  • Monitor SQL Server log files.

Environment: MS SQL Server 2012/2008 R 2/2008/2005/2000 , SSIS, SSRS, SSAS, Windows Server 2012 R2,2008 R2, 2008, 2003, Teradata, Sybase, VMware, Clustering, Mirroring, Log Shipping, Agile Methodologies, Replication.

Confidential, Oakbrook, IL

SQL Server DBA

Responsibilities:

  • Managed teh migration of SQL Server 2000 databases to SQL Server 2005/2008.
  • Implemented new SQL Server 2005 concepts like Data partitioning, Snapshot isolation.
  • Documented teh steps to be followed while upgrading teh SQL server 2000 to SQL server 2005.
  • Installed and Scheduled package execution in SSIS on multiple servers.
  • Worked on MS-SQL, Sybase and MySQL.
  • Extensively worked on SSIS for data manipulation and data extraction, ETL Load.
  • Created extensive reports using SSRS (Tabular, Matrix).
  • Installed, configured and maintained SQL Fail over clustering to provide server level high availability solution for different environments.
  • Knowledge of Amazon Web Services (AWS).
  • Configured and maintained Transactional, Snapshot and Merge Replication.
  • Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
  • Monitored & modified Performance using execution plans and Index tuning.
  • Worked on loading data from various data sources using MS Data Transformation Services (DTS).
  • Created AWS/EC2 SQL DBA instsances according to teh application requirement and configured.
  • Rebuild indexes at regular intervals for better performance.
  • Used log shipping for synchronization of databases.
  • Participated in teh designing and development of software using agile development practices.
  • Successfully completed database migration from Sybase to MS-SQL.
  • Worked in Active passive cluster environment.
  • Setup teh Transactional Replication for teh reporting purpose.
  • Prepared Documentation for teh Disaster Recovery plan.
  • Wrote and debugged Stored Procedures, (DDL) triggers, and functions as per client requirements.
  • Designed and implemented comprehensive Backup plan and disaster recovery.
  • Worked on call 24/7 Support on weekly basis.

Environment: SQL Server 2008/2005, Clustering, Agile, Mirroring,Log Shipping, HA, Sybase, DR, T-SQL, Oracle 10g, Windows 2003/2000/XP, SharePoint 2007, Scripting.

Confidential, Chattanooga, TN

SQL Server DBA

Responsibilities:

  • As a Production and development DBA managed several SQL Servers wif size ranging 20 GB to 1 Terabyte in a 24x7 Production environment.
  • Installed SQL Server 2008 and SQL Server 2005 on Windows 2003 and 2008 servers, applied service packs and security fixes for all servers.
  • Successfully Upgraded most of teh SQL Server from SQL 2000/2005 SQL Server 2008
  • Installed SQL Server 2008 and SQL Server 2005 on windows 2003 and 2008 servers on VIRTUAL Servers, applied service packs and security fixes for all servers.
  • Extensively used VMware for Virtual environment.
  • Configured and maintained Log shipping architecture to provide backup server solution.
  • Installed, configured, and maintained SQL Fail over clustering to provide server high availability solution for six different environments.
  • Developed and managed DTS Packages and scheduled jobs for periodic and nightly batch processes
  • Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
  • Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
  • Involved in securing teh SQL Server environment and setting up teh user permissions.
  • Created teh backup schedule for production, test and development servers.
  • Involved in restore operations to refresh teh data from production to test servers.

Environment: SQL Server 2008/2005, Windows server 2003/2008, DTS, T-SQL, SSIS and SSRS.

Confidential

Database Developer

Responsibilities:

  • Designed and implemented multiple systems using MS SQL Server 2000 and 2005
  • Managed teh migration of SQL Server 2000 databases to SQL Server 2005
  • Prepared estimates for Database, table size growth
  • Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules
  • Monitor connections, locks and performance of SQL server
  • Responsible for MS SQL Server 2000 configuration, tuning and provide 24x7 dedicated support to all Production, Development and Cluster Servers
  • Administered multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID level
  • Worked on physical storage SAN configuration on different RAID levels
  • Installed and configured Microsoft SQL 2 node Clustering (Active/Passive)
  • Creating Logins and Roles wif appropriate permissions
  • Involved in teh logical and physical data modelling using Erwin
  • Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers.
  • Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications
  • Experience working wif AGILE environment.
  • Developed and managed DTS Packages and scheduled jobs for periodic and nightly batch processes
  • Configured Log shipping of production servers and created teh DR servers
  • Assigned permissions to users and roles. Supported column level permission. Administered secure autanticated logins including both Windows and SQL Server Accounts
  • Expertise in Security Issues such as creation and granting permissions on various Objects.

Environment: MS SQL-Server 2000/2005, DTS, SQL Diagrams,Erwin, Windows 2003 Server, MS Access, MS Excel, HTML, C#

Confidential

Jr Developer / Administrator

Responsibilities:

  • Modified current database by adding tables and relationships to support online system.
  • Defined Constraints, Rules and Defaults.
  • Was Involved in Database Normalization
  • Created Views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
  • Created complex T-SQL Queries, Stored Procedures and Functions to support efficient data storage and manipulation.
  • Created SSIS packages to capture teh Incremental changes for teh Data ware house.
  • Built SSIS packages to process Cubes, Dimensions and partitions.
  • Participated in teh designing and development of software using agile development practices.
  • Has a very Good Experience wif all teh Control Flow and Data Flow tasks in SSIS.
  • Created and managed SQL Server login, database users and Roles.
  • Assisted in designing and creating website for teh system using ASP, HTML, and CSS.
  • Scheduled jobs for backup, and created alerts for error reporting.
  • Data migration (import & export - BCP) from Text to SQL Server.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Participated in different testing and debugging for teh system.
  • Documented all processes involved in maintaining teh database for future reference.
  • Develop various reports using Reporting Service (SSRS) as required.
  • Developed Charts and Tabular reports in Excel and Web format using SSRS.

Environment: SQL Server DTS, ER Diagrams, SQL Server Integration Services, Cluster, Windows 2003 Server, MS Access, ASP, MS Reporting Services, HTML

We'd love your feedback!