SUMMARY

• Provided support and maintenance for MS SQL Server, Oracle and MYSQL production databases.
• Maintain and monitor database backups and rotating archives of backup files
• Configure and monitor database mirroring for mission - critical databases
• Configure and monitor log shipping for selected databases
• Daily database server health checks for: backups, jobs, mirroring, replication, etc.
• Monitor and profile production database servers for load and performance bottlenecks
• Expert in SQL Server Integration Service (SSIS), T-SQL Programming, Migrating Data from Flat Files, Excel, Oracle and MYSQL using SSMA and SSIS services.
• Experience in configuring Reporting service, developing and publishing reports using SQL Business Intelligence Development Studio
• Assist application developers with database schema and procedure changes according to company conventions and best practices
• Analysis and approval of database schema and procedure changes from dev to staging to production environments
• Write and update advanced stored procedures for business reporting purposes
• Experience in MS SQL Server Performance Tuning, Query Optimization, Client/Server Connectivity, Data Transformation Services and running Database Consistency checks Using DBCC
• A fast learning and hardworking, sociable and dependable DBA with an excellent written and oral communication skills

TECHNICAL SKILLS

• Microsoft Windows OS 2000/XP Professional/windows 7/windows 8/windows 10
• Microsoft Windows server 2003/2008R2/2012
• Biz Talk Server 2006
• Windows Exchange Server
• Active Directory
• T-SQL
• SQL/PLSQL
• C++
• Shell Script
• LAN/WAN
• TCP/IP
• IDS
• Toad for SQL Server
• Toad Modeler
• Visual studio 2012
• MS SQL SERVER 2005/2008 R2/2012
• MYSQL 5.5
• Oracle 11G
• Microsoft Access 2003/2007
• SQL Business Intelligence Development Studio, SQL Server Management Studio, Enterprise Manager, Query Analyzer, Export / Import (DTS), SSIS

PROFESSIONAL EXPERIENCE

Confidential, Arlington, VA

SQL Server Database Administrator

Responsibilities:

• Completed a migration of all databases in to SQL Server 2012 and currently working in SQL Server 2012 environment.
• Administered and maintained three database platforms: Oracle, MYSQL, and SQL Server.
• Monitors and performs daily database maintenance for: backups, jobs, and IBM Tivoli data storage in all development, testing, and production virtual environment.
• Installed and configured active passive SQL Server Clustering in Production environment.
• Migrated data from Oracle to SQL Server using SQL Server Migration Assistant (SSMA).
• Upgraded from SQL Server 2005 to 2008R2.
• Supports developer’s with data integration services, writing SQL user defined functions and procedures, and troubleshoot database performance issues.
• Schedule and automate SQL agent jobs for backups, Tivoli TDP backups, and Oracle RMAN backups in all databases.
• Administering SQL Server security according to the security policy by creating user Logins/group policies and granting appropriate roles and permission.
• Support SharePoint developers with SharePoint central administration, SharePoint configuration and content Databases
• Prepared project status/progress reports on assigned activities.

Environment: SQL Server 2008R2, SQL Server 2012, Windows Server 2008, T-SQL, SSIS, Windows failover Cluster Manager, Tivoli storage manager, SharePoint 2010

Confidential, Herndon, VA

SQL Server Database Administrator

Responsibilities:

• Monitors and performs daily database server health checks for: backups, jobs, and replication on all development, testing, and production clustered environment.
• Monitors and maintains database backups, rotating archives of backup files on Enterprise databases.
• Monitors and Troubleshoots merge and transactional replications performance in production environment.
• Supports developer’s with data integration services, reporting services, and troubleshooting database performance issues.
• Schedule and automate SQL agent jobs for backups, online index fragmentation, and update statistics in all databases.

Environment: SQL Server 2005, Windows server 2003, T-SQL, SSIS, Biz Talk 2006, EMC Auto start

Confidential

SQL Server Database Administrator/IT Assistant Manager

Responsibilities:

• Support and maintain production databases and web applications.
• Scheduled and monitored jobs for backup, memory capacity, and other SQL scripts.
• Configuring and monitoring database mirroring on selected databases.
• Planning and executing small-scale database modifications and SQL scripts for bug fixes, data repair, and functionality enhancements.
• Prepared and implemented backup strategy for disaster recovery plan.
• Troubleshooting and maintaining issues through continuous monitoring of the database on a regular basis.
• Installing and configuring SQL Server Instances on production/QA/developer servers.
• Installing SQL Server service packs based on the errors and flaws that are found in the application
• Upgraded database host servers from windows server 2003 to windows server 2008 migrating production server database from SQL server 2000 to SQL server 2008.

Confidential

Jr. SQL Server Database Administrator

Responsibilities:

• Installed and Configured new SQL Server 2005 Database Server instances, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) for Development, Testing and Production Environment
• Managed scheduled database processes supporting automated file transfers.
• Maintained databases, including updating statistics, indexing, structure modifications, capacity planning, and index analysis.
• Managed database security, logins, users, roles, and object permissions.
• Monitoring SQL server, Application logs and analyzing the logs, Troubleshooting SQL Server Problems such as SQL Server service, Concurrency problems (blocks, locks, deadlocks, activity monitor), and SQL Agent job execution problems on a regular basis, Resolving various performance issues and running DBCC commands, SQL Tracer, SQL Profiler and NT monitoring tools.
• Prepared and implemented back up strategy, Maintenance plan, Recover strategy and participated in disaster recovery
• Performed Full Backups, differential and Transactional Log Backups. Restored them whenever necessary; worked on Log shipping and transactional replication.
• Worked with integrated project teams as project database administrator for large-scale modifications and new product releases.
• Assisted software engineers and end users with query writing, database access, and general information.
• Performed transaction analysis and performance tuning of database applications and batch processes.
• Conferred with management and staff on policies and procedures, technical problems, and priorities that relate to database operations.
• Provided 24/7 on-call coverage

Environment: SQL Server 2005, Windows server 2007, T-SQL, SSIS