We provide IT Staff Augmentation Services!

Sql Database Administrator/dba Resume

0/5 (Submit Your Rating)

Alexandria, VA

SUMMARY:

  • About 6 years of SQL Server DBA experience in production, test and development environment
  • Installed, Configured & Maintained MS SQL Server 2000, 2005, 2008, 2008R2, 2012 and 2014 on a standalone and Clustered Servers (Active/Active and Active/Passive Cluster Design)
  • Applied SP (Service Packs), and hot fixes
  • Performed Upgrade of SQL Server 2000, 2005, 2008, 2012 and 2014
  • Experienced using Configuration Tools such as SQL Server Configuration Manager and SQL Server Surface Area Configuration
  • Managed Security
  • Data Modeling using ERWin, Quest Data Modeler, Visio
  • Experienced wif Software Development Life Cycle (SDLC)
  • Experienced in Database Backup, Recovery and Disaster Recovery procedures.
  • Worked on Database High Availability Solutions
  • Worked on Linked and Remote Servers to run queries between SQL servers and other data sources using ODBC, OLE DB drivers
  • Database Monitoring and Performance Tuning
  • Experienced in Online Indexing, Query Optimization, Performance Tuning and Database Consistency Checks using DBCC commands
  • Configured and maintained SQL Server Reporting Services SSRS
  • Experienced in creating and scheduling SSIS/DTS packages in SQL Server to transfer data between various DBMS and files
  • Good experience in debugging SQL Server stored procedures/triggers and documenting issues/resolutions of SQL Server Applications
  • Experienced wif creating alerts, schema management, database reorganization, data loading, database maintenance and optimization
  • Self - motivated; proactive; a team player; able to manage own projects efficiently for on-time delivery

TECHNICAL SKILLS:

Database: SQL Server 2008R 2/2008/2005/2000, MS Access 2003 & 2000MySQL (4.0.3, 5.0.1), Sybase, Oracle

Operating System: Windows Server 2008/2003/2000, Windows XP/NT4.0, MS-DOS, VMware

Languages: SQL, T-SQL, Store Procedures, Trigger, Web Design, HTML, DHTML, XML JavaScript, ASP, ASP.net

ETL Tools: SSIS/DTS, BCP, OSQL, ISQL

Reporting Tool: SSRS (SQL Server Reporting Services)

Data Modeling: Toad Data Modeler, ERWin, VISIO 2003/2007

Networking: Active Directory, TCP/IP, DHCP/DNS, LAN

Hardware/Storage: SAN, RAID

PROFESSIONAL EXPERIENCE:

Confidential, Alexandria, VA

SQL Database Administrator/DBA

Responsibilities:

  • Installed, Configured, and Managed SQL Server 201 R2, 2008, 2005 &2000 in development, test, and production environment
  • Installed and Configured SQL Server 2008 for tes,ting different features and stability
  • Database High Availability:
  • Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008
  • Configured Log Shipping as Standby database from Production database for Reporting purposes
  • Configured and Maintained Replications (Transactional and peer to peer)
  • Database Upgraded (development, testing and production environment):
  • SQL Server / 2008/2012/2014
  • SQL Server 2005 to SQL Server 2008/2012/2014
  • Database Migrated (development, testing and production environment)
  • MS Access 2003/2000/97 databases into MS SQL Server 2000, 2005, and 2008
  • Oracle 10g databases to SQL Server 2008
  • My-SQL 4.1.0/5.0.1 databases to SQL Server 2005 and 2008
  • Data Modeling:
  • Worked on more TEMPthan 10 data modeling projects and generated E-R Diagram
  • Data Modeling tools used using ERWin, VISIO, Quest Data Modeler, SQL Server Data Diagram
  • Used Backward & Forward Engineering wif data modeling tools mentioned above
  • Patch Management:
  • Applied SP (Service Pack) on SQL Server 2000, 2005, 2008
  • Applied HOT Fixes on SQL Server 2000, 2005, 2008
  • Applied Patch on Windows Server 2003 Enterprise Edition
  • Database Monitoring/Performance Tuning:
  • Strong on database Monitoring and Performance tuning
  • Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
  • Monitor SQL Server Error Log, space usage
  • Database Programming:
  • Writing T-SQL, Trigger, and Stored-Procedures
  • Assisted Database Developers to optimize SQL queries and Stored Procedures
  • DTS/SSIS:
  • Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
  • Export & Import data from/to databases like Oracle, My-SQL, and Access to/from SQL Server
  • Backup/Recovery:
  • Strong noledge and working experience in Database Backup and Disaster Recovery
  • Experienced wif Point-in-Time Recovery
  • Restored Database from backup
  • Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well
  • Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Developed Different Maintenance Plans for database monitoring
  • Monitor Server Activity, and solving problem as needed

Confidential, Alexandria, VA

Database Analyst

Responsibilities:

  • Installed, Configured, and Managed SQL Server 201, 2005 &2000 in development, test, and production environment
  • Installed and Configured SQL Server 2008 for testing different features and stability
  • Installed, Configured and Maintained Database Mirroring using automatic fail-over option in SQL Server 2008.
  • Configured Log Shipping as Standby database from Production database for Reporting purposes
  • Configured and Maintained Replications (Transactional)
  • Installed, Configured, and administered SQL Server Reporting Services (SSRS)
  • Deployed Reports
  • Database Upgraded (development, testing and production environment):
  • SQL Server
  • Database Migrated (development, testing and production environment)
  • MS Access 2003/2000/97 databases into MS SQL Server 2000,2005, and 2008
  • Oracle 10g databases to SQL Server 2008
  • My-SQL 4.1.0/5.0.1 databases to SQL Server 2008
  • Worked on more TEMPthan 10 data modeling projects and generated E-R Diagram
  • Data Modeling tools used using ERWin, VISIO, Toad Data Modeler, SQL Server Data Diagram
  • Backward & Forward Engineering wif data modeling tools mentioned above
  • Applied SP (Service Pack) on SQL Server 2000, 2005 and 2008
  • Applied HOT Fixes on SQL Server 2000, 2005 and 2008
  • Applied Patch on Windows Server 2003 Enterprise Edition
  • Strong on database Monitoring and Performance tuning
  • Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification
  • Monitor SQL Server Error Log, space usage
  • Write SQL/T-SQL, Trigger, and Stored-Procedures
  • Assisted Database Developers to optimize SQL queries and Stored Procedures
  • Export & Import data from Flat file, CSV file to/from SQL Server Database using DTS, SSIS, and BCP
  • Export & Import data from/to databases like Oracle, My-SQL, and Access to/from SQL Server
  • Strong noledge and working experience in Database Backup and Disaster Recovery
  • Experienced wif Point-in-Time Recovery
  • Restored Database from backup
  • Used DBCC to check database conditions, Rebuilding indexes and other database Maintenance purposes as well
  • Strong working experience in creating, modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Developed Different Maintenance Plans for database monitoring
  • Monitor Server Activity, and solving problem as needed

We'd love your feedback!