SUMMARY

• Around 20 Years of IT experience in all aspects of data, IT management, including data modelling, ETL, OLTP/OLAP management, warehousing, migrations, storage technologies, and application development.
• Strategic planner who implements solutions to increase availability, streamline migrations, and optimize performance.
• Articulate communicator and respected leader who collaborates cross - functionally and motivates team members to prioritize tasks in order to consistently deliver projects on time and budget, exceed set goals, and advance organizational objectives.
• Multiple years of experience as Technical Project Manager (TPM) / Sr. PDBA wif proven ability to articulate business values.
• Expertise in business transformation through technical and financial process design and improvement.
• Proven track record in maximizing resource utilization and delivering projects in Banking & Finance, E-Commerce, Manufacturing, and Marketing sector.
• Expertise in planning, leading, organizing, and motivating project teams members to achieve a high level of performance and quality in delivering projects.
• Experience understanding and advocating stakeholder needs, facilitating communication, project planning and management, ensuring dat stakeholder expectations are met, and anticipating dependencies for other functional teams.
• Experience managing complex deliverables while effectively using concepts and brand objectives to resolve the tasks in creative and effective ways to meet schedules and goals.
• Strong understanding of information technology capabilities and dependencies, including platforms, content management, mobile applications, e-document strategies and process mapping.
• Excellent communication, people skills, project management capability, and the ability to successfully influence and drive consensus across cross-functional teams.
• Expert in Sybase Adaptive Server Enterprise, Sybase Replication Server, Sybase IQ and MS SQL Server.
• Experience in Sybase ASE/Sybase Replication / MS SQL Server installation, up-gradation, configuration, and performance tuning.
• Managed Software vendors and Year end regulatory upgrades and security. Coordinated Emergency Incidents and managed escalations. Worked on database auditing and enterprise wide auditing. Disaster recovery planning and implementation for 30 plus applications. Single point contact of Modernization and Upgrade from Solaris to Linux.
• Experienced wif L1, L2, L3 support; Incident Management; Change management Capacity Management, Problem Management, Post Problem Resolution.
• Experience in supporting multiple production database servers in a 7X24(7 days a week, 24Hrs a day) environment. Excellent communication and interpersonal skills. Excellent Organization, Analytical and Problem-Solving skills and ability to quickly learn new technologies
• Awarded as a Most Valuable Contributor (MVC) at Confidential .
• Achievement award in recognition of the excellent contribution at LEHAMN Brother’s (TIS leadership recognizes dis accomplishment - TIS Best Performance Award).

TECHNICAL SKILLS

Languages: SQL, T-SQL, COBOL, PL/1, JCL, CICS, Unix Shell script.

RDBMS: Sybase Adaptive Server Enterprise, Sybase Replication Server, MS SQL Server, Adaptive Server IQ

Systems: Windows, UNIX, IBM AIX 4.x, Sun Solaris, Linux

Tools: /Apps: DBArtisan, ERWIN 3.0/3.5, PC Anywhere, SQL Backtrack, Sybase Central, DTS, SQL Enterprise Manager, Remedy Ticketing, AUTOSYS, Symantec In-depth, me-watch, Quest Foglight, Microsoft SharePoint, SharePoint 365, MS Visio, Microsoft Word, Power Point, Excel.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Led cross-functional, global, and virtual technology teams, including a team of senior DBAs, while acting as an individual contributor on several major projects and BAU efforts in collaboration wif leaders and partners
• Developed and managed project plan, including budget planning, resource planning and scheduling.
• Planned, executed, and finalized project wifin triple constraints of delivering on time, wifin budget and scope objectives, including acquiring resources and coordinating efforts of team members.
• Managed changes to scope and budget through change request and used Remedy for approval process.
• Worked wif the business units to document, develop and enhance their processes as well as identified opportunities for improvement.
• Provided status reports, including identification of critical issues/obstacles and resolutions, to the Program Management Office.
• Tracked and reported project status to management through weekly project metrics (hours estimated vs. burned, cost burn down chart, project progress, risk/ issues and possible mitigation).
• Managed scope, resource and budget changes, integration wif other projects, 3rd party vendors to better control internal & external project dependencies.
• Responsible for administration, planning, migration and execution of ASE and replication servers.
• Identifying and fixing performance issues after upgrades, Configure data server for optimal resource usage. Identify optimizer changes and enhance server performance
• Performed in demanding database/IT roles wif contributions to operations, GMRT support, standardization, upgrades, patching, DR/WS/replication management, performance tuning, hardware & storage architecture, monitoring, automation, retirement & migrations, consolidations, backup & recovery using SAP Sybase ASE, REP, IQ and MS-SQL Server database technologies
• Enterprise Audit DBA for SOX/PCI and other Audit priorities and deliverables wif Global Information Security partners. Led significant efforts to remediate 98 % of violations and maintain database environments compliant. Scripting of SAP Sybase -ASE, IQ, MS SQL Server audit checkers, Identity and access management. Evaluated and piloted Intrusion detection and audit tools like Guardium and Symantec ESM. Key contributor to Database baseline and standards.
• Projects for Automated build, patching, configuration, deployment, service catalog, Discovery, and asset management. Implemented ITSM BMC Remedy, SRM, BDA. Significant project for enterprise database release management -HPDMA
• Key contributions to holistic IT & Database monitoring, job scheduling and scripting. Implemented Quest Foglight for SAP Sybase -ASE, IQ and MS SQL Server. Contributed to IPSoft-IPCenter, other automation efforts

