We provide IT Staff Augmentation Services!

Lead Systems Specialist Resume Profile

Cary, NC

Professional Summary:

  • 12 years of professional experience as an Operational/production and Development DBA in SQL Server 2014/2012/2008 R2/08/05/00, DB2, Oracle 9i/10g/11g Databases on prod, staging/dev and DR environments related to almost all domains.
  • Expertise in performance Analysis, and Production Support for Large VLDB , Complex and highly transacitive Databases.
  • Expertise in mentoring and setting up High availability environments like active-active and active-passive clustering, Database Mirroring, Replication, Log shipping, setting up servers from scratch on clustered environment, Linked servers.
  • Extensive experience in planning and implementing Disaster Recovery solutions, capacity planning, data archiving,backup/recovery strategies, Performance Analysis and optimization of SQL server 2014/2012/2008 R2/08/05/00.
  • Experience in creating documentation of installation, monitoring procedures, security policies, configuration changes, migration procedures and best practices.
  • Configured more than 2 GB RAM on 32 bit clustered and standalone environments.
  • Expertise in RDBMS S/W Installation, applying patches, Upgradation, configuring, managing, monitoring disk space usage, database integrity/consistency and troubleshooting of SQL Server 2014/2012/2008/2008 R2/05/00 on Windows 2012/2008/03/00 servers Clustered VMware environment.
  • Good experience in CDC, backup compression, Data compression.
  • Good Knowledge on SQL server 2014 new features.
  • Migrating/Upgrading SQL Server 7.0 databases into SQL Server 2000 and SQL Server 2000/05/08/08R2 databases into SQL Server 2005/2008/2008 R2/2012/2014 by In-place up gradation and side-by-side migration including DTS to SSIS migration and Data Center Migration/Consolidation of servers.
  • Expertise in Tuning T-SQL,PL/SQL Complex Queries, Stored Procedures,
  • Expertise in Using DMVs, DMFs, DTA, ITW, Performance dash board and database snapshot.
  • Expertise in Data/Table partitioning, online Indexing, rebuild/reorg indexes and Update statistics at regular intervals for better performance.
  • Expertise in handling blocking and dead lock situations.
  • Experience in implementing SQL Server security models to prevent unauthorized access which Includes windows/mixed authentication, database permissions, roles, securable and principles.
  • Monitoring Jobs, Alerts and scheduling SQL server Agent jobs.
  • Experience with ETL/OLAP tools like Analysis Services SSAS , Reporting Services SSRS , and Integration Services SSIS , DTS, BCP and Bulk insert.
  • Experience in using tools like SQL Profiler, Performance monitor,Ipmon,SCOM,HPOV,Clarity Manager,litespeed,Redgate,SQLRAP VSS,CVS,TFS and Remedy and Cmd prompt tools like I/OSQL,SQLCMD.
  • Excellent experience in configuring servers, databases and IIS.
  • Having very strong experience on E-commerce Applications.
  • Experience in Oracle Database 9i/10g/11g RAC, DB2, MySQL Administration.
  • Experience in windows/Unix/Linux administration.
  • Expertise in creating and resolving problem/service tickets, Implementation of changes on production according to the SLA.
  • 24/7 Production Database On call Support.

Technical Skills:

Operating Systems : Windows 95/98/ME/XP/NT, windows advanced server 12/08/03,

Red Hat Linux AS 2.1/3.x/4.x,

Sun Solaris 8,9,10

Languages : C, C , VB.Net, C .Net, SQL, T-SQL, PL/SQL, VB script,

Shell Scripting, Perl script

.Net Technologies : ASP.Net, Ado.Net, Web services, .Net Frame work

2.0/3.0

Web Technologies : HTML, DHTML, XML, XSLT

Databases : SQL server 6.5/7.0/2000/2005/2008/2008 R2/2012/2014,Oracle

8i/9i/10g/11g, DB2, MS-Access, My SQL,Postgres SQL

SQL Server Tools/Utilities : Enterprise Manager, Query Analyzer, SQL Profiler,

Perfmon, DTS, SSIS, SSRS, SSAS, Litespeed, Erwin,

Ipmon, Spotlite, Foglite, Quest, DBCC, BCP, Redgate

Oracle Tools/Utilities : Import/Export, Data Pump, SQL Plus, DBCA, DBUA

TKPROF, STATSPACK, RMAN, Explain plan, OEM, TOAD,

DATAGUARD, GRID, AWR, ADDM, Listener.ora, ASM,

Tnsnames.ora

Web Servers : IIS, Apache

Testing tools : Win Runner, QTP, TD

Reporting Tools : crystal reports 9.0/10, SSRS

Monitoring Tools : SCOM, HPOV, IPMON

