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