We provide IT Staff Augmentation Services!

Database Administrator Resume

Arlington, VA

OBJECTIVE

Microsoft Certified, 6 years of SQL Server DBA experience and US citizen looking for a SQL server Database Administrator Position. I have very strong experience installation, Configuration, Automatic maintenance, Performance tuning, Security, Data Transformation in MS SQL server environment.

KEY COMPETENCE

Database: SQL Server 2000, 2005, 2008, 2008 R2, 2012, Microsoft Access,

Operating Systems: Windows Server 2000/2003/2003 R2/2008/2008 R2

Language: Transact - SQL, SQL, ASP, ASP.net, VB/JavaScript, HTML

Hardware: SAN, RAID

Tools: Query Analyzer,Idera DBA Suite, Idera (SQL Compliance Manager), SQL Doctor, Toad Data Modeller, Microsoft Office Word, Excel, PowerPoint, Visio, Visual Studio

Web Servers: IIS 5.0, 6.0, 6.5, 7.0, 7.5

Web Application : Share point enterprise

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential, Arlington, VA

  • Installed, Configured & Maintained MS SQL Server 2005, 2008 and 2008R2 on standalone and Clustered Servers
  • Tested and applied latest Service Packs, patches and hot fixes
  • Migrates database from MySQL to MS SQL Server
  • Migrates Databased from three data center to one datacenter.
  • Upgraded database including logins, stored procedures from SQL server version 2005 to 2008R2 version.
  • Wrote and modified T-SQL Scripts for reporting.
  • Implement periodic security controls. Manage database users and their appropriate level of permissions.
  • Properly maintained data dictionary by comparing data, objects and schema with visual studio.
  • Developed and completed Data Dictionary for the project.
  • Plan, prepare, implement, and test backup and recovery procedures for production, Test, and Development environment.
  • Implemented a recovery plan for a point in time failure.
  • Automated daily database refreshes from production to staging and on-demand refreshes database from production to test environments involving SQL different versions of SQL server.
  • Ensure systems availability and manage critical incidents; troubleshoot issues to full resolution and provide detailed updates to management.
  • Implement periodic security controls. Manage database users and their appropriate level of permissions.
  • Implement and maintain multiple types of replication. Investigate and resolve issues associated with replication timeouts, errors, and latency.
  • Create and modify database structure using Data Definition Language (DDL) statements to create tables and appropriate indices for optimal data access, as well as database objects such as store procedures, functions, views, and triggers.
  • Calculate and trend database sizes and plan appropriately for growth. Communicate plans to server administrators.
  • Monitored and scheduled automation jobs using SQL Server Agent and Maintenance Plan
  • Configured Database mail, Operator, Notification, alert to send and receive database related information which can effected the performance.
  • Monitor databases for optimal performance and find out performance problem in different way using SQL Profiler, Wait stats, DMV (Dynamic Management View), DMF (Dynamic Management Function), Activity monitor, Extended Events, Error log, Windows Performance Monitor.
  • Identify and takes step to resolve poorly-performing queries that require tuning and/or optimization.
  • Used SQL execution plan to find the cost and running process for TSQL code and Optimize the code
  • Developed script to find out missing Index, unused Index, Duplicate Index, and Partial Duplicate Index and create appropriate Index to optimized slow running query.
  • Developed script to find out fragmentation level and developed script to rebuild or reorganized Index which affectedly improves performance.
  • Experienced in Online Indexing using SQL query and SSMS Maintenance plan.
  • Troubleshoot day-to-day problems encountered on production as well as development, test database environments.
  • Run various DBCC commands to Checks Database Consistency.
  • Review and create Extraction, Transformation, and Loading (ETL) processes for optimal access and data manipulation methods. using SQL Server Integration Services (SSIS)
  • Execute and monitor ETL jobs in production servers.
  • Ability to work independently and in a team environment.
  • Ability to organize and prioritize multiple tasks and meet aggressive deadlines.

Database Engineer

Confidential, Fairfax, VA

  • Installed, Configured and Upgraded SQL Server 2008 R2
  • Migrated databases from SQL Server 2000 to SQL Server 2008R2
  • Developed and maintained Database backup and restore strategy
  • Identified and addressed database performance issues and capacity issues
  • Involved in installing, configuration and administration of SQL Server version 2008R2
  • Researched, designed and tested a migration plan from SQL Server 2005 to SQL Server 2008R2.
  • Designed disaster recovery, database backup and restore plan.
  • User account management and connection troubleshooting.
  • Monitor SQL Agent Jobs and troubleshooting if job fails.
  • Experience writing SQL queries, Stored Procedures, Triggers, Functions, creating Tables, Views and Indexes
  • Trained members of the Network Access team to handle SQL Server account management.
  • Audit and generate monthly management reports using third party tool.
  • Created the database, Schema, tables, data objects, and setting privileges to the schemas
  • Manage and resolve trouble tickets (Peregrine service centre) for database-related issues submitted by customers.
  • Implement and maintain database transactional push replication, resolve issues associated with replication timeouts, errors, and latency.
  • Promote/migrate SQL-Server objects/data from development to QA and QA to production instances
  • Provide support to application developers in designing and implementing physical database structures.
  • Implemented security, generate and review report periodically and enforce security mechanism
  • Resolve and troubleshoot database issues,
  • Proactively monitored the production database(s) and optimize stored procedures for better performance. Resolve locking conflicts and resource utilization
  • Hardware requirements and storage capacity planning for Development, Testing, QA, Staging, and Production for scalable database growth and performance
  • Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company’s databases and systems
  • Working experience with SQL Server Integration Services(SSIS), DTS and ETL
  • Import & export data from flat files, excel and MS Access to MS SQL Server databases
  • Participates in emergency recovery of databases as well as manages physical structures, space utilization and participates disaster recovery testing.
  • Manage and resolve trouble tickets (Remedy) for database-related issues submitted.

Database Administrator

Confidential, Washington, DC

  • Installed, Configured and Managed SQL Server 2005 in development, test and production environment
  • Installed, Configured and Maintained Fail-Over Clustering using SQL Server 2005
  • Installed and Configured SQL Server Reporting Services (SSRS)
  • Configured and Maintained Replications and Log Shipping as part of a high availability solution
  • Upgraded databases from SQL Server 2000 to 2005 in testing and production environment
  • Applied SP (Service Pack) on SQL Server 2000 and 2005
  • Expertise in database Performance Tuning
  • Wrote T-SQL and Stored-Procedures
  • Responsible for creating, modifying and managing tables, Indexes (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures and Triggers
  • Exported & Imported data from Flat file, CSV file, Oracle, MySQL and Access to/from SQL Server Database using DTS, SSIS and BCP
  • Data modeling using Toad Data Modeler and Visio
  • Generated Report using SSRS (SQL Server Reporting Services)
  • Responsible for Database Backup, Restore and Point-in-Time Recovery

Hire Now