Professional Experience:

Confidential

Lead Systems Specialist

Responsibilities:

  • Supporting SQL Server 2014/2012/2008 R2/08/05/00, Oracle 9i/10g/11g and DB2,Mysql databases on Production, Staging/Dev and DR servers on clustered VMware Environment.
  • Provide Database Administration support and serve as the escalation point to the Tier I Incident Management team through the timely resolution of critical incidents, in-depth review and resolution of recurring/systemic issues through problem management, and implementation of complex change requests.
  • Migrated/ Upgraded SQL Server 2008 R2/2008/2005/00 databases to SQL Server 2014/2012/2008 databases including DTS to SSIS migration.
  • Installation of Active-Active and Active-passive 64-bit SQL Server 2014/2012/2008/2008 R2 failover cluster on 64-bit Windows Server 2012/2008 R2/2003 cluster Virtual environment including SQL patching.
  • Responsible for designing, planning, and implementing databases, including security, access, and documentation, provides technical assistance in identifying, evaluating, and developing systems and procedures as they relate to databases.
  • Creating Database maintenance plans for compressed full DB backup and transaction log backup, Check Database Integrity, Index maintenance and update statistics.
  • Supporting more than 2000 SQL server servers including Oracle/MYSQL and DB2 servers for different customers on different environments CAAS, Hosting, RAM and Terremark.
  • Managing Security like windows/Unix, Oracle and SQL Logins, Roles, permissions for various users.
  • Setting up and monitored Disaster recovery environments like Database mirroring with in the primary Data center servers and Log Shipping between primary and secondary Data center servers including Mirroring conjunction with Log Shipping.
  • Creating Database Snapshots on Mirror databases for generating the reports for business crew members and worked with linked servers.
  • Configuring and monitoring Merge and Transactional Replication for different clients for Reporting purpose
  • Resolving Application connectivity issues like connection timeouts, connection pooling and Blocking, Dead lock issues.
  • Trouble shoot Mirror, Log shipping and Transactional replication synchronization issues.
  • Trouble shoot Application and Backup jobs failed issues and SQL cluster installation and cluster resources failed issues.
  • Resolve Database, query performance, Log file full and Low disk space issues.
  • Monitoring SCOM/HPOV alerts, creating tickets with remedy/ETMS/SDP ticketing tools according to severity of the alerts.
  • Worked on problem tickets PR01/PR02/PR03, service tickets SR01/SR02/SR03 and Change implementation tickets according to the SLA for different clients.
  • Delivering good service towards customer satisfaction.
  • Configuration of data partitioning/table partitioning on large tables containing millions of rows in Data ware house databases for better performance and performed Data Compression on large tables to reduce the Database size.
  • Deployment of SSIS packages .dtsx files and Config files from staging to Production.
  • Deployment of T-SQL/PL-SQL Complex Stored Procedures, views, tables and functions under Change control on production servers.
  • Database operation support for SQL server 2014/2012/2008 R2/2008/05/00, DB2 and oracle 10g/11g/DB2/MySQL databases which includes OLTP and OLAP, Data Guard.
  • Loading flat files into Oracle Database using SQL Loader.
  • Resolve Oracle blocking locks, table space issues, RMAN Backup issues adding ASM data files, generating AWR and ADDM reports for performance analysis, monitoring alert logs, Instance and DB health check, Export/Import Data.
  • Supported MySQL, Postgres SQL and DB2 databases including Windows and Active directory administration.
  • Migrating/Upgrading MySQL databases, applying required patches and managing security.
  • Supported My SQL Master/Master and Master/Slave Replication, MySQL Backups and Restores.
  • 24/7 Production Database On call Support.

Environment: SQL Server 2014/2012/2008 R2/2005/2000,Oracle database 9i/10g/11g,UNIX,T-SQL,DB2

PL/SQL,Postgres SQL,, MySQL, Linux AS, Windows 2008 R2/03, AIX, VMware, V-sphere,

ESX, SQLRAP, SCOM, HPOV, Remedy, Clarity Mgr, Citrix, Windows Active Directory.

Confidential

Database Administrator

