Mazhar Jamil Email & Phone Number

Kansas City, Missouri

Kansas City, Missouri Area

Provided technical and strategic direction; Worked with solution architects to provide scalable, adaptable consensus based enterprise solutions to meet current/future business needs; Evaluated and recommended new technologies in support of all major business and IT initiatives. Responsibilities also included management of physical database design and implementation, proactive monitoring, performance management, backup and recovery processes, ongoing support and database disaster recovery.• Maintained relationships with software vendors, and was accountable for software licenses, budgeting, performance metrics and training for associates. • Created a five-year, database technology strategy that built a business-centric technology organization that worked closely with the various business units to develop and deploy critical new or enhanced business capabilities.• Reduced company’s database software licensing and support expenses while leveraging a new resourcing strategy to maintain the same level of support and services. • Designed and implemented a high availability and disaster recovery plan for allowing seamless failover. • Implemented ITIL Service Management and standards for my department to focus on service design, delivery and operation according to ITIL methodology. • Developed quality control standards for all production deployment. • Implemented system-wide monitoring and metrics-based reporting allowing quantitative process management and quality improvements.• Developed SOX, SAS70, HIPAA and PCI compliance reports for internal and external auditors. • Accomplished financial objectives by forecasting requirements; preparing an annual budget for comp and software licenses

Kansas City, Missouri Area

Led a team supporting several thousand DB2, Oracle, MSSQL and Sybase databases running several critical applications. Hired and trained DBAs and maintained client and vendor relationships, coordinated and motivated project teams, and evaluated various technologies. Prepared project plans and resource budgets. Lead the team as the database Architect and mentored the Team and the project management on new technologies. Supporting Data Warehouse and Change Data Capture ETL tool. • Maintained organization's effectiveness and efficiency by defining, delivering, and supporting strategic plans for implementing information technologies.• Recommended information technology strategies, policies, and procedures by evaluating organization outcomes; identifying problems; evaluating trends; anticipating requirements.• Managed resources to ensure organizational and financial objectives are met. • Resolved complex problems that have implications beyond own area. • Communicated enterprise IT database services long term strategies and deliverables to executive management. • Stayed current with trends and technological innovations in the financial and IT industry, and make appropriate strategic and tactical recommendations. • Implemented follow-the-sun support model to improve quality of life of the associates.• Developed company policies and procedures, including change management, incident management, problem escalation and service level agreements.

Kansas City, Missouri Area

Installed and supported DB2/UDB, Sybase in UNIX and Microsoft SQL Server in Windows environment. Implementation & roll out of a Decision Support System. Automated stats and Reorg for using shell scripting. Capacity planning for production databases. Optimize and tune SQL statements. Set up database security.Logical and physical design of databases using Erwin tool. Recommend, evaluate and purchase database tools. Build, Update, and Customize Data Warehouse for Decision Support System. Optimize DB2 file structure and file system on AIX. Download data from Sybase to Data Marts for critical reporting. Perform backup for SQL Server, Sybase and DB2.

Kansas City, Missouri Area

Designed physical data structures based on Logical Data Model (ERD), Volume metrics and CRUD matrix using BACHMAN/ADW CASE tool. Technical design reviews of SQL statements and DB2 Explains. DB2 performance monitoring & tuning to maximize efficiency. Reorganization, backups, recoveries, and migration of data and data structures from Test to multiple Production platforms on multiple Subsystems. Forward/Reverse Engineering using CASE tool. 24 hour on-call database support. Implemented Shared-Read Only database. DB2 Security administration. Exercised disaster recovery. Supported database structures on DB2/NT, AIX and Microsoft Access. Developed Physical Design Methodology for department.

Bachelor'S Degree, Information System & Marketing

Activities and Societies: Student Senator, Program Chair for International Student Organization

Associate'S Degree, Geology/Earth Science, General