SUMMARY

• Eight (8) years of experience in database administration, system analysis and administration, design, development and support of MS SQL Server 2008/2005, 2000 and 7.0 in production and development with log shipping, mirroring, replication and clustering environments
• Experience managing very large databases in a 20 TB SQL environment
• Strong DBA experience in 24/7 call center environments and production environments with a thorough understanding of Standard Operation Procedures (SOP) and Service Level Agreements (SLA)
• Implemented and worked on Change Data Capture (CDC)
• Experience working with OLTP/OLAP environments that includes production (24 x 7), QA and development databases in SQL Server
• Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, back - up/recover and running DBCC commands
• Experience importing and exporting data from Excel and Oracle that was sent to the MS SQL Server databases using DTS and SSIS utilities
• Experience in data migration from MS SQL Server and and 7.0 to 2000
• Work experience with data center migrations and server upgrades
• Intensive experience in performance tuning and monitoring SQL Server and database performance using database tuning advisor, SQL profiler, index tuning Wizard and Windows performance monitor
• Transformation Services (DTS), bulk insert and SQL Server Integration Services (SSIS)
• Excellent in automating processes by creating jobs and error reporting using alerts and SQL mail agent
• Specialized in designing and implementing different types of replication models, database mirroring modes and clustering environments (active/passive) to further increase the scalability and the stability of business critical systems
• Performed the ETL operations to support the data loads and transformations using SSIS (SQL Server Integration Services)
• Strong in SQL, T-SQL and PL/SQL database programming, development of Stored Procedures, Cursors, Triggers and Views
• Performed regular application builds and test builds using TFS
• Intensively supported and worked with Epic Clarity ETL tools for huge reporting applications
• Thorough knowledge of SAN and RAID technologies

TECHNICAL SKILLS

Programming Languages: T-SQL, PL/SQL, VB, C, C++, XML

RDBMS: MS SQL Server 2012/2008R 2/2005/2000/7.0 , MS Access 2005/2000, Sybase ASE 15.0

Web Tools: MS Front Page, Internet Information Server (IIS), FTP, TCP/IP, LDAP, SMTP, LAN, and MS Outlook Express

Operating Systems: Windows 2012, 2008R2, 2003, 2000 Enterprise Server, Windows NT 5.0/4.0/3.5, Windows 9.x/3.x, MS DOS SQL Server management studio, SQL Server Business Intelligence Development Studio (BIDS), database Engine Tuning Advisor, Query Analyzer, SQL profiler, Data Transformation Services, DTSRUN, MS Visio, SQL loader and import and export (DTS)

Database Tools: DTSXChange, SQL profiler, performance manager, Query Analyzer, SSIS, ERwin, OPManager, Quest LiteSpeed, DBscribe, DBartisan, Shareplex, Crystal Reports 10.0, Cognos Reporting, Toad, Veritas Netbackup, Red-Gate, ISQLW utility, UDF, OSQL utility, SQL CMD, CLR integration and Oracle Designer

Utility Tools: MS Office, MS Project, Rational ClearQuest, Visual Source Safe 6.0, Rational ClearCase, Autosys, Hobbit, Windows Active Directory, System Center Operations Manager (SCOM), Informatica, Benchmark testing, Double-take, PolyServe, Power Designer, Visio 2007, Spotlight, BizTalk, ProClarity, MOM (Microsoft Operations Manager) and SSMS (SQL Server Migration Assistant)

PROFESSIONAL EXPERIENCE

Sr. SQL Server DBA/SQL Architect

Confidential, Raleigh, NC

Responsibilities:

• Installed SQL Server 2012 in a Windows 2008 server environment and migrated the existing SQL Server 2008/2005 databases to SQL Server 2012
• Maintained the data security using encryption/decryption in SQL Server
• Secured the SQL Server using transparent data encryption
• Provided 24x7 production database support using SQL alerts
• Performance tuned complex queries based on the issues
• Worked closely with other developers, project management, and key stakeholders
• Participated as a key team member in a .NET software development effort
• Assisted with the establishment of, and adherence to, development standards based on industry accepted methodologies and standards
• Introduced CDC Change Data Capture for data audits and reporting purposes
• Designed new schemas and databases according to the new business and application requirements
• Completed the regular database builds and deployments on test and production database environments
• Designed and implemented database backup and restoration strategies
• Implemented and maintained database maintenance plans as per the project and business environment
• Developed, deployed and maintained reports using SQL Server Reporting Services (SSRS)
• Fixed the daily production server, database and data issues
• Updated the T-SQL codes and Stored Procedures as per the requirements
• Worked on the database physical and logical modeling
• Worked on SQL Server Integration Services (SSIS) as per the business requirements
• Introduced the database file stream concept
• Documented all of the design changes and modifications to the systems

