SUMMARY

• Over Seven (7+) years of experience as a SQL Server DBA (Overall 12 years in IT) with detail oriented, analytical and troubleshooting experience in different aspect of SQL Server and Oracle Development, SQL Server installation and configurations, Database High Availability Solutions, SQL Server Reporting Services (SSRS), data modeling, DR (Disaster Recovery) Solution, backup/recovery, performance tuning, stored procedures, triggers, functions, constraints, indexes, statistics etc.
• Solid working experience in managing large databases in 24/7 data processing environment including, developing and managing reports using SQL Reporting Services (SSRS), and Monitoring. Working experience entails strong knowledge on using database third party tools ( Foglite, RedGate, Aqua Data Studio, ERWin Data Modeler, Toad Data Modeler, Microsoft Visio)for Database Administration, Data Modeling, and Performance Tuning using different Tools like Profiler, Execution Plan, PerfMon, Database Tuning Advisor, DMV, and Activity Monitor.
• Implemented the new SQL Server concepts like Data partitioning, Snapshot isolation, database mirroring, DDL triggers, Online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA. Used PerfMon, profiler, DTA(Database Engine Tuning Advisor) and DMV’s for troubleshoot performance problems, fine - tuning of databases, for finding long running queries and index analysis.
• Data modeling experience in Physical and logical data modeling, Reverse Engineering, Forward Engineering by using ERWin Data Modeler, Toad Data Modeler and Microsoft Visio
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support. Extensive usage of Proactive Monitoring tools of SQL Server
• Working in Oracle Backend and Front End Development by using Oracle 8i, 9i, 10G, Oracle Forms and Reports. Extensive working on Oracle Procedures, Functions, Cursors, Packages, Analytical Functions and Routine SQL.
• Experience of full System Development Life Cycle (SDLC) including system study, system analysis & evaluating business process, designing, development, testing, implementation & documentation of Client/Server applications.

TECHNICAL SKILLS

Database Tools: SQL Server 2000/2005/2008/2008 R2, MS-Access, Oracle 10g/11g

Third Party Tools: TOAD, IDERA, FOGLITE

Languages: T-SQL, Oracle PL-SQL, C++, HTML, Shell, MySQL

Microsoft Tools: MS-Office

Internet Tools: JavaScript, PHP, Dreamweaver

Operating System: Windows 9x/XP/VISTA, Windows 7, UNIX, Linux

Version Control: IBM Clear Case

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2005, SQL server 2008, SQL server 2008R2 and SQL Server 2012 on Windows Server 2003, Windows Server 2008 and Windows Server 2008R2, applied service packs and security fixes.
• Creating T-SQL, stored procedures, tables, views, functions, triggers and indexes.
• Moved data from flat file, Excel, Oracle, MySQL, MS Access, OLEDB Data Sources to SQL Server
• Providing 24x7 dedicated On-Call production support for SQL Server problem resolution and server outages.
• Responsible for configuring and maintaining transactional replication in different environments.
• Responsible for configuring and maintaining Database Mirroring & Log Shipping
• Strong knowledge and working experience in Database Backup and Disaster Recovery.
• Improving database performance using SQL Profiler, Trace Flags, Execution plan and DTA.
• Using Foglight 5.6.5 to monitor all agents, Alarms, Database, Domains, Hosts, the servers and their jobs in a single Management Console, to run and manage reports as required and as schedule
• Developed Reports for different purposes like DBA Reports, user reports using SSRS and Report Builder 3.0 & 2.0
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• SSIS Package create, deploy and manage.
• Strong experience on user management, assigning permissions & roles
• Working with SSIS and DTS package to import & export operations in and out of the SQL Servers.
• Using HP 3Par Recovery Manager for SQL 4.4 to take quick backup, quick restore for databases

Confidential, VA

SQL DBA.

Responsibilities:

