We provide IT Staff Augmentation Services!

Sql Sever Dba Resume

Overland Park, KS

Summary

  • Over 7+ years of IT experience as SQL Server Database Administrator.
  • Experienced in Security and Support of MS SQL Server 2012, 2008, 2008r2, 2005 and 2000 in Production, Testing, Development Environments.
  • Performed Normalization and built Referential Integrity Constraints.
  • Extensive knowledge and experience in developing Stored Procedures, Views, Triggers, cursors and Complex Queries on SQL Server 2000/2005/2008/2008r2/2012.
  • Conducted Database Backup and Restore, Attach and Detach, Recovery and Disaster Recovery procedures.
  • Involved exclusively in Disaster Recovery plans like Backup/Restore, Database Mirroring, Log Shipping
  • Experience in Maintaining SQL Server Security, creation of logins and users, configuring permissions and assigning roles to users.
  • Created and Maintained Alerts, Notifications, Jobs, Job Steps and Schedules for system errors, insufficient resources, fatal database errors, hardware errors, security.
  • Experience in data migration from Access/Excel Sheets using import/export and BCP utilities.
  • Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
  • Extensively Monitored Performance with multiple tools like Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard, and Database Tuning Wizard to achieve better performance, Resolve Dead Locks/Long Running Queries, accessibility and efficiency.
  • Experience in Troubleshooting all database related issues.
  • In Depth knowledge in analyzing Query Plans, Extended Stored Procedures and improving efficiency by re-indexing, update statistics, Recompiling stored procedures, Troubleshooting Dead Locks and capture data using SQL Profiler, Performance Monitor and DBCC Commands.
  • Worked closely with management, applications development Team, and users on database solutions to resolve business problems.
  • Experience on working with production Servers and 24 x 7 On-Call environments.
  • Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
  • Actively involved in setting up Active-Active/Active-Paasive clustering in production and Testing Environments and also troubleshooted issues with the same.Applied Hotfixes and Service Packs in clustering environments.
  • Conducted Database mirroring in High Performance and High Availability mode and troubleshooted issues with the same.

Technical Skills

Databases :MS-SQL Server 2005/2008/2008r2/2012, MS Access 2003.
Languages :C, C+, VB Script, Java Script, HTML, XML
SQL Server Tools :Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyser, Export & Import,Precise i3 for SQL Server.
Operating systems :Windows 2008\\2003
Software Packages :MS Office 97/2000/XP,2003,2007, MS Outlook 2003,2007,Visio

Education:

Bachelors in Computer Science

Certification:

Microsoft SQL Server 2008 Implementation and Maintenance

Experience

Confidential, Overland Park,KS June 2011- Till Date

SQL Sever DBA

Worked for Confidential which is an online marketplace, which provides services for buyers and sellers for sports, concerts and other live enterntainment events throughout United States.

Responsibilities:

  • Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1 Terabytes.
  • Created and maintained various databases for Production, Development and Testing environments using SQL Server 2008r2, 2005.
  • Actively involved in setting up Active-Active/Active-Paasive clustering in production and Testing Environments and also troubleshooted issues with the same.Applied Hotfixes and Service Packs in clustering environments.
  • Conducted Database mirroring in High Performance and High Availability mode and trouble shooted issues with witness servers.
  • Involved in migration of SQL 2005 TO SQL 2008r2
  • Performed daily backups and developed recovery procedures
  • Migrated the data across different databases and different servers using SSIS,BCP and Import/export tools.
  • Experienced in performance tuning using windows performance monitor and SQL profiler of SQL server.Used SQL Server errorlogs and event viewer to troubleshoot issues.
  • Implemented and configured database monitoring tools and focused on providing a high availability database.
  • Troubleshooted issues with log file full and database size increasing beyond threshold.
  • Creation of new database, planning the location of data, index, and transaction log files on the disks
  • Involved in Capacity Planning, data modeling and Logical/Physical database Design
  • Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources
  • Provided support to the application developers on the application databases
  • Handled the database components of application releases
  • Handled 24/7 production issues .
  • Used i3 performance tool and Hydra software to monitor Databases and Servers.
  • Performed Stress tests and monitored tests in regards to CPU,network bottlenecks and latencies,blocking and long running queries,page faults.
  • Worked closely with application developers to help determine any issues with sql script,sql server performance,normalization,security and database/server connectivity and database schemas.
  • Developed and deployed stored procedures,created triggers and audits.
  • Developed Jobs for maintenance in terms of updating statistics,rebuilding indexes,scheduled full/diff/log backups, refreshing database environments periodically or on demand.Also set up notifications for failure of jobs etc.
  • Actively participated in determing the database schema,database schema changes,implementation plan for database schema releases in coordination with developers and data modelers in adherence with Organization policies.
  • Proactively monitored ,determined and solved issues at sql/database/server levels.

