SUMMARY

• 12+ years of experience in the IT Field. Performed various roles, such as Service Engineer, System Administrator, Database Administrator and Database Developer.
• Started my career as a Desktop support/Hardware Engineer and from then on gradually transformed to a System Administrator and then on to Database Administrator career.
• Extensive experience in Production Database Administration, over 7 years in Financial/Banking Domain.
• Experience in managing a Team for 24X7 support.
• Extensive noledge of Various Database Installation, Configuration, maintenance and troubleshooting.
• Wide exposure to production database maintenance, alerts monitoring.
• Good noledge of Sybase, Sql database concepts, development and administration.
• In - depth noledge and hands-on experience in backup and recovery.
• Experience in migration of Databases across datacenters.
• Provided support dat included resolving day-to-day operational issues with tickets generated by a server.
• Experience in documenting and preparing the process related operational manuals.
• Good noledge in High Availability systems like clustering, RAC.
• Hands on experience in configuring and troubleshooting Windows Active Directory Services, group policies.
• Experience in installing and configuring NAT, DHCP server and DNS in Small networks.
• Hands on experience in configuring and troubleshooting Desktop systems, printers, local networking.
• Experience in troubleshooting both connectivity issues and hardware problems on both Windows and UNIX systems networks.
• Experience in troubleshooting a variety of problems. Streamlined and improved process to be quicker to market, ensured compliance and optimized operational efficiency. Identified opportunities for continued improvements of process to ensure maximum output.

TECHNICAL SKILLS

Operating Systems: Windows Server family and RHEL, IBM AIX,HP-UX, Sun Solaris

RDBMS versions: Sybase ASE 15.5/15.0.3/ 12.5. X, MS-SQL 2005/2008/2012 , Oracle 12c/11g/10g

Tools: DBArtisan, Sybase central, SCC, SSMS, SQLPlus, RMAN, OEM, TOAD

Programming: SQL, T-SQL, PL/SQL, shell scripting, power shell

Networking: LAN, WAN, TCP/IP, DNS

Hardware: SUN, HP, IBM

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM

Ticketing software: HP Service Manager, Virtual Ticket, Virtual Request, Support Manager Ticket

PROFESSIONAL EXPERIENCE

Confidential, Norristown, PA

Senior Sybase DBA

Responsibilities:

• Provide 24/7/365 support of Sybase ASE, Replication Server, MS-SQL, MySQL and Oracle.
• Maintenance of Production, Testing and Development Servers, ensure the availability of the production databases to end-users in a 24x7 environment and development databases to developers.
• Participate in database development, tuning and optimization expertise to application development and support teams on an ad-hoc or continual basis.
• Proactively monitor all database systems utilizing vendor supplied and Client standard tools.
• Ensure dat all Databases are backed up and monitored according to the business requirements and notify the data owners when there are failures.
• Coordinate requests of server resources with the server Systems Administration teams
• Maintain top-notch technical skills and financial business noledge through proactive self-learning in addition to any formal instructor-led training provided by Client.
• Interface with external vendors in troubleshooting complex, cross-platform issues.
• Cross train members of the Database team in all responsibilities and maintain a daily and weekly rotation schedule for these.
• Maintains database integrity by enforcing organization standards.
• Maintain complete inventory, config and documentation of deployed systems.
• Conducts database performance and tuning and other related investigative tasks to troubleshoot database issues.
• Performing weekly/monthly maintenance of production servers. (Recycling)

Environment: Sybase ASE, MS-SQL, MySQL, Oracle.

Confidential, Warren, NJ

Senior Database Developer

Responsibilities:

• Requirements Analysis for new automation development.
• Design and Development of new DBAMAINT Package.
• Upgrading the existing package as the databases are advancing technically.
• Unit, Integration and System Testing.
• Development and UAT deployment.
• Post production Support such as Bug Fix and enhancements.
• Attending to Primary/Secondary DBA queries/issues. etc.

Environment: Sybase ASE, Sybase IQ, Oracle, MS-SQL, MongoDB.

Confidential, Tampa, FL

Senior Sybase DBA

Responsibilities:

• Provide 24/7/365 support of Sybase ASE, Replication Server and IQ systems.
• Coordinate with DBMS vendor support services regarding database problems and issues.
• Perform and maintain database backups, recovery, and refreshes.
• Escalate problems and situation management and undertake root cause analysis on situations or major incidents.
• Create and maintain database interconnectivity and replication.
• Coordinate with Application Development/Production Support teams on creating and maintaining user access, roles, and privileges.
• Identify long running transactions causing tempdb filling issues and to minimize tempdb contention.
• Checking the consistency of databases using dbcc commands, dbccdb database and dbcc stored procedures.
• Applying production builds.
• Create and maintain database interconnectivity and replication.
• Maintains database objects (tables, views, indexes, foreign key constraints, etc.) based on analysis of application requirements.
• Contributes to team effort by accomplishing related results as needed.

Environment: Sybase ASE, Sybase IQ, MS-SQL & Oracle.

Confidential

Senior Technical Specialist

Responsibilities:

• Providing L1 support activities for all Trading database systems, including the provision of 24x7 on-call support (problem/incident management).
• Adding /dropping users to Databases.
• Password resets and unlocks with user concurrence only.
• Modifying existing users.
• Adding/removing groups.
• Granting/Revoking roles and permissions for users and groups.
• Fixing orphan users.
• Aliasing the users on request.
• Quarterly and semi-annual user entitlements.
• Executing the scripts provided by the developers on request.
• Extracting flat files from Databases and provide to developers on request.
• Acting on EERS bulk requests on daily basis.

Environment: Sybase, MS-SQL & Oracle.

Confidential

System Administrator

Responsibilities:

• Assembling and installing configuring Desktop Systems, Upgrading.
• Performed Windows server administration, desktop support and network maintenance.
• Managed user accounts and group policies for users belonging to various accounts using Active Directory server.
• Managed Internet Information Services (IIS), Mail servers, File servers, DNS and DHCP servers.
• Installed and configured NFS server, Samba Servers, Web servers, RAS etc.
• Worked on windows Active Directory Services, Implemented Domain and Work groups.
• Implementing Backup and Recovery.
• Worked on monitor and troubleshoot various issues in the systems (software and hardware).
• Worked on Application Package installations, patching, Anti-virus Install and updating.
• Worked on issues related to LAN, Network printers, scanners, static and dynamic IP addresses conflicts.
• Created diagrams and proper documentation for the Systems configuration and setup.

Environment: Windows and UNIX.

Confidential

Service Engineer

Responsibilities:

• Assembling and Installing Desktop PCs, Upgrading.
• Attending Desktop and Laptop calls.
• Installing applications like Anti-virus softwares, Microsoft Office etc.
• Installed and configured Modem for Internet etc.
• Worked on troubleshoot various issues in the systems (software and hardware).
• Worked on issues related to LAN, Network printers and scanners.
• Perform maintenance activities for the customers/companies enrolled in Annual Maintenance contract.

Environment: Windows and UNIX.