SUMMARY:

• 12 Plus years of IT experience spreading across Food and Beverages, Banking and Insurance Industries in 24X7 environment
• Strong skills in MS SQL Server database installation and administration.
• Strong skills in Sybase ASE, Sybase Replication Server, database installation and administration.
• Extensive experience in Banking industry - Possess good knowledge on Foreign Exchange, transaction Services, Fixed Income and Money Market.
• Database Administration
• Operations Management
• Troubleshooting
• Process Optimization
• Research & Analysis
• Strategic Planning
• Interpersonal Skills
• Mentoring & coaching
• Organizational Skills
• Detailed Documentation
• Change Management
• Synthesize diverse ideas
• Technical Knowledge
• Performance Testing
• Client Support
• Unique blend of technical & business knowledge
• Project Management
• Personnel Management
• Installation and configuration of Sybase / 15.0/12.5/11.9.2 in UNIX (Sun, AIX) and Windows NT 2000.
• Installation and Administration of Sybase Replication Server 12.6
• Database Administration tasks - User Management, Security, Backup/Recovery, Performance Tuning, Migration, up-gradation and Log shipping setup
• Capacity Planning.
• MS SQL Server 2014/2012/2008 design and administration.
• Resource & Cost estimation.
• Negotiation skills on SLA with business.
• Risk identification and Mitigation.

TECHNICAL SKILLS:

Hardware Platforms: HP 9000, Sun E4800, IBM R30, NCR S26/S40, Compaq Proliant 2000 in RAID, Micron PC Server, Dell PowerEdge.

Operating System: HP UNIX 10.20, NCR (AT&T) UNIX Release 4 System V, AIX 4.2 SCO UNIX 3.0/5.0.5, Sun OS 5.7, Linux 7.1, Windows 2003, Windows 2012, Cloud VM.

RDBMS: Sybase 11.9.2/12.5/15.0 , Replication Server ASE 12.6, MSSQL Server 2012, 2014, Oracle8i.

SQL Server Tools: SQL Server Manager, Sybase Central, SQL Advantage, Enterprise Manager, DB Artisan, SYSMON, BMC SQLBackTrack.

Development Tools: PowerBuilder 6.5//5.0/4.0, Visual Basic 6.0/5.0

Languages: T-SQL and Unix Shell Scripts.

PROFESSIONAL EXPERIENCE:

Confidential, Irving TX

Sr. Database Administrator

Responsibilities:

• Project and Production DBA for Confidential SQL support across the Globe.
• Escalation DBA
• Planning for migration/upgrades with system architects and application team
• Designing new Database environment depending upon business requirements
• Planning and Designing HA and DR depending on application criticality
• Coordinating the work with offshore
• Defining scope of project works
• Transitioning SQL server legacy environment across to worked to Global Support
• POC for new project discussions
• Primary point of Contact for 600 plus instances
• Planning for migration/upgrades with system architects and application team
• Coordinating the work with offshore
• Troubleshooting performance issues using SQL Profiler/Toad
• Remediating vulnerabilities on the basis of Gaurdium Report
• Monitor virtual servers using vsphere
• Configuring and monitoring using MDW
• Frequent Access validation
• Architecture level designs for critical application database environments
• Approving access requests on the basis of business requirements
• Understanding business criticality and defining the high availability strategies
• Planning and implementing backup strategies considering the Recovery Point Objective
• New SQL instances installation/service pack installation using Internal Confidential Tools
• Database performance/activity monitoring using SQL native tools, Toad, SCOM
• Database upgrades- In-Place and Side-by-Side
• Troubleshooting Transactional Replication and Log Shipping
• Coordinate and drive DR drills
• Troubleshooting SSIS,SSRS and SSAS issues
• Point-In time Recovery
• Planning Database Maintenances

Confidential, Irving TX

Sr. Database Administrator

Environment: Production support. Investment banking RDBMS - Sybase, SQL Server OS - Sun Solaris, Unix, Windows

Responsibilities:

• Participated in the install and setup of HP monitoring framework for SFS applications.
• Created detailed spreadsheets for tracking DBA build workflows and projects then relayed to the DBA team.
• Identified risks related to server changes, incorrect collations, security, maintenance jobs and scheduling.
• Responsibilitiesinclude builds, maintenance, business continuity, and troubleshooting of production SQL Server environments.
• Managed database migrations for several datacenter server relocation projects.
• Providing technical knowledge and support for application, developer, and project teams.
• Isolated and resolved issues improving overall performance and stability.
• Troubleshooting with vendors and application teams.
• Utilized CATE scripts to build nightly automated refresh process
• Troubleshoot and installed SSIS packages for developers in all regions.
• Replication setup from instance
• Server to the new version.
• Also perform Activities like install the SQL Server Security Hot fix, Patch to the sql server.
• Setting up Logshipping/Mirroring from PROD to COB servers.
• Checking of Database space by running command like (sp spaceused, sp segmentused) and taking appropriate measures to solve the same.
• Creation of Databases and devices.
• Monitoring Error logs and taking preventive measure thereon.
• To perform various administrative activities pertaining to Databases and Performance like running DBCC, Update statistics and REORG.
• Installation of DbccDb for Running DBCC.
• To co-ordinate with Data center Operators to monitor the database jobs (AutoSys, Crontab job’s) and solve them in Case of Error’s.
• Installation of Replication Server and setting up Database Level replication.
• Monitoring and Maintaining the Replication Services 12.5 & 12.6 Version.
• To install new ASE server’s and to upgrade the ASE to new version.
• Coding & fine-tuning as Quality Check for the best results.
• Co-ordination with Developers to include modifications in the D/b in the form of DDL Deployments (SQL statements, Procedure, Indexes) for performance & Business enhancement.
• Creating and maintaining various DB maintenance jobs for smooth working of DB/Servers through SQL agent/Autosys and Crontab for Sybase.
• Dump and load of databases using SQL BackTrack, troubleshooting for Database Objects
• Maintaining and enhance supporting documentation.
• Db Syncing Activity for BCP and Disaster/recovery test.
• Participated in the DR TEST.
• Generating Report for Audit Purpose using (ISScanner Tool)
• Also monitoring the alerts and solving the Alert’s Through BMC Patrol and other 3rd party Software’s.

Confidential

Database Administrator

Responsibilities:

• Creation of Databases and devices.
• Checking of Database space by running command like (sp spaceused, sp segmentused) and taking appropriate measures to solve the same.
• Monitoring Errorlogs and taking preventive measure thereon.
• Optimization of queries.
• Co-ordination with Developers to include modifications in the D/b in the form of DDL Deployments (SQL statements, Procedure, Indexes) in the form of Fixes and builds for performance enhancement.
• To perform various administrative activities pertaining to Databases and Performance like running DBCC, Update statistics and REORG.
• To co-ordinate with Data center Operators to perform weekly/monthly DB maintenance activities like DBCC, Update statistics etc.
• Creation of User ids for the Users Through DBArtisan and other Front End Tool.
• To interact with users to solve performance related problems and ensure smooth running of system.
• Coding & fine-tuning as Quality Check for the best results.
• Creating and maintaining various DB maintenance jobs for smooth working of DB/Servers.
• Monitoring and Maintaining the Replication Services 12.6 Version.
• Creation /modification of users, granting and revoking rights on DB level.
• Interacting with the Application Person for designing the database as per the application E.g. Webpos
• Also Took part in BCP and DR Drill.