Environment:Windows 2003,MS-SQL Server 2008r2/2005,.NET Framework, Visual Studio,i3 performnace tool.

Confidential, Dallas, TX 2010 March -2011 May MS SQL Server DBA
Confidential is the largest health insurance provider in United States. Confidential provides competitive rates and plans through the most sophisticated application called Business Acquisition. Confidential has SQL servers located in different stats of United states to support the automated process and generate rates which requires daily data feeds, rate changes and billing cycles.

Responsibilities:

  • Installed SQL Server 2008r2 on Standalone and Clustered Environments.
  • Upgraded /Migrated of SQL Server from version 2005 to 2008r2.
  • Installed Microsoft Service Packs/Patches/Hotfixes.
  • Configured and administered SQL Clusters (Active/Passive, Active/Active), Database Mirroring, Replication and Log shipping.
  • Conducted Backup and Restore of Databases and Schedule Maintenance plans to perform regular Backups.
  • Performed Attach/ Detach, BCP, Import & Exports and Copy Database Wizard.
  • Created Tables, Stored Procedures, Views, Triggers, Cursors and Complex Queries on SQL Server 2005/2008.
  • Query Optimization and Performance tuning for optimization like maintaining/creating indexes, Create/Update Statistics, Tuning SQL queries.
  • Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
  • Troubleshooted Memory Errors/Query Processing and usage of Memory and resolving errors pertaining to insufficient Memory.
  • Collected data using PSSDIAG, MPS Reports, Profiler to analyze and tune for better optimization.
  • Troubleshooted and resolved Blocking, Deadlocks and Long Running Queries.
  • Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
  • Developed, deployed and monitored SSIS Packages including upgrade from DTS to SSIS.
  • Created Reports using SSRS 2005/2008.
  • Utilized DMV’s, Data partitioning and Performance Dashboards reports with SQL Server2005.
  • Configured Snapshot, Transactional and Merge Replication of SQL Server databases and Troubleshooted Replication Problems.
  • Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
  • Created various Jobs, scheduled & ran jobs and troubleshooted the failed jobs.
  • Provide 24X7 support for the Critical issues like Server Failures and Database inconsistencies like Database Log File full, Suspect, Offline, Missing log files etc.

Environment: Windows 2003, MS SQL Server 2005/2008/2008r2, T-SQL, Visual Studio.Net 2003, Crystal Reports, LITESPEED, MS Access, DTS, BCP, SSIS, SSAS, SQL Profiler.

Confidential, Cincinnati, OH 2009 August- 2010 March
SQL Server DBA
Confidential, a bank corporation, engages in commercial and retail banking, electronic payment processing services, and investment advisory services in the United States. The bank provides a range of financial products and services to the retail, commercial, financial, education and medical sectors.

