Description
Professional Summary IT Professional with over ten years of IT experiences including 8+ years of DBA/Engineer in financial/insurance sector has been successfully providing Microsoft SQL Server database administration support as well as DB2 UDB and Oracle. With over 10+ years of corporate IT experiences, excellent at process-driven projects following Software Development Life Cycle (SDLC) with successful results and meeting deadlines. Enterprise-level tools Idera SQL Diagnostic Manager Maestro BMC Remedy Patrol BMC Perceiver Alarmpoint Programming/Scripting/Web language and technology UNIX commands CMD commands Perl SQL T-SQL PL/SQL ODBC JDBC PowerShell XML CGI HTML ASP ASP.NET JSP JavaScript VBScript Servlet J2EE Apache Struts JAVA C++ C Visual Basic VB.NET Basic Prolog Scheme Pascal PowerShell. Implemented maintenance jobs for DB backups Log-shipping Replication DB capacity monitoring alert mails (DB Mail). * Utilized SQL Profiler by analyzing traces for performance tuning or troubleshooting. * Partnered with Business Intelligence specialists and Application Developers for implementation and troubleshooting of SSIS (ETL) SSRS SSAS. * Migrated SQL 2000 DTS packages to SQL 2005 DTSX (SSIS) packages and SQL 2005 DTSX to 2008 DTSX packages. Engaged in building 30+ DB servers (Clustered servers VMware standalone blade servers) in all phases through enterprise-level server build process and partnered with DB Engineers Storage Engineers Application Developers Capacity Management associates Business customers. * Implemented database changes from non-production environments to production environments by following SDLC. * Participated in database capacity from analysis phase to the final phase with database engineers storage engineers and customers. * Advised customers with potential database server space issue and future optimal capacity recommendations. * Provided support for SQL Servers sitting in standalone VMware Blade Clustered Windows DB servers. * Performed routine failover practices for Disaster Recovery Testing including local failover (Cluster Node switching) and regional failover. * Supported 20 to 30+ projects simultaneously and provided backup support for teammates. Supported projects of various DB technology (OLTP OLAP Data Warehousing Data Mining Reporting ETL) and other technology (Sharepoint Informatica Erwin Model Manager) * Provided production support for various production issues. * Provided supervisory advices to offshore DBAs and trained new associates.