SUMMARY

• Strong communication and interpersonal skills, the ability to prioritize and to make good sound decisions that benefit the company.
• Promote IT best practices that permit scaling up to an enterprise level operation.
• Proven track record for delivering projects technically and managerially on schedule and on budget.
• Built and maintained a solid relationship with the business.
• In - Depth knowledge of MS-SQL 2014/2012/2008 R 2/2008/2005/2000 and leading the world class SME DBA for MSSQL Server and Sybase.
• Managing both On-Premise and Cloud Windows Azure SQL Database SQL server instances Lead the team to design PaaS/SaaS Private Cloud infrastructure for SQL server databases.
• Manage large transactional database system multi-Terabyte in size
• Expert in HA/DR solution for High availability and recoverability of database in 24/7 environment by using clustering, replication, mirroring, LogShipping, backup/restore and Always on Availability group for sql2012 and up to meet RTO/RPO objectives.
• Expert in Installation, Configuration, and Administration of MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 as a Stand Alone and Cluster/Multiple instances on MSCS Microsoft Clustering Services VDBI/DBAAS Virtual Database Infrastructure Always On failover over clustering/ Always on Availability group and an experience with 4FRONT Methodology Plan, design, build, and implement integrated RDBMS System
• Expert in Logical Physical Database Design and Data Modeling Using MS-SQL native tools SSMS, Enterprise Manager, Visio, CA-Erwin.
• Extensive experience in Database object design including Table, Table/Index Partitioning, View, Trigger, Function, Stored procedure, Full-Text indexing and other database object.
• Expert in Data Transfer and Transformation using MS-SQL ETL tools SSIS/DTS, BCP, Bulk Insert to any OLDDB Provider like Oracle, Sybase, DB2/UDB, MS Access, Paradox, Excel, Flat File, XML and vice versa.
• Design, Maintain and Administration SQL server Integration Service SSIS packages including Migrating and Redesigning SQL Server 2000 DTS Package into SQL Server 2008/2005 SSIS.
• Install, Configure and Administration SQL Server Reporting Services SSRS / Crystal Report and Cognos.
• Expert in Database Backup/Recovery and Disaster Recovery Planning Documentation.
• Expert in Performance Tuning Query Optimization Using XEvent SQL profiler, DTA, DMV/DMF I/O Related, Execution Related, Index Related, Transaction Related and System Performance Monitor . As well as SQL server monitoring Tools SQL-Sentry for Performance and Event monitoring, IDERA SQL Diagnostic manager, SQL Defrag manager, SQL Secure, SQL mobile manager, SQL Compliance, SQL Safe, SQL Scalar, SQL Job Manager, SQL Config, and Quest Product LiteSpeed for backup and Restore, Change Director /SQL Watch, Spotlight / Performance Analysis, FogLight a product of Quest Family, VERITAS Net Backup, Backup EXEC.
• Extensive knowledge in Server Consolidation, Up-grading, migration and scalability of SQL Server 2000/2005/2008 RTM/2008R2/2012 RTM: Lead several project to upgrade from legacy SQL-2000/2005 to SQL 2008R2/2008RTM SP2 64bit on Windows 2008 64bit.
• Extensive experience in SQL Server Management Studio / Enterprise Manager / Business Intelligent Development Studio BIDS/SSIS, SSDT and T-SQL
• Extensive Experience in System Auditing SQL Server log, Windows Event Log and MBSA best Practice, PSS Diag, SQL Diag, PAL Analyze, Design and Maintain the Security Principal to protect SQL Server from threats/attack, SQL Server Injection, Virus warm and internal attack. As well as Configure and audit C2 Security Audit Level and Server-Side Trace to meet business and regulatory requirement.
• Extensive experience in the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements. Determining system impacts, as well as scalability and capacity analysis. Database planning resulting from database requirements.
• Extensive experience in Database Sizing and capacity planning. Performing the physical database coding for administrative duties including general support issues. Experience in database support involving database utilities. Responsible for setup and test of database utilities as needed in the production environment. Database backup and recovery for production and development environments. Database Backup and Recovery requirements and analysis to understand the operational aspects. Database replication to and from other offices fixing replication errors, and adding/modifying replication objects.
• Design and implement Custom DBME Database maintenance engine for Custom Database maintenance and Client Initiative Netbackup using SQL agent job Replace Control M job to do the Netbackup sql agent .
• Designing and Implementation of data warehousing solution which includes Building an OLAP database, creating data source, Defining the dimensions dimension levels, Building up Cube, assigned fact table in cube, Optimizing an OLAP database with aggregation partitions also Designing of multidimensional tables, cubes and fact tables in OLAP on SQL 7.0/ 2000/2005/2008 /2012
• Handled 10mb to multi-Terabyte database.
• Programming in PowerShell, T-SQL, PL/SQL, SQL-PLUS ORACLE, .Net Framework, Asp.NET, ADO.NET, VB.Net, C-Sharp.
• Complementary front-end Visual Studio, MS-Access experience as Senior Programmer/Analyst includes full project life cycle of Client/Server desktop and web applications developing as well as objects oriented programming and technologies Visual Basic, Access, C Sharp
• Administration of Windows win2k12/win2k8/r2/Win2k3 Including Active Directory Management, Group policy administration, User Account maintenance and support.