Responsibilities:

  • Supported SQL Server 2008 R2/08/05/00, Oracle 9i/10g/11g and DB2,Mysql databases on Production, Staging/Dev and DR servers on clustered VMware Environment.
  • Supported for the maintenance and administration of the live production SQL Server instances including data warehouse and other disaster recovery instances related to live production.
  • Installed Active-Active and Active-passive 64-bit SQL Server 2008/05 failover cluster on 64-bit Windows Server 2008 R2/2003 cluster Virtual environment including SQL patching.
  • Migrated/ Upgraded SQL Server 2005/00 databases to SQL Server 2008/08 R2 databases including DTS to SSIS migration.
  • Created Database maintenance plans for compressed full DB backup and transaction log backup, Check Database Integrity, Index maintenance and update statistics.
  • Supported more than 2000 SQL server servers including Oracle and DB2 servers for different customers on different environments CAAS, Hosting and RAM.
  • Managed Security like windows/Unix and Oracle, SQL Logins, Roles, permissions for various users.
  • Setting up and monitored Disaster recovery environments like Database mirroring with in the primary Data center servers and Log Shipping between primary and secondary Data center servers including Mirroring conjunction with Log Shipping.
  • Created Database Snapshots on Mirror databases for generating the reports for business crew members and worked with linked servers.
  • Configured and monitored Snapshot, Merge and Transactional Replication for different clients for Reporting purpose
  • Configured tempDB w.r.t to the no. of processors and resolved Application connectivity issues like connection timeouts, connection pooling and Blocking, Dead lock issues.
  • Trouble shooted Mirror, Log shipping and Transactional replication synchronization issues.
  • Trouble shooted Application and Backup jobs failed issues and SQL cluster installation and cluster resources failed issues.
  • Resolved server, Database, query performance, Log file full and Low disk space issues.
  • Monitoring SCOM/HPOV alerts, creating tickets with remedy ticketing tool according to severity of the alerts
  • Worked on problem tickets PR01/PR02/PR03, service tickets SR01/SR02/SR03 and Change implementation tickets according to the SLA for different clients.
  • Delivered good service towards customer satisfaction.
  • Experience with troubleshooting DB issues on outage bridges with customers.
  • Configured data partitioning/table partitioning on large tables containing millions of rows in Data ware house databases for better performance and performed Data Compression on large tables to reduce the Database size.
  • Deployed SSIS packages .dtsx files and Config files from staging to Production.
  • Deployed T-SQL/PL-SQL Complex Stored Procedures, views, tables and functions under Change control on production servers.
  • Migrating/Upgrading MySQL databases, applying required patches and managing security.
  • Supported MySQL, Postgres SQL and DB2 databases including Windows and Active directory administration.
  • Supported My SQL Master/Master and Master/Slave Replication, MySQL Backups and Restores.
  • Mentored and provided best practices to other ROC DBAs for supporting different clients.
  • Technical escalation for client, client executives and management.
  • Database operation support for SQL server 2008/05/00, DB2 and oracle 10g/11g databases which includes OLTP and OLAP.
  • Resolved Oracle blocking locks, table space issues, RMAN Backup issues adding ASM data files, generating AWR and ADDM reports for performance analysis, monitoring alert logs, Instance and DB health check, Export/Import Data.
  • 24/7 Production Database On call Support.

Environment: SQL Server 2008 R2/08/05/00, Oracle 10g/11g, DB2,Linux AS, Windows 2008 R2/03,AIX,

VMware, V-sphere, ESX, SQLRAP, SCOM, HPOpenView, Remedy, ClarityManager, CVS,

TFS, BIDS, SQL Profiler, Perfmon, T-SQL, PL/SQL, SSIS, SSRS, SSAS, MySQL, Win

SCP3, Citrix, RMAN, OEM, Site scope, Opsware, Putty, Secure CRT, veritas, Netbackup.

Confidential

Sr. DBA

Responsibilities:

  • Administrated the SQL Server 2008/2005 and 2000 servers and production, pre-production, non-production databases, Application support and Performance Analysis/tuning.
  • Monitoring, optimizing the performance of the database servers.
  • Performed all aspects of database administration including installs, builds, upgrades, backup and recovery, patching, monitoring and cloaning.
  • Provided recommendations for improvements on existing topology, documentation for overall database performance and estimations for future expansion of databases.
  • Installation of SQL Server 2008/05 and on Windows Server Clustered environment.
  • Worked on 78 instance of SQL server and 12 instances for Oracle with around 431 databases of SQL and 70 databases of Oracle.
  • Leading support teams in a 24 x 7 support environment.
  • Planning, managing, assigning and scheduling database tasks to the team members.
  • Migrated/Consolidated from Two Data centers into one Data center.
  • Migrated/Upgraded SQL Server 2000 databases to SQL Server 2005/2008 databases including DTS to SSIS migration and migrated SQL Server 2005 to VMware and Oracle to SQL.
  • Data transferred using BCP/Bulk insert from Excel, Flat files to SQL Server vice-versa with different formats.
  • Configured IIS and Report server integrated with SharePoint server using Reporting services configuration and Developed SSRS custom, sub reports and Ad-hoc reports.
  • Created and altered/modified stored procs,complex queries, views to generate reports
  • Extensively worked on snapshot andTransactionreplication disaster recovery environments.
  • Setup, configured and monitored Log Shipping and Database Mirroring for 2000 and 2005 Production servers for disaster recovery across multiple domains.
  • Used DMVs, DMFs for Identifying missing indexes and Index usage stats, Fragmentation levels of Indexes etc for query/stored procs tuning.
  • Involved in configuring table/data partitioning on huge tables for better performance.
  • Responsible for monitoring Jobs, SQL auditing, Didkspaces, error logs and making recommendations for performance improvement in hosted databases which involved file group modifications, and scheduling jobs to rebuild/reorg indexes, update statistics and security.
  • Troubleshooted Application connectivity issues, Blocking and deadlocking issues.
  • Scheduled jobs using Autosys.
  • Created stored procedures/Packages db-links, triggers using T-SQL and Pl/SQL programming according to the business logic.
  • Reviewed and approved stored procs developed by the developers and data modification SQL script for production.
  • Performed backup and recovery functions by RMAN and logical backups by Export, Import and Datapump utilities for Oracle databases and Litespeed backup for SQL Server databases on Clustered environment.
  • Resolved database space issues by sizing Table spaces, data files, and log files in Oracle.