Responsibilities:

  • Installed and configured Windows NT/2008, SQL Server 2008.
  • Responsible for the systems study, analysis, systems design and database design, ER modelling, Dimensional Modelling, coding, testing, implementation and documentation.
  • Database creation and location of database file.
  • Upgraded SQL Servers database from version 2005 to 2008.
  • Managed SQL Server users/ NT users.
  • Conducted Replication of SQL Server databases.
  • Setup log shipping of production databases to maintain standby copy of production databases and for offloading query processing from the production server.
  • Restored the database on production server or development servers as per requirement.
  • Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
  • Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
  • Tested the application for deployment, functional behavior.
  • Updated Microsoft patches/Service packs on SQL Server 2005 and Windows NT.
  • Installation, configuration and supporting of IIS servers.
  • Involved in database designing using Normalization.
  • Developed DTS (Data Transformation Services) Packages Created Transact SQL scripts based on functional requirements as defined by design documents. The package does data transformation between Ms Access and Ms SQL Server 2005.
  • Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
  • Tuned SQL statements and Stored Procedures.
  • Extensively used DTS to load data from different data sources.
  • Helped application teams in query analyzing and its optimization. Coordinated with users for downtime and maintained the system running 24X7.
  • SQL server database backups/restoration and recovery of NT server/SQL Servers
  • Implementation of Active directory, group policy in windows 2008.
  • Look after virus issue and the virus patches applied to the servers.

Environment: MS SQL Server 2005 and 2008, T-SQL, DTS, Replication, MS Access, Windows 2008 server, Windows NT

Confidential, Los Angeles, CA 2008 Oct -2009 Aug
SQL Server DBA / SSIS Developer

Responsibilities:

  • Installed, Configured and Maintained SQL Server 2008 in multiple database environments, namely development, QA and Staging. Applied Service Packs & assisted Infrastructure Engineering team to install and configure SQL Server 2008 in a Clustered (Failover) Environment.
  • Provided Primary support DBA to various business critical SQL Server applications hosted over 300 servers (SQL 2008/2005).
  • Upgraded to SQL Server 2008 and guiding the development and application team to fully utilize SQL Server 2008 enhancements.
  • Created Merge Replication between different data centers. Resolved issues; designed and managed database security.
  • Monitored Databases for Dead Lock, Capturing long running SQL queries, used HINTS for fine-tuning SQL statements that better result in efficient SQL statements processing.
  • Used SQL Server Profiler to monitor the server by running traces on various events like User connections, stored procedure execution time etc.
  • Evaluated the Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues.
  • Setup and configured SQL Server for other business functions. Index Data Management to determine Defragmentation level; whether to Update Statistics or Rebuild Indexes.
  • Scripted the Database Consistency Checks (DBCC), scheduled the scripts to run daily and weekly basis.
  • Monitored via SQL modules like Idera Diagnostic manager, Tivoli etc for performance issues like excessive locking, table scans, deadlocks, fragmentation and other bottlenecks.
  • Responsible for SQL Server tuning and performance evaluation and optimization and utilized new features like SQL Dynamic Management Views for the same. Also responsible for Query Performance tuning and Optimization.
  • Used Visual Source Safe 2008 for version control. Created various Stored Procedures to enforce the business logic.
  • Created Database Diagram using Erwin Data Modeler, Data Dictionary Document, Database Installation and Configuration Document and Merge Replication Setup Document.
  • Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
  • Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
  • Extracted data from various sources like SQL Server 2005/2008, Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
  • Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
  • The SSIS packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.
  • Responsible for identifying and defining Data Source and Data Source views mappings for ETL.
  • Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
  • Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
  • Provided primary pager support on rotation basis.

Environment: MS SQL Server 2005/2008, T-SQL, DTS, Replication, MS Access, Windows 2008 server, Windows NT 4.0,SSIS,

Confidential, Houston, TX2007 September-2008 SeptemberSQL Server Administrator
Confidential is one of the world\'s leading independent oil and gas exploration and production companies. Confidential\'s operations are focused primarily in the United States and Canada; however, the company also explores for and produces oil and natural gas in select international areas. Devon Energy also own natural gas pipelines and treatment facilities in many of their producing areas, making them one of North America\'s larger processors of natural gas liquids.