Professional Experience:

Confidential

Database Management Lead

• Managing SME DBA team member who provide the support for End to End Plan, Design, Build and support for Mission critical application. When continue with Manager role work as SME for mission critical application, Assists to perform day to day database system administration, including: daily checklists, backup verification, log review, security maintenance, performance tuning analysis, indexing, updating statistics, etc. .
• Provide training and guidelines to other team member who need help to resolve the critical issue, Engineered and implement Database Security standard Best Practice for large global database teams, coordinate security Risk assessment and remediation strategy to strike the right balance between regulatory compliance and business requirement. Direct interface with internal/external risk and audit team.
• Partner and Coordinate with Business, Application Development Team, Vendor and service provider to deliver and support the mission critical application database infrastructure.

Confidential

Database Management Lead

• As a Database Management Technical Lead, Working in team environment and technical resource /point person for any Database related technical question/issue/ and remediation supported by the TS-TI DBA Team/Tower SQL/Sybase . This includes but not limited to installation, configuration, upgrades, performance monitoring, managing replication/mirroring/log shipping, diagnosing system problems, disaster recovery, testing, Implement, support, and maintain Database engine/tools.
• Developed, implemented and promoted Database standard operating procedures, best practice and security module to compliance and meet with firm approved standard. Participated for any High priority issue/call, CSA/ Phoenix action plan review and plan for remediation the issue.
• Designed/Reviewed, Tested, approved, and adopted the new security/standard/best practice provide by GTI/Approve group and train team member to implement/adopt new standard and technology. Reviewed the Database system before go-live PRR Process and help SME/Team member to remediate any Standard/Security/Audit related issue to be compliance with Firm approved standard. Participated on Operations Procedure Book OPB review, help and provide the details for SME to include database operation process on the OPB documentation. Interface with Microsoft Engineers regarding best practices, standards, and support issues as well as other Vendor/Support team including Symantec, Netback. In all aspect lead the team and To-Go place for any Database related Standard, Best practice, Security, Audit, ESM, Backup, GTI Build, and any other Database related technical question and support. Lead multiple project to upgrade from legacy system to sql2k8R2/RTM SP2, and perform all aspect of Server/environment build.
• Designed, implemented and supported Custom Database Maintenance Engine DBME for schedule database maintenance and Client initiative Netbackup solution.
• Engineer business intelligence architecture and standards including SQL Server Reporting Services, Analysis services, and Integration services
• Engineer SQL server database event and performance tools including SQL Sentry.
• Serve as liaison to the Global Technology Infrastructure team for standards and processes including hosted databases services VDBI/DBAAS and backups.
• Design, Build and Implement the EidRS Emergency ID Request System under the Break Glass Technical Strategy for TiS Data Services which is now adopted by entire firm. The core functionality of EIDRS is to securely store privileged account password and associated account with the list of approved individuals permitted to request account. Privileged access to highly critical databases needs to be monitored. For this reason, individual accounts are created for members of the DBA group supporting these database, with sufficient privileges to carry out their daily routines.
• Design the Technical requirement for EURC Request System for Database Account For SQL, ORACLE, and SYBASE RDBMS.
• Design the technical and functional strategy for Central Account Repository System to meet the Audit requirement and Regulatory compliance SOX .
• Coordinate and Design the Functionality for EAA Enterprise Access Administration Team. The Risk Controls Policies mandated by JPMChase Risk Management require that the Access Administration Functions for databases are segregated from the Operational Functions. To allow for this segregation for the databases supported by TSS the Access Admin functions are being segregated out to EAA group.
• To ensure that the Access Admin team has sufficient privileges for their work, and no more than that, TSS has created a Functional Layer to carry out these tasks Including Script, Client Installation Connectivity, and Training for IMSD team member to perform Access Admin Responsibility .
• Design and Implement the Several SQL script to meet Regularity Compliance Audit requirement for SOX application.
• Prepared the Technical and Functional Document for SQL server infrastructure TSD/iSor as well as Training materials to support New Security Implementation and train relevant groups.
• Actively instructed and guided Primary DBAs to implement new DB Security policies and prepared the Implementation Verification report.
• Researched the difference between SQL 2000 and SQL 2005 and found a way to customize the SQL functionality for Custom DBA Role ROLE DBA BASIC, Access Administration, EIDRS functionality, Audit, Risk Control.
• Reviewed and evaluated CAIM CA Identify Manager tools for different RDBMS, including SQL Server, Oracle, and Sybase .
• Symantec Enterprises Security Manager ESM: DB Agent installation configuration, mapping the Agents with ESM Manager, Revise the ESM policies used to measure compliance to the DB Security Standards, running the Security scan and generate Security Report for Database instances. Evaluate the Security report and provide the solution to proper configuration for Security Vulnerability remediation and to meet the compliance.
• Reviewed and researched several Database access related issue, and Assist the Primary DBAs to resolve the problem with proper solution.
• Used several internal business support applications: GARS Global Access Request Services, EURC End User Request Center, Peregrine. Enterprise Change Management ECM . PAR and Bee-Line Time Entry system.
• Participated with CUE Compute Utility Engineering team to design new GTI engineered build process for MS-SQL Server 64 Bit installation and configuration.
• Designed E-dashboard using Classic ASP and SQL server to track the status for each Project/Task assigned to the individual resource.
• Installed and configured the SQL Server including both 64bit 32bit engineering build on Lab QA Server, Applying Service pack and SQL Server Compliance / Security script, before implementing on the Production Dr Server.