Environment: SQL Server 2008/05/00, Oracle 9i/10g, DB2 UDB, Linux AS, Advanced Windows 2008/03

Server, AIX, Sybase, VSS, BIDS, Profiler, T-SQL, PL/SQL, TOAD, RMAN, OEM, Db-links

SQL Loader, Perl script, SSIS, SSRS, SSAS, SCOM, LINQ, VB.Net, C .Net, ASP.Net,

VB script, ERWIN, Ipmon, Litespeed, Autosys, MS Visio, Power Designer, TSM, Excel.

Confidential

DBA/Developer

Responsibilities:

  • SQL Server 2005 Database Administration and maintained all production, non-production databases and DR environments including development, Integration testing, UAT and troubleshooted SQL Server 2005/00 systems and disaster recovery site.
  • Configured and Monitored disaster recovery environments Log shipping/ Transactional Replication and trouble shooting of errors.
  • Involved in Administration, Database Design, Performance Analysis, and Production Support for Large VLDB .
  • Monitoring the SQL server performance with SQLDIAG and testing the production server data load and I/O stress.
  • Migration of SQL Server 2000 databases to SQL Server 2005 databases including DTS to SSIS migration.
  • Created, deployed and managed reports using SQL Server Reporting Services SSRS
  • Loading flat files into Oracle Database using SQL Loader.
  • Developed stored procedures/Packages using T-SQL, PL/SQL programming to meet the business requirements.
  • Performed backup and recovery strategies using cold backup/hot backup/RMAN for oracle databases and Redgate for SQL Server databases on clustered environment.
  • Extensively worked on DTA, DMV's, DMF's, online indexing, Data partitioning and tuning of long running stored procs and complex queries.
  • Performed day-to-day tasks like monitoring jobs, Alerts, SQL Server Error logs, Event logs, Disk spaces, Alert logs and SQL auditing including backup and restore.
  • Analyzed long running queries and tuned the same to optimize application and system performance.

Environment: SQL Server 2005/2000, Oracle 9i/10g, DB2UDB,TERADATA, Linux, Window Server 2003,

VSS, SQL profiler, Perfmon, T-SQL, SQL, PL/SQL, RMAN, TOAD, OEM, SQL Loader,

TSM, Litespeed, Spotlight, SSIS, SSRS, SSAS, ERWIN, Power designer, XML, XSLT,

VB.NET, ASP.NET.

Confidential

DBA/Developer

Responsibilities:

  • Installing, configuring, administering and securing production and non-production servers.
  • Involved in complete SDLC which includes requirement gathering, analysis, design, development, Implementation.
  • Implemented and maintained database security.
  • Involved in capacity planning and sizing for new database servers.
  • Migrated MS-access databases to SQL Server 7.0 databases.
  • Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
  • Trouble shooted and minimized production down issues.
  • Created T-SQL, PL/SQL packages, procedures, functions, triggers, alerts, scripts for automation and DTS packages for ETL.
  • Developed Transact-SQL scripts to enforce business rules.
  • Monitoring of alert log files, control files, archive log destinations, blocking, deadlock issues and long running complex queries/stored procs.
  • Export and Import of database objects to copy from one database to another database.
  • Designed new job process, new database maintenance plans, DTS packages.
  • Resolved failed and long running MS SQL Server jobs.

Environment: SQL Server 7.0/2000, Oracle 8i, Ms-Access, SQL, Enterprise Manager, Query

Analyzer, Windows 2003/2000, Linux, PL/SQL

Hire Now