• Installed, Configured, and Managed SQL Server 2008R2, 2008 &2005 in development, test, and production environment
• Installed and Configured SQL Server 2008 for testing different features and stability
• Installed and Configured SQL Server 2012 in test and development environment
• Backup/Recovery and Database HA:
• Strong knowledge and working experience in Database Backup and Disaster Recovery. Restored Database from backup
• Installed, Configured and Maintained Database Mirroring including automatic fail-over option in SQL Server 2008
• Configured Log Shipping as Standby database from Production database for Reporting purposes
• Configured and Maintained Replications.
• DBCC:
• Used DBCC to check database conditions, fix database corruption, rebuild indexes and other database Maintenance purposes as well
• Report Development:
• Installed, Configured, and administered SQL Server Reporting Services (SSRS)
• Developed Reports for different purposes like DBA Reports, user reports using SSRS and Report Builder 3.0 & 2.0
• Deployed Reports and managed security of report server including folder level
• SSIS:
• SSIS Package create, deploy and manage
• Moved data from flat file, Excel, Oracle, MySQL, MS Access, OLEDB Data Sources to SQL Server
• Data Modeling:
• Strong Theoretical and Practical work experience on Conceptual, Logical, and Physical Data Model
• Worked on data modeling projects from starting to finishing, generated scripts for objects, Developed Relationship, and Created E-R Diagram
• Backward & Forward Engineering for Logical and Physical Data Model respectively. Implement Normalization up to 3NF.
• Tools used: ERWin Data Modeler, Microsoft Visio
• Patch Management:
• Applied SP (Service Pack) on SQL Server 2005, 2008, 2008 R2
• Applied Patch on Windows Server 2008, 2008 R2
• Database Monitoring/Performance Tuning:
• Strong on database Monitoring and Performance tuning
• Scheduled jobs to automate different activities such monitoring database health, disk space, job alert, index monitoring, stats monitoring etc.
• Database Programming:
• T-SQL, Trigger, and Stored-Procedures
• Assisted Database Developers to optimize SQL queries and Stored Procedures

Environment: Windows Server 2008 R2, 2003 R2, IIS 7.5, 6.5, Apache Tomcat 5.5, SQL Server 2008 R2, 2005, ASP, ASP.NET, PHP, AD (Active Directory)

Confidential

Sr. SQL DBA

Responsibilities:

• Installed, Configured, and Managed SQL Server 2005, 2008 in development, test, and production environment
• Installed and Configured SQL Server Reporting Services (SSRS)
• Developed and Managed Report in SSRS (SQL Server Reporting Services)
• Created and Managed Securities for Reports
• Configured and Maintained Database Replications
• Configured and Managed Log Shipping including Standby database for reporting purposes
• Managed Backup/Restore, Point-in-Time Recovery including backup verification
• Managed Server, Database Roles and Security for different users and user groups
• Upgraded databases from SQL Server 2005 to SQL Server 2008/2008 R2in Test and Production Environment
• Upgraded MS Access 2003 databases into MS SQL Server and 2008
• Applied SP (Service Pack) on SQL Server 2005, and 2008
• Applied Patch SP2 on Windows Server 2003 Enterprise Edition
• Expertise in database Performance tuning
• T-SQL, Stored-Procedures, Triggers
• Created and managed Index, Constraints, Keys (PK, FK)
• Worked on different Data Modeling projects including creating scripts, E-R Diagram, backward/forward engineering
• Processed data dump and Exported& Imported data from Flat file, CSV file, Oracle, My-SQL, and Access to/from SQL Server Database using DTS, SSIS, and EXP/IMP tool
• Setup automated jobs for different purposes including backup, monitoring database health, disk space, backup verification, moving databases from environment to environment including creating test environment
• Developed Different Maintenance Plans such as backups, index management, fragmentation management, cleaning history, deleting old files
• Monitored Server Activity, Error Log, space usage, and solving problem as needed

Environment: Windows Server 2008 R2, 2003 R2, IIS 6.5, SQL Server 2008 R2, 2005, ASP, PHP, AD (Active Directory), Internal (Registration System, Reporting System) and third party applications (Timesheet, Payroll, HR)

Confidential

Oracle Developer

Responsibilities:

• To look after the Technical/Management aspects of the site.
• Management of NSRC Network, System and Databases and WAN connectivity with NADRA HQ.
• Database Backup, Security and Disaster Recovery Planning, data transferring to data warehouse.
• Implementation of RAID1 / RAID5 for data recovery. Managing network security by Managing groups and user. Installing and configuring new hardware / software on activeLAN. Scripting (Batch Files).
• Strong knowledge and working experience in Database Backup and Disaster Recovery.
• User Creation and Rights Administration by using Active Directory.
• On the spot Query Generation for any critical data requirement.
• Reading log files for error handling.
• Query Optimization for fast and Prompt data enquiry.