Confidential

Sr. DBA / Web Developer/ Programmer / QA / Tester

• Worked as a SQL server DBA/Developer and performing the following assignment: Installation configuration SQL server 2000/2005, Applying Service Pack and Patches, Managing User Role and Privilege, Configure Transaction Merge Replication for Data distribution, Configure Transaction Log Shipping for the part of disaster recovery Planning, Performing Backup/Recovery for off-site server for Reporting purpose, Schedule job to perform different database Maintenance plan, Optimizing performance tuning, as well as Developed a web based application dashboard for Management Review of critical quality metrics utilizing classic ASP, MS SQL Server 2005 and Reporting Services Designed Stored Procedure, Trigger, Function and other database object like table, View

Confidential

• Worked as a DBA/ Developer/ Code reviewer and perform the following task: Labware LIMS Basic code review, development.
• Developed and executed test scripts Using LIMS Basic Visual Basic .
• Updated documentation.
• Executed tests scripts.

Confidential

• Analyzed requirements for multiple projects, develop Level of Effort estimates, participated in small cross-functional teams, worked with on-shore and off-shore resources worked with users to become familiar with Patron Database PDB system.
• Created and executed functional and regression test scripts. Wrote SQL queries against Informix and MySQL database. Run shell scripts on AIX and Linux system.
• Tracked defects and documented test cases in Test Director.
• Worked with programmers to identify and fix issues and re-test defects. Used Mercury Load Runner to perform load test.
• Designed the Virtual Command Center application Dashboard for GO-Live activities to better manage deployment activities setup and test the conversion environment to import data from Caesars system to Harrah's PDB WINet System including load and unload code, tables, static table, setup the LUID range for new property, backup database ran different business scripts to post the data from Caesars environment to Harrah's, Including mock load, Initial load, Incremental load and final load corrected the problem/error at the time of data posting unload data from test environment to transfer into production environment .

Confidential

• Build, configure and maintain MS SQL Server 2005/2000 servers.
• Install, upgrade, patch, administer, tune and monitor MS SQL servers and other RDBMS.
• Implement and manage the data dictionary database replication, backup/ restore and disaster recovery planning and implementation.
• Developed database standards, procedures and architecture base on customer requirements data modeling and database loading BCP, Bulk Insert, SSIS .
• Created and troubleshot stored procedures, trigger, job and SSIS package migrated other RDBMS Paradox 9 Database, Access to SQL 2000 or Oracle 8i.
• Developed web-based application with .NET framework, ASP.NET, XML, Ajax for use via PC, Tablet or Handheld devices.
• Supported UAT, functional test case development and testing

Confidential

• Build e-commerce platform for web and PDAs using .NET framework, ASP.NET, Ajax, MS SQL Server 2005, ADO.NET, XML, which required a detailed understanding of the retail environment and complex business logic.
• Wrote queries, scrubbing data from outside vendors and importing the data.
• Developed stored procedures and used XML and/or FTP to acquire data.

Confidential

• Designed, built, tested and implemented custom forms, ASP.NET and JavaScript for MS SharePoint Portal with WebParts, supervised development teams, .
• Web reporting Crystal report 8.5, Cougar Mountain Report Writer for Windows.
• Developed eBusiness solution:.
• Developed manual test cases and conducted testing E-Commerce solution for online shopping cart Using Actinic Catalog, Linux, MySQL, Online Credit card application system for Chase Manhattan Bank - WinRunner Test Director.