Sybase DBA & Developer
Contour Software
Total des années d'expérience :33 years, 4 Mois
• SAP ASE (16.0) Administrator on Linux environment.
• Backup/Restore of production/test databases
• Plan & Perform regular maintenance activities on production/test databases
• Performance & tuning
• TSQL development
• Linux Shell Scripting (bash) for routine tasks.
• Development of data import/export utilities by using shell scripting - that provide & integrate data from various formats like JSON, XML, CSV etc.
• Database migrations from SAP ASE to MS SQL Server
• Upgrade of SAP ASE databases
- Leading a team of consultants to engage in world-class IM consulting with leading enterprises around the globe, creating a "wow" factor and everlasting relationships with customers
- Leading the efforts to continually contribute towards operational excellence
- Responsible and accountable to achieve your assigned revenue targets
- Building and leading a team of A players and keeping them excited
- Assist in various project management & system development activities
-Take care of infra-structure related issues
- Assist in database related activities - MS SQL Server
- Provide support for various mobile based applications
- Design & Develop Business Dashboards in QlikView
Provide technical solutions to various customer in field of:
-Database administration - Sybase ASE (specifically)
-Business contingency/continuity planning
-Support services
- Application system designing
-Worked as resident technical consultant for Abu Dhabi Islamic Bank.
-Install, configure and upgrade Sybase database software and related products
-Monitoring of Database Servers (Production and non-production)
-Identifying and Troubleshooting problems related to Sybase
-Design and monitor system storage
-Perform regular checks to maintain the consistency and reliability of the Database
-Maintain Warm Standby Sybase Replication
-Plan and carryout DR scenarios
-Implement IT Security and Audit policies and procedures.
Presently deployed as Sybase resource at client side in UAE.
Providing DBA support for Abu Dhabi Islamic Bank, Abu Dhabi.
Core banking application PHOENIX migration from I3 version to ME (Middle East) with Sybase ASE 15.0.3.
Providing day to day DBA support
• Managing corporate databases on Sybase ASE 12.0/12.5/15 with Replication Servers.
• Schedules, supervises, monitors and gives instruction to less experienced colleagues in all aspects of database administration. Ensures that all tasks and procedures are carried out effectively and efficiently to agreed levels of service.
• Responsible to manage the mission critical application running on Sybase Adaptive Server Enterprise & Sybase Replication environment.
• As member of virtual teams works with other team across Operations to review, evaluate and implement necessary changes to infrastructure environment.
• Responsible for substantial technical decision-making or for teams of staff. If the latter, demonstrates the basic qualities associated with team leadership.
• Select technical tools etc in such a way as to meet set targets of cost, time, quality and performance.
• Communicate both formally and informally with all those with whom working interfaces arise whether they be colleagues, clients or customers.
• Initiate and makes time available to ensure general technical competencies and specializations are kept up-to-date in line with industry developments.
• Managing core applications (FrieghtSoft, DanzSale & OPAC) databases in Sybase ASE 15.
• Install, operate and maintain complex centralized and distributed computer
systems in a multi-vendor environment for mission critical database
applications.
• Perform last level support to all customers, infrastructure and develop solutions
to stabilize customer environments.
• Sybase database installation, administration and support.
• Database and Index reorganization.
• User and Rights administration.
• Batch jobs management, disk space administration and performance tuning.
• Backup/Restore, Systems tuning, Database backup/restore.
Additionally I worked as Focal Point for German Database Customers (includes
financial institutions & large manufacturing concerns) for both Sybase & Oracle
Teams of 4 people in IDC Brno. My additional responsibilities were:
• Customer oriented sub-team lead (IT Specialist Lead)
• Workload distribution within the customer oriented sub-team
• Interface to other groups, sub-teams, customer
• Contact point for customer specific, technical and organizational questions
relating specifically for databases and project management support.
• Control of proper performance of all security related processes and creation of
evidence in auditable records as described in the local security working
instructions
• Lead in Security implementation on the systems
• Patch implementation, security health checking, service de/activation
• Lead in takeover of devices (activation/deactivation)
• Lead in large customer specific projects - IT infrastructure upgrades, server
consolidations and services transfers.
• Systematic problem analysis and resolution
• Service status reporting
Overall administration of Pakistan I.T. Department & heading 10 staff members. Solaris System Administration of Sun Ultra Enterprise Series Servers. Having good exposure of device management through Solstice Disk Manager, Hardware Raid Manager, User Management & other system administration tasks. Sybase SQL Server 11 Back end development & Routine Database Installation & Management operations. Having very good exposures of database troubleshooting, user management and database objects like trigger, table, indexes, constraints and procedures. Good command over Transact SQL. Presently Managing two databases of about 200 users. Involved in software development projects alongwith a team of Java developers for problem analysis, design & implementations. Involved in planning, deisgning and implementations of Wide & Local Area Networks. System Analysis of hardware & software solutions. Involved in various policy making of the department like Internet, Security, Disaster Recovery, Business Continuty &Users Access etc. User support & problem solving emerging through everyday operations. Liaison officer for Internal/External Audits. Prepare training documents, manual & policy documents of the department. Involved in ATM (Teller Machines) installation/implementation project. Involved in migration &computerization of Bank's Kenya Operations (4 Branches) alongwith merger of two banks Manage &execute the full project of migration from Solaris 2.6 to 9 &Sybase 11.0.3 to Sybase Adaptive Server Enterprise 12.5.x in Pakistan Operations of the Bank Involved in porject development, implementation &maintenance of Bank's various products like Debit Card, GSM Phone Banking &Tele Banking Services Involved in Information Security Setup of Bank
Analysed & Designed complete application software for Accounting, Export, Production & Order Processing Systems in FoxPro. Lead a team of 3 group members.
Diploma in Computer Science (2 years)