RAFAY PERVAIZ
Summary
Working on heterogeneous infrastructure based on cloud like AWS | AZURE | GCP and traditional infrastructure for databases like MSSQL | Oracle | MariaDB | MemSQL | Postgres on Windows and Linux platform, moreover with the passage of time also performing Administrative tasks on tools like Power Center Informatica and MicroStrategy from installation to a daily task. Hands-on in writing scripts which can ease daily task using Linux Bash | PL/SQL | TSQL according to the need. Right now, my job is to make sure all the transactions are: Secured | Isolated | Consistent | Optimized | Backup-ed | Recoverable | Archived | Integrated
Overview
12
12
years of professional experience
Work History
Technical Consultant
Cayenta
01.2023 - Current
- Examine data, processes, and technologies to evaluate the current state and critical problems for both on premises and cloud infrastructure
- Helping clients maximize the value of their investment in the company's product or service by identifying ways to improve performance.
- Coordinated with clients to resolve issues and, if unresolved, worked with the dev team to create Jira tickets and identify root causes.
- Communicated analysis and solutions to clients, ensuring they understood work logic and efforts through verbal and written communication.
- Working with clients to develop plans for implementing new products or services, including an assessment of current needs and goals, as well as developing a roadmap for future success
- Helping clients improve operational efficiency by identifying opportunities for process improvement and facilitating the transition to new processes where appropriate
- Recommending changes to client websites or applications
- Deploying, Administrating, optimizing databases deployed on Azure infrastructure
- Research and make recommendations about training, equipment, and technology to improve data use
- Create automated data reports to inform business units, including documentation, toolkits, and FAQ guides
- Train and mentor teams in data input, use, meaning, and analysis.
Visiting Faculty
Omni Academy
02.2021 - Current
- Covering courses related to databases like MySQL, MSSQL, Oracle
- Covering course related to Cloud platform like AWS, Azure, GCP.
Database & Cloud Consultant
Contour Software
05.2020 - 01.2022
- Working for Harris Computer subdivision Cayenta as a Database consultant
- Administrating multiple databases like Oracle, MSSQL, Azure, MySQL, Postgres
- Providing Tier-1 support to clients for issues related to database
- Deployment of Azure infrastructure for clients on azure platform
- Administrating Subscription, Billing, services, and automation related to Azure services
- Deploying, Administrating, optimizing databases deployed on Azure infrastructure
- Automating jobs for DevOps related issues
- Database health testing for both traditional and cloud based databases.
Sr. Database Administrator
SS&C PRIMATICS FINANCIAL
08.2016 - 05.2020
- Administrating daily database operations which includes the availability of databases
- Research and planning of the database upgrades with minimum downtime
- Working with metric teams to achieve goals
- Analyzing and debugging issues related to the database
- Research and planning for the deployment of AWS EC2 machines
- Scaling up/down, in/out for AWS infrastructure for resources required for financial computing task
- Administrating AWS services like IAM, EC2, Route 53, S3 Buckets, and databases
- Monitoring and optimizing AWS cost.
Database Administrator and Developer
OMEX Systems.
03.2012 - 07.2016
- Managing Databases and their operations
- High Availability of database for all 24/7
- Communicating with our clients and facilitating them
- Managing team for Database operations and supports
- Working on the optimization of SQL Server database using different tools
- Transforming logical business rules into MSSQL code
- Keeping myself updated for the new and latest technology provided by Microsoft
- Creating SSRS and reporting server for all the production and testing database and improvising the performance of servers
- Maintaining traces and evaluating the issues
- License and upgrading of Microsoft SQL Server
- Timely database refactoring
- Cleansing of database yearly
- Stress testing on Database
- Deploying up to date math of New York Stock Exchange as per their rules.
Education
Master's in Software Engineering -
PAF-Karachi Institute of Engineering and Technology (KIET)
12.2017
Bachelor's in Software Engineering -
University of Karachi
12.2013
Skills
- Performance Analysis
- Systems Analysis
- Application support
- Client Needs Assessment
- Business Process Analysis
- Process Automation
- Client Relationship Building
Personal Information
Title: Database & Cloud Consultant
Timeline
Technical Consultant
Cayenta
01.2023 - Current
Visiting Faculty
Omni Academy
02.2021 - Current
Database & Cloud Consultant
Contour Software
05.2020 - 01.2022
Sr. Database Administrator
SS&C PRIMATICS FINANCIAL
08.2016 - 05.2020
Database Administrator and Developer
OMEX Systems.
03.2012 - 07.2016
Master's in Software Engineering -
PAF-Karachi Institute of Engineering and Technology (KIET)
Bachelor's in Software Engineering -
University of Karachi