| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLEPHONE NUMBER AVAILABLE (cell)At preset working as Software Engineering Release Coordinator and taking care of Change tickets and Releases of Walgreens. We are supporting Two Scrum Masters following scrum procedures for four applications and managing Change, Incident and JIRA tickets. We also have in-house software tools which we use to manage releases and change processes.Summary:Over All 23 years of IT experience, of which and more than 20 years as Sybase DBA in USA, Sybase System administrator, Sybase Replication Server DBA. Have excellent analytical and communication skills to manage projects. I was involved in logical and physical database modeling and performance and tuning skills.Over 14 years working as Senior Database Specialist at Voya Financial Services (ING Financial) located at West Chester PA. I have migrated Sybase ASE 11.9.2 to 12.5 in Windows environment in 2005, designed replication environment in 2006, Migrated Windows environment to Linux environment in 2009 also migrated version of Sybase ASE from 12.5 to 15.0.3 and in 2015 Migrated Sybase from 15.03 to 15.7 sp139 and Sybase replication 15.7.2, and we have migrated few servers to 16.0. In August 2019. Also worked on Building Oracle Exadata databases on Linux servers.TECHNICAL SKILLS:HARDWARE: HP x86_64 GNU/Linux Physical and Virtual servers; Sun Sparc, IBM Server,Operating System: Red Hat Enterprise Linux Server release 6.9, Sun Solaris 5.8, Windows 2012 Server.Languages: Dbase IV, FoxPro 2.0/2.6, C, T-SQL and MS Access 2000.RDBMSSybase System 10/11/11.5/11.9.2.2/12.0/12.5.3, 15.0.3, 15.7 sp139, 16.0Oracle Enterprise Server 7.1, 8.1.6, 8.1.7, 9.2, 12.01MS SQL Server 6.5/7.0/2000, 2008Development Tools Sybase, TSQL, Sybase Central, Platinum Desktop DBA (Sybase front end DBA tools), Embarcadero DB Artisan 4.0, 5.1, 5.3,5.4, 9.6.1, Pro Active DBA, Platinum Erwin, Oracle, PL/SQL 3.0, Database Administration Tools, Power Builder 4.0/6.5.Service now: for creating Incident tickets, Change tickets, internal It Requests and also maintaining CMDB certifications.Foglight: This is a Quest Tool for server alerts and crating Database server performance reportsHas extensive experience in database design & implementation, development, administration and maintenance of Sybase databases under Unix Platforms (Sun Solaris on Sun Sparc, HP-UX on HP machines, good working knowledge of HP-UX, SCO-Unix, Digital Unix, Windows NT server, Win 2000), Windows 95/98, Windows 2007,Windows 10 . Writing scripts in Korn shell.Areas of Strength in SAP ASE:SAP ASE DBA Activities, creating Devices and Databases, performance, Turning of Sybase SQL Server. Used Erwin Data Designer Tool extensively for Logical and Physical data designer, writing stored procedures and triggers, well conversant with all Sybase command language from ISQL prompt, Power Builder Programming, Implementation of Application modules like, Purchase Order Generation, Branch Sales, Raw Material Management System, Financial Accounting, Fixed Deposits, Housing Loans (Mortgage), Real Estate Business, Human Resource Development, Engineering & Sourcing. Also has knowledge of Credit derivatives applications. Most of the applications, which I supported, are based on OO, web based applications like Java, C++.Excellent knowledge of Sybase architecture including physical and memory structures.Install and Configure Sybase SQL Server (ASE) on Linux, Sun Solaris.Installing and configuring Sybase Replication Server 12.6, 15.2, 15.7.1 on Windows 2013 and Linux serversSybase Database Server Upgrades with multiple versions. Sybase ASE Migrations.Can handle independently all the projects and critical server problems.Can configure and work on Component integration services.Installing Power Builder 8.0 on NT & 2000 Servers.Controlling and allocating disk resources, Capacity Planning for Very Large Databases.24/7 Production Support from Home and Work.Setting up of Backup ProceduresMonitoring, tuning and trouble shooting,Manage replication servers in distributed database environment.Regular backups of Database and Transaction LogsDisaster Recovery of Production Databases & Logs, Rebuilding of Master Database.Crash recovery management through standby databases.Deeply involved in Tuning applications for excellent performance.Daily Monitoring of Sybase SQL server for space usage, integrity, performance.Creating/Maintaining IndexesHas very good knowledge of Writing shell scripts korn shell.Sybase Capacity planning/Management.Sybase production/release management.Areas of Strength In Oracle:Installing oracle software on Windows 2008 servers, Sun Solaris and Linux serversUpdating Oracle Patches,Installing Oracle cluster servers on NT and Win 2000 Servers (Fail Safe)Oracle 8.1.7.30, 9i on Sun Solaris systems, maintaining Production, Test and Development applications.Creating Instances, schemas,Creating users for better security,Creating tables spaces, rollback segments.Table sizing for accurate storage.Tuning and monitoring Oracle Server24/7 production support.Has excellent knowledge in Configuring Servers for performance issues.PROFESSIONAL EXPERIENCE:1. Working as Release Coordinator for Release ManagementClient : WalgreensDuration : August 20th 2020 till dateEnvironment : BMC Remedy, Smart IT, JIRAProduction application, Data and infrastructure applications, Development and Sys Test environmentsCovering multiple application for 2 Scrum MastersScrum Team size: 8, 1 on shore and 1 offshore Release CoordinatorsAt present working as a Release coordinator covering multiple application and multiple environments. We also have in-house software tools which we use to manage releases and change processes. We process Data changes, Infrastructure changes and Application changes, to make sure all change processes are in place so that Release event wont bring down applications and Servers.2. Working as Team lead for Change Management/ Release ManagementClient : MetLifeDuration : January 17th 2020 till dateEnvironment : Service Now, RosterProduction application, Data and infrastructure applicationsCovering 64 applications for MetLife.Release Team size: 6 Release coordinatorsAt preset working as Software Engineering Release Coordinator and taking care of Change tickets and Releases of MetLife. Working as Team lead and from onshore. We are supporting for 64 MetLife applications and managing change tickets in Service now tool. We also have in-house software tools which we use to manage releases and change processes. We process Data changes, Infrastructure changes and Application changes, to make sure all change processes are in place so that Release event wont bring down applications and Servers.3. Senior Database Specialist:Client: Voya Financial, West Chester, PA.Duration May 23rd 2005 October 2019 (14 years 5 months)Environment: Sybase ASE 12.0/12.5.0.3,15.0.3, 15.7 SP139 Sybase Replication 12.6,15.2, RS 15.7.1 sp202 On HP Itanium 64bit, MS SQL Server 2008 On Windows 2008 Servers. Linux 64 bit Physical Servers and also Virtual ServersDBA Team Size: EightDB Artisan 9.6.1, Sybase Central.Working as a Sybase ASE and Sybase Replication Server Database Administrator for Installing and Configuring servers, Creating Databases, Segments, upgraded several servers from Sybase ASE 12.5 to 15.0.3 and from Sybase 15.03 to SAP ASE 15.5 and SAP ASE 15.7 sp139 version. At present Migrating from SAP ASE 15.7 to SAP ASE 16.0 Monitoring and performance tuning of servers and databases also tuning stored procedures and triggers, setting up User Security & System standards, extending Databases and writing scripts, participated in Supporting Developers for writing queries.I designed Replication environment for Voya Financial (former ING retail annuities) and implemented successfully.Role: Senior Sybase Database admin. As a senior person, I am the first one to be contacted for all Production issues, I am the one to take decisions what needs to be done and suggest other dbas technical procedures.Projects handled in Voya Financial1)Verify DR servers are Valid, and Up and running all the timeThis project includes Oracle, Sybase, DB2 and MS SQL server environmentsFrame based replication, and Sybase replication for Sybase. Frame based replication, flash copy and Golden gate for oracle2)Verify net backups are valid or notThis project includes Oracle, Sybase, DB2 and MS SQL server environments3)Verify Backups are valid or notThis project includes Oracle, Sybase, DB2 and MS SQL server environments4. Database Administrator:Client: Reuters America, Saint Louis, MO.Duration Nov 2005 to March 2005Environment: Sybase ASE 12.0/12.5.0.3, Sybase Replication 12.0/12.5, On HPUX E 9000, MS SQL Server 7.0,2000 On Windows NT and Windows 2000 servers.DBA Team Size: FiveDBArtisan, Sybase Central, SQL Advantage, Vantive, Clear quest ECM ToolWorking as a Sybase ASE & MS SQL Server Database Administrator for Installing and Configuring servers, Creating Databases, Segments, upgraded several servers from 12.0 to 12.5 version, Monitoring and performance tuning of servers and databases also tuning stored procedures and triggers, setting up User Security & System standards, extending Databases, writing scripts. Actively participated in Supporting Developers for writing queries for Vantive, MIS and Work order process applications. Actively involved in Monitoring Replication Severs and Overnight replication process in MS SQL Server. I have installed and configured Sybase 12.5.0.3 ASE servers for Vantive and MIS Applications, supported Development, UAT and Production servers, set up procedures for refreshing databases and database dumps. Frequently providing on call DBA support from Home and working from Office for MIS, Vantive and Work order processing projects which have very tight deadlines5. Sybase Database Administrator:Client: Freddie Mac, McLean, VA.Duration Aug 2003 to Nov 2004Environment: Sybase ASE 12.0/12.5.0.3, Sybase Replication 12.0/12.5, On Sun Solaris, Sql Backtrack 4.4.Loan Prospector Team Size: SevenClose the Books Team size: TenDBArtisan 7.0/8.0, Autosys scheduling tool, Vantive, Db server, Clear quest ECM ToolWorking as a Sybase ASE Database Administrator for Installing and Configuring servers, Creating Databases, Segments, upgraded several servers from 12.0 to 12.5 version, Monitoring and performance tuning of servers and databases, setting up User Security & System standards, extending Databases, writing scripts and Jill files for automating jobs in Autosys scheduler. Actively participated in table purge process, since tables are growing at a very large rate in Loan prospector group. Also actively involved in supporting warm standby replication servers. I have installed and configured Sybase 12.5.0.3 ASE servers for close the books group, supported Development, UAT and Production servers, set up procedures for snapshots, logical dumps and loads, and refreshing databases. Frequently providing Oncall DBA support from Home and working at EOC for CTB projects which have very tight deadlines6. Database Administrator:Client: G M A, Bethlehem, PA.Duration January 2002 July 2002Environment Oracle 8.1.7.3.0, 9.2.0.1.0 on Windows NT ServerTeam Size SevenDBArtisan 5.4, Oracle 8i, Oracle Enterprise Manager, DBA Studio, PL/SQL,Worked as a Sybase ASE and Oracle system administrator and DBA for Installing and configuring servers, Creating Databases, Segments, Upgrading Servers, Monitoring and performance tuning of databases, Setting up User Security & System standards, extending Databases, writing scripts for automating jobs in crontab. Out of 22 servers 15 servers were Sybase Servers. I installed Replication 12.0 servers for warm standby applications. I maintained Both Windows NT & Sun Solaris servers. Daily Monitoring Servers for Space usage and Performance. I was supporting application for Developers, Changes in Production OLTP Databases. At this client I have handled up to 25 GB databases. Running queries for Benchmarking to get good performance, Modifying Procedures for better performance, taking show plans for problem queries. Writing C shell and corn shell scripts.7. Database Administrator:Client: G E Power Systems, Schenectady, NY.Duration January 2001 December 2001Environment Sybase ASE 11.9.2.2 - 32 bit, Sybase Gateways, Sybase Client, ISQL, TSQL & Oracle 8I & 8.1.6,Windows NT Server, SUN Solaris 5.6, 5.7 (Sun Sparc 4000, 3500 up to 6 processors), Veritas Backup Server. Writing procedures & triggersTeam Size FIFTEENSun Sparc 4000,Sun Sparc E3500, Sun Solaris 5.6,IBM ThinkPad, Windows 98, Sybase ASE 11.5.1, 11.9.2.2, Sybase Direct Connect GATEWAYS, Sybase Central, Sybase SQL Advantage, DBArtisan 5.3, Oracle 8I, PL/Sql., Erwin Designer tool for data modeling. Veritas Backup Server for backups.Worked as Sybase and Oracle DBA support for production and Test Applications. Worked on Loading databases from prod to test, extending segments. Writing shell scripts for putting in cron jobs. Daily Monitoring Sql servers for Space usage and Performance. Testing Queries for benching marking. Supporting application Developers, Changes in Production Databases, Disaster recovery of production databases, giving gateway connections and managing Sybase Direct Connect server. I was involved in Setting up backup procedure for Hot and cold backups. At this client I handled up to 16 GB databases, each server has more than 20 databases.Migrating data and procedures from Test to QA and QA to Production servers, Sybase servers Migration and Installations. Whenever we change OS up gradations we also migrated Sybase several times.8. Database Administrator:Client: Thomson Financial Services. Boston, MA.Duration: July 2000 October 2000Environment: Sybase ASE 11.5, 11.9.2, 12.0, TSQL, ISQL, MS- Windows NT, SUN Solaris 5.7 (Sun Sparc up to 6), Power Builder 6.0,Team Size: FiveResponsible for the maintenance of 10 servers, 34 Databases including Production, Warehousing, Ftp server, Site servers, maintaining Replication Server 12.0. Responsible for updating Archive database through stored procedures, Sybase Migration, maintained up to 2500 users, writing Unix shell scripts and keeping them in Cron jobs, tuning & monitoring SQL servers, creating, loading & extending databases, creating segments and placing objects on segments & data migration. I was involved in Maintaining Brokerage applications and Credit derivative applications.9. Database Administrator:Client: Aetna Inc., Hartford, CT.Duration March 2000 - June 2000Environment Sybase System 11.5.1.1, ISQL, TSQL, Sybase Omni Connect, Sybase open client, MS- Windows NT, SUN, Korn shell scripts Solaris 5.6 (Sun Sparc up to 14 processors),Team Size SIXI was Responsible for the maintenance of 10 Servers 30 databases including Test, QA and production. At this client I handled up to 37 GB production databases. I installed 3 production databases, including Pension New Business, Massachusetts Payroll, and Omni Plan Install. Primarily responsible for creating databases, tuning the database, monitoring the servers, extending databases, data migration, stored procedures, Wrote several shell korn scripts, Perl scripts for Mellon data application, tuning and users creation. Also maintained one replicated database for Remote enrollment project. I wrote several triggers to maintain History database.10. Database AdministratorClient AT & T Prepaid Technology, Dublin, OHDuration October 1999 Jan 2000Environment: Sybase ASE 11.5, TSQL, ISQL, MSSQL SERVER 7.0, Windows NT, Dec 4.0, Platinum Desktop DBA tool, Sybase Central.Team Size ThreeResponsible for maintenance of 3 servers 10 databases including development, Test, Production and Data warehouse databases. I was maintaining 225 GB database on Data Warehouse server, and up to 172 GB databases on production server. Includes production changes, Tuning and Monitoring of SQL Servers, extending databases, data migration, migrating databases from test to QA and QA to Production, performance turning of sql servers. Writing procedures & triggers, Modifying queries for production updates.11. Programmer - Database Administrator:Fixed Deposits - Financial Accounting - Branch Sales Computerization - Raw Material Management System, Bills discounting & H R Management. Recurring Deposits and Fixed Deposits Branch ModulesClient: Pennar Group of industries, Hyderabad, India.Duration Oct 95 - Aug.99Environment MS- Windows 95, LAN Work Place v-5, SCO UNIX 3.5Sybase System 10.0, Replication Server 10, TSQL, ISQL, Power Builder 4.0/5.0/6.0 Enterprise Version, IBM Pc Server 320, HP 9000, Pentium 120Oracle 7.1, Delphi v 1.0, Windows 3.11Team Size FOURInstalling Unix & Sybase Database Server, creating raw partitions, creation devices, creating databases, creating segments for placing specific objects, involved in designing of this application in power designer, tuning server for this application, memory allocations. Installing Power Builder, Sybase Client, LAN Work Place, and setting up ODBC Drivers for connectivity, setting up backup procedures for this application. Converting data from fox pro to Sybase through bcp tool. I wrote several shell scripts to monitor the servers, and also to monitor databases and segments.I was fully involved in Migrating Sight Draft application (Database) from Sybase 11.0 to Oracle 7.3, I migrated all tables using BCP tool in Sybase and SQL Loader in Oracle. All other objected I created manually.Education:M.A. - Public Administration.Post Graduate Diploma in Software Technology & Certificate in Computing |
