Summary

• Highly experienced and skilled professional with 12 years of IT experience primarily in Fortune 100 companies, specialized in Database Administration, BI Analysis, Unix/Linux System Admin, Network Management, System Integration and QA Verification
• Over 8 years of solid database management experience including MS SQL Server 2000/2005/2008/ 2008R2/2012 , Oracle 8i, 10g, 11g and MySQL 5.0 and other DBs such as Informix
• Good knowledge of some NoSQL databases such as MongoDB and Cassandra
• Professional knowledge in MS BI SSIS, SSAS,SSRS ETL, Data Warehousing, Reporting
• Extensive experience on 24 x 7 production on call support, database monitoring and troubleshooting
• Professional knowledge of Software Development Life Cycle and Software Quality Assurance Methodology Experienced in Data modeling, Database Design and Implementation
• Result-Driven with ability to take initiatives and meet deadlines in fast paced environments
• Strong analytical and communication skills with the ability to learn new technologies quickly
• Highly well-rounded IT professional with very comprehensive skills in different IT areas to be a great asset and the most cost effective employee for your company and your team

Objective

• Microsoft SQL Server DBA, Oracle DBA, MySQL DBA
• MS BI SSRS/SSAS/SSIS Developer /Analyst
• Database related QA position

Technical Skills

• Database: SQL Server2000/2005/2008/2012, Oracle 8/10g/11g, Access, MySQL, Informix Erwin, TOAD, Redgate, Spotlight, Zabbix, Nagios
• BI /Reporting: SSRS, SSIS, SSAS 2008/12, BIDS, SSDT, ETL Crystal Report, OBIEE 11g
• Language: SQL, T-SQL, PL/SQL, Shell, Python, Power Shell
• OS: Windows Server 2000/3/8, Solaris 8/9/10, Red Hat/CentOS, Ubuntu,
• Sys Admin: MS Active Directory, Exchange, Citrix Metaframe Server Apache, IIS, Tomcat, VMware ESX/vSphere 5, Virtual Box, Cisco UCS, SharePoint 2007/2010
• Networking: Cisco Router, Switch, Firewall TCP/IP, VLAN, VTP, EIGRP, IGRP, RIP
• QA/ Testing: HP Quality Center, QTP Cisco TIMS, CDETS, iTest, Bugzilla, Wireshark

Professional Experiences

DBA/System Administrator

Confidential

• Installed, configured and managed windows 2008, SQL Server 2008/12 on staging and production
• Provided General Database Administration, Query Performance tuning and schema validation
• Performance tuned slow running SQL queries and stored procedures using SQL Profiler, Database Engine Tuning Advisor, execution plan and Performance Monitor.
• Managed Logins, Users, Roles and User permissions, and conducted backup and recovery
• Scheduled and monitored database consistency check, index defragmentation
• Ran DBCC Consistency Checks and fixing Data Corruption in user databases
• Developed Matrix/Parameterized/Sub/drill down/drill through reports by using SSRS 2012
• Developed and deployed SSIS packages to import data from different sources to data warehouse
• Involved in designing cubes in SSAS environment using Snowflake/Star schemas
• Experienced in ER Modeling, Star Schema / Snowflake Schema, Fact and Dimensional Tables

DBA/Associate Staff Engineer

