We provide IT Staff Augmentation Services!

Database Administrator Resume Profile

Summary

A Database Administrator with 6 years experience in administering SQL databases. Knowledgeable in all parts of system development life cycle SDLC and all levels of database and report development/management including data modeling as well as developing database objects such as stored procedures, triggers, tables, views, functions, constraints, database movement, managing/moving securities, managing jobs and partitions, etc. in deed, highly professional, consummate team player and multi-tasking in timely manner.

Experiences:

  • Lead on Database upgrade and migration
  • Master of database Backups and Restoration
  • Installing, Configuring, Updating, Deploying and Administering Databases in Test, Development and Production environment
  • Deep understanding and working experience as a Database Administrator of SQL Server SQL 2000, 2005 and SQL 2008 , MS Access, Sybase, and MySQL
  • Performed Data Modeling, data analysis, database design, and developing E-R diagram using ERWin, Toad Data Modeler, Visio
  • Backward Forward Engineering with data modeling tools mentioned above
  • Implementing business rules in Database.
  • Setting up referential integrity to maintain data integrity
  • Performance Monitoring and Tuning for Instance, Database, and SQL Query using execution plan, Profiler, Database and Index Tuning Tools
  • Monitor Server Activity, Error Log, space usage, and solving problem as needed
  • Third party tools used for Performance monitoring and tuning SpotLight, and Idera SQL Diagnostic Manager
  • Strong knowledge and experience in configuring and administering High Availability Solutions like Database Mirroring, Replication, Log shipping, and Clustering
  • Vast knowledge and working experience on SSIS, and DTS for data movement and manipulation
  • Proven experience on SQL Server Reporting Services, using SQL/T-SQL Scripting for customized Report Generation and Management
  • Create, set-up, and manage Jobs for Database Automation like index management, fragmentation management, backup, statistics etc.
  • Used Microsoft Best Practices with regards to configuration of SQL data/log drive locations
  • Managed Security and database Audit
  • Proven experience in installing, upgrading, and maintaining Database servers, Web 2008
  • Applied Service Pack SP for Databases, Operating Systems
  • Migrated databases from other databases like Oracle 10g, MySQL, MS Access, and Sybase to SQL Server 2005 and 2008
  • Upgraded SQL Server 2000 to SQL Server 2005/2008 and SQL Server 2005 to SQL Server 2008
  • Working experience in configuring and setup Database Mail Server for database mail notification
  • Moved and deployed databases in test and production environment
  • Managed logins and security
  • Experience in administering AD Active Directory /Domain and monitoring user activities
  • Documentation: wrote so many documentations like baseline for SQL server, clustering documentation, database requirement analysis, data modeling, applying service pack, deployment documentation etc
  • Working experience with SAN and RAID
  • Best in providing excellent customer support, dealing with non-technical, and upper level management
  • Experienced in providing end-user support on a day-to-day basis
  • Enjoy working in a team environment and independently as well
  • Programming: SQL, T-SQL, .Net, ASP.Net, HTML

Professional Work History

Database Administrator

Confidential

Main Responsibilities:

  • Responsible for managing dedicated databases and servers
  • Installed and Configured SQL Server 2000, 2005 2008 in development, test and production environment
  • Installed and Configured Operating System Windows Server 2000, 2003 and 2008
  • Migrated databases from Oracle 10g, MySQL 4.0.3, 5.0.15 to SQL Server 2008
  • Upgraded earlier versions of SQL Server 2000 to SQL Server 2005/2008 and SQL Server 2005 to SQL Server 2008
  • Migrated MS Access 2003/2000/97 databases into MS SQL Server 2000/2005/2008
  • Closely work with business analyst to deploy databases and manage availability
  • Rebuild Servers Restore Recover from backups
  • Configured and Managed Log Shipping from Production to Standby Server Running as Reporting Server
  • Configured and Managed Database High Availability: Replication, Database Mirroring, Log Shipping, and Clustering
  • Wrote SQL, T-SQL, Triggers and Stored-Procedures
  • Worked with developers to tune-up performance of SQL and T-SQL query
  • Performance tuning optimization of servers in production, test environment
  • Created and managed database security, data encryption, and applied object level security
  • Developed and applied Backup strategy at my current workplace
  • Setup and configured Database mail for notification purposes
  • Developed Database Maintenance Plan for different important tasks
  • Used DBCC and Alter statements for different database Administration tasks like check database consistency, rebuild indexes, statistics, and other jobs
  • Used DMV Dynamic Management View for different database Administration tasks like find backup history, indexes fragmentation, statistics, and status of different jobs
  • Exported Imported database objects from/To Oracle, MySQL, Access Database, flat files text, excel, and CSV files and MS SQL Server
  • Extensive experience in using SSIS/DTS, BCP to import export data from flat files, excel, MS Access, and Other OLEDB databases to MS SQL Server databases
  • Worked on more than 10 Data Modeling projects includes interviewing stakeholders, gathering/analyzing requirements, developing E-R Diagram, designing Logical Physical Database using ERWin, Toad Data Modeler and Visio

Confidential

Main Responsibilities:

  • Installed, Configured, and Managed SQL Server 2000 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, Log Shipping as part of a high availability solution
  • Upgraded DB from SQL Server 7.0/2000 to 2005 in testing production environment
  • Applied SP Service Pack on SQL Server 2000, 2005
  • Expertise in database Performance tuning and writing T-SQL and Stored-Procedures
  • Responsible for creating, modifying and managing tables, Index Cluster/Non-Cluster , Constraints Unique/Check , Views, Stored Procedures, Triggers
  • Export Import data from Flat file, CSV file, Oracle, MySQL, and Access to/from SQL Server Database using DTS, SSIS, and BCP
  • Generated Report using SSRS SQL Server Reporting Services
  • Responsible for Database Backup, Restore and Point-in-Time Recovery
  • Monitor Server Activity, Error Log, space usage, and solving problem as needed

Confidential

SQL DBA

Main Responsibilities:

  • Installed, Configured, updated and Administered SQL Server 2000 2005 in development, test, and production environment as required
  • Supported dedicated database and Servers
  • Restored and Recovered from Backups and Rebuild Servers
  • Managed SQL Server Reporting services using SQL/T-SQL Scripting for customized Report Generation and Management
  • Applied SSIS and DTS for data movement and manipulation
  • Solved day to day problems like error log, space usage using Monitor Server Activity
  • Monitored Performance and Tuning for Instance, Database, and SQL Query using execution plan, Profiler, Database and Index Tuning Tools
  • Moved and deployed databases in UAT/BAT and production environment
  • Administered AD Active Directory /Domain and monitoring user activities
  • Created and Managed database security, data encryption, and applied object level security

Hire Now