Anees Ahmad Email & Phone Number

Lahore, Pk

Lahore, Punjab, Pakistan

Lahore, Punjab, Pakistan

Overseeing the administration of 500+ heterogeneous databases supporting Petabyte+ data distributed among various geographies across theglobe• Planing, organizing, directing, controlling and proactively monitoring the 24/7 database operations to support mission critical database serversfor financial applications in 24 different time zones connected with various card networks like VISA, MASTERCARD,DISCOVER,AMERICAN EX‑PRESS etc• Infrastructure designing, upgrading, administration and maintenance of redundant datacenters to ensure SLAs, high‑availability, automatedfail‑over, data‑consolidation, distributed‑availability and load balancing• Enhances the effectiveness of existing database tools and services and help building the structure and design of the database• Planning, developing strategies and executing LIVE workflow migration of mission critical database services• Building test versions, performing bug testing, conducting diagnostic tests, and evaluating performance metrics• Involvement and coordination with internal/external auditors for successful compliance of industries standard information security audits andcompliance processes (i.e. PCI,3DS, SSAE16/SAS70,ISO 22301,ISO 27001 etc• Involvement in decision making about infrastructure enhancement, storage media selection, capacity planning and relevant costing/budgeting• Hiring, supervising, and monitoring the cross‑functional database engineering teams• Conducting training, refreshers and rehearsals on DC failover, switchover and migration

Lahore, Pakistan

Overseeing the administration of the heterogeneous databases and developing long-term corporate strategy for data storage. Leading architecture discussions around design, data integration, database migrations, recoverability, resiliency, capacity planning and availability. Ensuring proactive state of the art monitoring of all database services across the production and development environments Defining logical database structure for mission critical financial applications based on the organizational structure of the company Defining and executing procedures for testing and implementing new applications in the database environment. Ensuring projects and department milestones are met on time and within budgetDesigning the SOPs to meet service level agreements for data timeliness and frequencyLeading the diagnosis of database-related issues and serve as subject matter expertAssessing current and projected database performance, recommending changes/enhancementsProviding leadership in supporting production database environments (7x24) including designingg, installing, patching, tuning, maintaining and upgrading heterogeneous databasesEvaluating and recommending new database softwares, utilities and tools to set the strategy for implementing new technologies. Recruiting interviews, hiring and training new staff in the department and overseeing the daily workflow of the department and provides constructive and timely performance evaluations

Lahore, Punjab, Pakistan

Lahore, Punjab, Pakistan

Lahore, Punjab, Pakistan

Responsibilities Include Organization-wide database administration of enterprise scale heterogeneous databases (Oracle, MySQL, Informix, DB2, Postgres)Develop, maintain and publish database standards/guidelines and naming conventionsDefining and delivering strategic goals, reporting, coordination with senior management and other key stakeholders/teams within the organizationParticipating in resolution of physical database issues, generation/deployment of DDL, referential integrity rules, access paths, indexes, views, backup, recovery and volumetric requirementsPlan, organize, direct, control and monitor the 24/7 database operations to support mission critical database servers for financial applicationsIdentification & resolution of production database issuesDevelop, implement and oversee database backup, storage, disaster recovery and data security/masking strategies, operating standards, policies & proceduresInfrastructure design, maintenance, upgrades and administration of redundant data-centers to ensure high-availability, automated fail-over, data-consolidation, distributed-availability and load balanced environmentInstall, configure and maintenance of database serversInvolvement in decision making about infrastructure enhancement, storage media, capacity planning and relevant costing/budgetingInvolvement & coordination with internal/external auditors for successful compliance of many industry standard information security audits & compliance processes (i.e. PCI, SSAE16/SAS70 etc.)Conduct research into feasibility, design and development of database purge/archive criteria and procedures for historic dataProvide support and assistance to development/QA teams in building complex SQL queries, designing physical and logical models for application development and proof of concept initiatives

Lahore,Pakistan