• Installed and managed SQL Server 2008/2008R2/2012 , Oracle11g and MySQL 5.0 databases
• Participated in 24x7 on call support for production database environment
• Designed and implemented database, tables, views, indexes, stored procedures, functions, triggers
• Implemented DR and HA solutions including replication, mirroring, log shipping and clustering
• Used maintenance plan to set up full/differential/log backup and periodically restored databases
• Monitored the system for performance bottlenecks CPU, RAM, Disk IO and Networking
• Identified and resolved performance issues using Task Manager, Resource Monitor, Performance Monitor, Execution Plan, Profiler, Tuning Advisor , DMV, DBCC and third party tools
• Created jobs, alerts and maintenance plan Analyzed activity logs and error logs for troubleshooting
• Assisted in the application development, debugging, configuration and optimization
• Loaded stored procedures and user defined functions implemented by Dev into production
• Experienced in Oracle OEM, RMAN backup and restore, RAC setup, troubleshoot and recovery
• Experienced in MySQL databases backup and restore, replication and cluster configuration
• Involved in data center design, configuration, routing, cabling, racking and maintenance
• Experienced in UNIX Shell Scripts to execute the scripts and manipulate files and directories
• Created SSIS packages for ETL, used SSAS for data analysis and SSRS for reporting
• Developed ad hoc reports by using SSRS 2008/2012 and deployed to intranet/SharePoint
• Involved in Verizon G6 Digital Set-top box and AT T VDSL system integration projects
• Involved in AT T Femto Cell UMTS RAN 3G/4G wireless system integration project
• Participated in Scrum meeting and sprint cycle managed team SharePoint site and files

Security Data Analyst

• Worked in a mission critical Threat Operation Center to monitor and analyze about 25 world email traffic for security threats Worked in 24x7 shifts with global teams
• Accessed Oracle, SQL Server and MySQL databases to query data and extract files and logs
• Coordinated with cross-functional global teams for regular vulnerability assessment and analysis
• Performed constant data analysis and threat assessment to stop or quarantine suspicious traffic
• Accessed VirusLab Environment to dissect, extract and analyze suspicious files/URL in traffic
• Wrote Perl regex and regular expression for data quarantine rules or filters for production
• Responded to security alert and internal audit, patched or upgraded system or apps in emergency
• Assisted in the development of disaster or emergency recovery procedures for production
• Created shift reports using Excel and Access optimized queries for report performance
• Managed varies projects authored the departmental operation procedure booklet
• Detected, reported and followed through the application bugs with Dev and Sys Ops team

Network Operation Center Engineer

• Monitored global production systems for any alert/outage and reacted per SLA and KB
• Applied PL/SQL and T-SQL skills extensively on Oracle and SQL server databases to extract and verify production data in US and offshore data centers and made proper adjustment or correction
• Accessed customers' Solaris/Linux production boxes to do validation and troubleshooting
• Diffused customer frustration effectively and worked with customers to timely issue resolution
• Coordinated with Dev, QA and Sys Ops teams to resolve customer issues Per SLA as needed
• Assisted in implementing disaster recovery and high availability solutions in production
• Involved in applying patches, service packs to production systems in maintenance windows
• Tested different applications and followed through on bugs with Dev, QA, Sys Admin teams

DBA/System Administrator

• Installed and managed SQL Server 2000 and Oracle 8i in staging and production environments
• Configured Oracle High Availability by implementing Oracle parallel servers with shared storage
• Set up RAID 5 on Sun StorEdge Disk Array with Solaris DiskSuite commands for Oracle data files
• Configured and managed Windows2000 Domain Controllers, Exchange2003, Sharepoint2001, ISA2000, Citrix , Bugtrack servers
• Configured and maintained SQL server 2000 to support applications development and testing
• Managed daily and weekly Veritas backup Identified and replaced failed hardware on various Unix/Windows servers and Cisco devices
• Configured and managed Cisco PIX firewalls, Catalyst switches, Routers and Cisco Load Balancer
• Involved in network designing, wiring and troubleshooting Exercised Disaster Recovery drills
• Used Bourne shell and Perl scripting for task automation on Solaris and Linux
• Provided 24x7 support in Solaris and Cisco environment at Staging and Colo AT T Data Center

DBA/System Administrator Consultant

• for various financial applications and provided database related troubleshooting
• Set up MS Active Directory, Domain Controller, Exchange Server and PBX voice system
• Involved in server room and office network design, cabling, racking and equipment installation
• Managed a local branch office and supervised 6 registered Serial 7 securities brokers on branch operation, business and client sourcing and compliance
• Maintained and configured the DSL routers, switches, hubs and other network devices
• Provided desktop support for Win2k, XP users locally or remotely
• Performed fundamental and technical analysis on market and individual stocks and mutual funds
• Traded stocks and mutual funds for clients
• Provided the networking and application support for the branch staff