Environment: Windows 2012/2008R2/2008/2005, MS SQL Server 2012/2008R2/2008/2005, SQL Server Data Tools, BIDS (SSIS & SSRS), MS Access 2003, FTP, terminal server, SQL Profiler, database Engine Tuning Advisor, DTS, T-SQL, MS Visio, MS Office

Sr. SQL Server DBA

Confidential, Scottsdale, AZ

Responsibilities:

• Maintained the SQL 2000/2005/2008 databases on Windows 2003/2008 platforms
• Worked on 5 TB SQL and environments with some databases up to 1.5 TB
• Provided production support and monitored on call 24/7
• Worked on high availability SQL Server solutions like database mirroring and SQL Server clustering
• Implemented log shipping on a few production databases for reporting purposes
• Planned and implemented efficient backup strategies for the entire SQL environment which suited the business requirements
• Worked on instance migrations and releases
• Represented the SQL environment in the design sessions, systems and network upgrade sessions and provided the SQL Server support as per the requirements
• Maintained the database versions for production tracking
• Enabled the SQL auditing for tracking changes
• Enabled Change Data Capture (CDC) for reporting as well as for auditing purposes
• Supported SSIS and SSRS reports as well as deployments in to the production servers, QA and Dev environments
• Managed all of the database releases and used TFS to maintain the database scripts
• Used the performance monitor and SQL profiler to optimize queries and enhance the performance of database servers
• Created and managing schema objects such as Tables, Views, Indexes and Referential Integrity depending on the user requirements and converted them into technical specifications
• Created and monitored the database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updated the statistics
• Used DBCC commands to check the physical and logical consistency of the databases and rebuild Indexes
• Created SSIS packages to export data from Oracle/DB2/MySQL to the SQL Server database and transformed the data from Excel/Access to the SQL Server database
• Configured transactions and snapshot replications in order to increase the scalability and the stability of business critical systems
• Documented the processes and uploaded on to SharePoint
• Estimated data volumes for planning
• Used Idera SQL Safe to do backups on the SQL Server 2000 and 2005 databases

Environment: Windows 2003/2008, SQL Server 2000/2005/2008 R2, BIDS (SSIS), Idera SQL Safe, Erwin, SCOM, FTP, LDAP, Terminal server, SQL Profiler, DTS, T-SQL, SSIS, BCP, MS Visio, MS Office

Sr. SQL Server DBA

Confidential, Sacramento, CA

Responsibilities:

• Worked on 15 TB SQL and environments with some databases up to 10 TB
• On-call for alternate weeks for production support 24x7
• Migrated databases from SQL Server 2000 to SQL Server 2008 R2
• Migrated databases from the SQL Server on the Windows 2008 R2 Server
• Completed many SSIS and reports deployment on the production servers
• Used performance monitor and SQL profiler to optimize queries and enhance the performance of database servers
• Worked on high availability SQL Server solutions like database mirroring and SQL Server clustering
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on the user requirements and converting them into technical specifications
• Created and monitored database maintenance plans for checking database integrity, data optimization, rebuilding Indexes and updating the statistics
• Used DBCC commands to check the physical and logical consistency of the databases and rebuild Indexes
• Performed import/export using DTS and BCP utility
• Created SSIS packages to export data from Oracle to the SQL Server database and transformed the data from Excel/Access to the SQL Server database
• Supported and worked with Epic Clarity ETL tools for huge reporting applications
• Supported Informatica, Crystal Reporting and Business Objects teams
• Configured transactions and snapshot replications in order to increase the scalability and stability of business critical systems
• Worked as part of an on-call support rotation team
• Estimated data volumes for planning
• Performed backup, recovery and automation of backups and used Idera SQL safe to take backups on SQL Server 2000 and 2005 databases

Environment: Windows 2003/2008, SQL Server 2000/2005/2008 R2, BIDS (SSIS), MS-Access 2003, PL/SQL, Idera SQL Safe, Erwin, SCOM, FTP, LDAP, Terminal Server, SQL Profiler, DTS, T-SQL, SSIS, BCP, MS Visio, MS Office