Responsibilities:

  • Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and upgrading of SQL Servers.
  • Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs.
  • Responsible to provide 24x7 DBA & Production support for over 180 SQL Server databases in Production on Clustered Servers.
  • Setup and troubleshoot for Active/Passive Clustering in SQL Server 2005.
  • Involved in assisting SQL Server prime customers with Configuration, Administration, Implementation and Trouble-shooting for Business work flow with Log Shipping mechanism.
  • Configured DR solution with Transaction Replication from Distribution Server with multiple Updatable subscriptions.
  • Designed and developed ETL processes using SSIS to receive customer files from data warehouses and load them into transaction processing systems.
  • Involved in Installation, Configuration and Deployment of SSRS Reports using different topologies
  • Used Process Explorer for maintenance of stuck process, and to release the handles on files
  • Performed Database Refresh tasks from production to Development and Staging Servers
  • Performed Scheduled backups and restore operations with LiteSpeed 4.5
  • Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.
  • Performed Database consistency checks with DBCC , Defrag, Index tuning and monitored error logs
  • Provided On-Call support to Mission critical Environments and expertise with Disaster Recovery mechanisms.
  • Maintained two different databases: Read-only reporting database and Disaster recovery database.
  • Performed security tasks like Grant, Revoke permissions for security tasks.
  • Involved in auditing and performing the transactions to database and resolve the issues with Performance Monitor and SQL Profiler and Used NetMon for Monitoring and Performing Network throughput issues.
  • Resolved issues for mission critical high usage of system CPU, Disk, Deadlocks and Transaction per/sec, Memory.
  • Involved in developing Stored Procedures, Triggers, and SQL scripts for performing automation tasks.

Environment:SQL Server 2005, MS-Access, .Net Framework2.0, VSS, HTML, Primavera Risk Analysis, Primavera SureTrak, Windows-NT, Windows 2003 Server, LiteSpeed, Erwin data modeler.

Confidential 2006 Feb-Aug 2007
SQL DBA/Developer
Immigration Control System project: This system is for automating passenger immigration and customs clearance at the four international airports in India. The online system maintained all departing/arriving passenger information, and 1-year online data for various queries and reports.

Responsibilities:

  • Performed regular Database Maintenance task, Checking the disk Defrag procedures in Development environment
  • Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
  • Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server2005.
  • Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers
  • Used Index Tuning Advisor for Database performance for proper indexes.
  • Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005
  • Implementing Load balancing Replication across the Databases.
  • Performed Database Refresh tasks from production to Development and Staging Servers
  • Involved in Performance Tuning of the SQL Server for Web based Production and Development environments
  • Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration with BCP Utilities
  • Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored SQL Server error logs
  • Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.

Environment: SQL Server 2000, Windows NT/2003, VERITAS Net Backup and Crystal Reports.

Confidential 2005 May-Jan 2006
SQL DBA/Developer
Immigration Control System project: This system is for automating passenger immigration and customs clearance at the four international airports in India. The online system maintained all departing/arriving passenger information, and 1-year online data for various queries and reports.

Responsibilities:

  • Performed regular Database Maintenance task, Checking the disk Defrag procedures in Development environment
  • Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
  • Assisted in Setup and troubleshooting Active/Passive Clustering for SQL Server2005.
  • Configured Disaster Recovery solution using Log Shipping. Setup for Snapshot and Transactional Replication between Servers, troubleshoot and monitor Publishers, Distributors, and Subscribers
  • Used Index Tuning Advisor for Database performance for proper indexes.
  • Involved in upgrading of existing Servers from SQL Server 2000 to SQL Server 2005
  • Implementing Load balancing Replication across the Databases.
  • Performed Database Refresh tasks from production to Development and Staging Servers
  • Involved in Performance Tuning of the SQL Server for Web based Production and Development environments
  • Designed and developed ETL processes using SSIS to receive customer files from data warehouses and load them into transaction processing systems.
  • Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Performed Uploading of bulk data migration with BCP Utilities
  • Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored SQL Server error logs
  • Resolved the issue of mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory involved in performance monitoring of Memory, Processor, Disk I/O.

Environment: SQL Server 2000/2005 Windows NT/2003, VERITAS Net Backup and Crystal Reports.

Hire Now