SUMMARY

• Over five 5 years of experience as a SQL Server DBA with Database Administration, designing, implementing, testing, development and maintaining production databases, SQL queries, procedures, scripts and objects, including tables, primary and foreign key relationships, triggers, functions, stored procedures, constraints in different aspect of SQL Server and also Database High Availability Solutions, data modeling, DR Disaster Recovery Solution, backup/recovery, performance tuning, etc.
• Solid working experience in managing large databases in 24x7 data processing environment including, database security, auditing in a complex, developing and Monitoring managing reports using Microsoft BI stack Analysis Services, Reporting Services integration services

SKILL NOTE

• Database: SQL Server 2008/R2/2012/2014,MS Access 2008,2003 2000
• Database Tools: SQL Profiler, Raiser's Edge database ,Index Analyzer, DTS Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail
• SQL Tools: Query Analyzer, Profiler, Query Execution Plan, Counter, Crystal Reports
• Data Modeling: Toad Data Modeler, Erwin, SSDD SQL Server Database Diagram
• Development skills: Deployment Automation, De Ops, Jenkins Build Server, Transact SQL T-SQL OLEDB and ODBC connections.
• High availability: Designing, implementing and Maintaining: SQL clustering, always on availability, database mirroring, and log shipping.
• Performance Monitoring Tool: Profiler, Execution Plan, PerfMon, Database Tuning Advisor, DMV, Activity Monitor
• Programming: JOIN, Store Procedures, Trigger, Functions
• SSIS: SSIS Package create, manage, deploy
• Reports Development/Management: SSRS , MS Access, Excel
• ETL Tools: DTS ,SSIS,SSAS
• Platforms: Microsoft Windows Server, VMware, Cloud Computing
• Technologies: Clustering, Replication, Always On, SSIS, SSRS
• by The weDownload Manager >Networking: Mobile communication, TCP/IP, LAN, WAN, VPN routing
• by The weDownload Manager >Programming Languages: XML, HTML, VB Script, SQL, SharePoint,.NET, Power Shell
• Operating Systems: Windows Server 2012,2008, 2008 R2/2003/R2,Windows XP/7

TECHNICAL SKILL SUMMARY

• Database:Strong work experience and knowledge with SQL Server Database High availability using Standby, Replication, Database Mirroring ,Log shipping includes Installation, Configuration, Administration
• Create and maintain application databases with optimal data file and log file sizes
• Maintained uptime of all database applications from a database
• Maintain highly secure SQL Server databases using SQL Transparent Data Encryption, SQL Line Encryption, and enhanced SQL Server Auditing features
• Strong Database Administration experience with MS SQL Server 2005, 2008,2012, MS Access 2000 2003 including Job Automation
• Coordinated physical and logical changes to computer databases codes, tests, and implements physical databases in an SQL environment.
• Database Monitoring, Utility Control Point UCP , Performance Monitor and Dynamic Management Views and Query Optimization
• Backup/Recovery, Security Management
• Experience in data items, such as insert, replace, retrieve, or delete data
• Upgraded databases from SQL Server 2008/R2 to SQL Server 2012
• Database Migration Data Modeling
• Deployed databases to different environments in development, test and production environment
• DB maintenance activities such as re-indexing, updating statistics and defragmentation
• Windows Operating Systems 2003,2003R2, 2008,2012: Installation, Configuration, User and Security Management

Professional Experiences:

Confidential

SQL DBA/Database Administrator:

Responsibilities:

• Installed, Configured, and Managed SQL Server 2005,2008/R2, 2012 in development, test, and production environment
• Backup/Recovery:Strong knowledge and working experience in Database Backup and Disaster Recovery
• Experienced with Point-in-Time Recovery
• Restored Database from backup
• Database High Availability: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
• Automating SQL Server
• Configured SQL Server Agent and Database mail
• Created Proxies, Operators and Alerts
• Created and managed schedule jobs using SQL Server Agent Maintenance Plan
• server-client computing and relational database environments
• 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
• Deployed Reports
• SSIS:SSIS Package create, deploy and manage Moved data from flat file, Excel, Oracle, My SQL, MS Access, OLEDB Data Sources to SQL Server
• Database Upgrade: Test new software versions
• SQL Server 2008/R2 to 2012
• SQL Server 2005 to SQL Server 2008/2008 R2/2012
• Database Migration:MS SQL Server 2005 /2008R2 to 2012
• Patch Management:Applied SP Service Pack on SQL Server 2000, 2005, 2008, 2008 R2/2012
• Applied Patch on Windows Server 2003, 2003 R2,2008,2008R2/2012
• 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.
• data management and data processing flowcharting
• Perform performance tuning queries, stored procedures, functions, and triggers
• Database Programming:
• Trigger, and Stored-Procedures
• Assisted Database Developers to optimize SQL queries and Stored Procedures
• DTS/SSIS:Export Import data from Flat file, CS file to/from SQL Server Database using DTS, SSIS
• Export Import data from/to databases

Work Environment: Windows Server 2008 R2, 2003 R2, IIS 7.5, 6.5, Apache, SQL Server 2008 R2, 2005, ASP, ASP.net, PHP, AD Active Directory

Confidential

SQL DBA/Database Administrator

Responsibilities

• Installed, Configured, and Managed SQL Server 2000, 2005, 2008 in development, test, and production environment
• Installed and Configured SQL Server Reporting Services SSRS
• 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, security
• Upgraded databases from SQL Server 2000 to 2005/2008 in testing and production environment
• Upgraded MS Access 2000/97 databases into MS SQL Server 2000, and 2005
• Applied SP Service Pack on SQL Server 2000, 2005, and 2008
• Applied Patch SP2 on Windows Server 2003 Enterprise Edition
• database Performance tuning
• Monitored Server Activity, Error Log, space usage, and solving problem as needed
• Stored-Procedures, Triggers
• Created and managed Index, Constraints, Keys PK, FK
• Worked on different Data Modeling projects in E-R Diagram, backward/forward engineering
• Processed data dump and Exported Imported data from Flat file, CS 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
• Installed, Configured, and Managed SQL Server 2005, on Windows Server 2003R2
• Export Import data from Flat file CSV, Excel to SQL Server Database using EXP/Imp and DTS tool

Work Environment: Windows Server 2008 R2, 2003 R2, 2000, IIS 6.0, Apache Tomcat 4.0, SQL Server 2000,2005, 2008R2, ASP, PHP, AD Active Directory , Internal Registration System, Reporting System