Confidential, NY

Lead DBA

Responsibilities:

• Manage and coordinate the activities of projects and application support teams, consisting of onshore/offshore team members.
• Fulfill project technical lead or project management role on assigned projects where applicable.
• Lead and manage high performing team consisting of onshore/offshore outsourced application support groups.
• Managed issues and project work to meet Service Level Agreements (SLA).
• As the primary DBA for several business clusters (Treasury, Data Services over 100 GB, Consolidation Replication), work wif replication both warm standby and subscription based.
• Provide support for Production, Integration and Development servers. Provide on-call and hotline support
• Installed, Configured and Maintained Sybase Adaptive Server and Sybase Replication Server.
• Involved in Up-gradation of Sybase Adaptive Server Enterprise and Sybase Replication Server.
• Designed the distributed environment by using architectures supported by Sybase Replication Server. Identified tables/columns dat need to be replicated from primary to replicated database.

Confidential, Florida

Responsibilities:

• Business Analysis and Requirements Gathering.
• Involved in Prototyping and Functional Specifications.
• Responsible for maintenances and 24*7 availability of Cognos Server, Analysis Server, Web Server, MTS Server, SQL Databases Server, SAS Server, Argent Scheduler, Control-M Server.
• Identified the Sources, Analyzed the source data, involved in designing the data model.
• Transfer of large volumes of data using Bulk copy program (BCP) and Data Transformation Services (DTS)
• Created the Stored procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Troubleshooting and performance tuning of SQL Server and applications.
• Involved in Data Mart, Data warehousing.
• Responsible for Implementation of all SQL Database design and deployment including Capacity planning.
• Implementation of various Data Transformation Packages and required Batch for periodic updates.
• Validated and process scripts against all changes and updates on databases.
• Created all OLAP/ Transformer Cubes and was responsible for optimization of all the cubes.
• Responsible for maintenances and fine-tuning of all Databases dis consisted of over 250 gigs of data and over 25 databases.
• Provided Disaster recovery procedures and policies for restore and backups of Databases
• Implement required optimization and fine-tuning of databases using SQL Query analyzer, SQL Profiler and Performance tools for optimization of Server.
• Extensively use of Monitoring Tool Quest Spotlight on SQL Server for Current activity, logs, Space on server, Disk, Memory & CPU utilization.
• Reviewed and deployed all web related applications and applicable components.
• Deployed and maintained all Microsoft Transaction Server COM/DCOM components.
• Production environment design and deployment dat includes capacity planning, system sizing and modeling future requirements.

Confidential, GA

Sr. Sybase DBA

Responsibilities:

• Installed, Configured and Maintained Sybase Adaptive Server and Sybase Replication Server.
• Involved in Up-gradation of Sybase Adaptive Server Enterprise 11.9.2 to 12.0 and Sybase Replication Server from system-11 to system-12.
• Designed the distributed environment by using architectures supported by Sybase Replication Server. Identified tables/columns dat need to be replicated from primary to replicated database.
• Creating replication definitions function strings and subscriptions for the distributed environment.
• Design and Implementation of Sybase replication server Warm Standby Technology.
• Involved in troubleshooting replication problem and finding resolutions.
• Wrote scripts to store inventory information of the files dat were loaded into the system including the size of the file, the date of load, market the file belonged to into an inventory table. Also wrote scripts to query and get inventory information based on some criteria.
• Wrote queries to insert data into an archive database from the production database and maintained the archive database. Monitored the growth of the production and archive database.
• Migrate database from Sybase Adaptive Server 12.0 to Oracle 8i using migration tool and DTS.

Confidential, CA

Responsibilities:

• Installed, Configured and Maintained Sybase Adaptive Server 11.9.2/11.5
• Wrote queries to insert data into a Historical database from the production database and maintained the Historical database. Monitored the growth of the production and Historical database.
• Organizing and updating statistical information of all the indexes to ensure proper query optimization. Writing stored procedure and triggers to ensure business rules and integrity.
• Extensively involved in data Migration from various sources like Mainframe (VSAM), MS-SQL Server, and MS-Access to Sybase database for reporting purpose. Creating and scheduling data migration process using Shell script and BCP utilities.
• Documentation of Migration and fixing data corruption.
• Resource Management: Creation of database devices wif optimum utilization of an available resource (On UNIX raw partition was made for Sybase installation as recommended by SYBASE). Mirroring of devices was done to recover important database due to suspect on primary database or when primary database was not loaded.
• Configuring parameters: Configure various parameters in Sybase Adaptive Server for more throughput like Cache manager, Network, Memory, Lock manager etc. These values were configure using “sp configure” system stored procedure and also in “. Cfg” (configuration file) was used to manipulate these values.
• Login and User Management: Adding logins, roles, and groups to the Sybase Adaptive Server and maintaining proper security procedures.

Confidential

Responsibilities:

• Installed, Configured and Maintained Sybase Adaptive Server 11.9.2/11.5
• Wrote queries to insert data into a Historical database from the production database and maintained the Historical database. Monitored the growth of the production and Historical database.
• Organizing and updating statistical information of all the indexes to ensure proper query optimization. Writing stored procedure and triggers to ensure business rules and integrity.
• Extensively involved in data Migration from various sources to Sybase database for reporting purpose. Creating and scheduling data migration process using Shell script and BCP utilities.
• Documentation of Migration and fixing data corruption.
• Extensively involved in writing stored procedure, triggers and view. Also wrote some SQR reports based on user request.