Rohit Malik
Team Lead
Mickleham,VIC
Summary
Team Leader experienced in directing activities of workgroups. Develops strategies, provides training, sets goals and obtains team feedback. Excellent interpersonal and communication skills. Big picture focus with excellence in communicating goals and vision to succeed. Problem solver, networker and consensus builder.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Team Lead – Emerging Technologies
Company 1
02.2015 - Current
- Developed and maintained effective relationships with key stakeholders to better understand their needs and expectations.
- Served as a role model for the team by demonstrating commitment to excellence, professionalism, and adherence to company values at all times.
- Conducted training and mentored team members to promote productivity and commitment to friendly service.
- Created detailed project plans outlining goals, timelines, resources, and budgets to ensure alignment with company objectives.
- Nurtured long-term partnerships with clients by understanding their needs accurately, delivering projects on time, and providing exceptional customer support.
SQL Server DBA
Company 2
Auckland, NZ
07.2013 - 02.2015
- Adaptable and proficient in learning new concepts quickly and efficiently.
- Developed strong organizational and communication skills through coursework and volunteer activities.
- Worked well in a team setting, providing support and guidance.
- Paid attention to detail while completing assignments.
Senior Database Administrator
Company 3
Gurgaon, India
12.2011 - 05.2013
Lead Technical Architect - Databases
Company 4
Gurgaon, India
06.2009 - 11.2011
Senior SQL Server DBA
Company 5
Hyderabad, India
11.2006 - 06.2009
Education
Bachelor of Technology - Information Technology
Kurukshetra University
Haryana, India08.2006
Skills
- Microsoft SQL Server
- Cloud Migration
- Automation
- Business Intelligence
- High Availability Architecture
- Microsoft Azure
- AWS EC2 \ RDS \ Aurora
- Data Backup Solutions
- Database monitoring (on-prem\cloud)
- PostgreSQL
- MongoDB
- ITIL
- Solution Architecture
- Documentation And Reporting
- Client Support
- Account Management
- Leading Team Meetings
- Teamwork and Collaboration
- Team motivation
- Disaster Recovery Planning
- Overtime Management
- Technical Support
- Performance monitoring
- Team Supervision
- Customer Focus
- Work Planning and Prioritization
Accomplishments
MCSE: Data Management and Analytics (SQL 2019)
DP-300: Administering Relational Databases on Microsoft Azure
AZ-900: Microsoft Azure Fundamentals
Certification
- MCSE: Data Management and Analytics (SQL 2019)
- DP-300: Administering Relational Databases on Microsoft Azure
- AZ-900: Microsoft Azure Fundamentals
Recent Work Experience
- Company 1, Team Lead – Emerging Technologies, 08/01/19, Present, Performance and availability - maintaining performance tuning on all databases including Query tuning, tuning stored procedures, monitoring databases performance, implementing PT techniques to keep database performance as par to the user requirement,, Administrating and maintaining all jobs running on database servers and rectifying errors on need-to-need basis, running and checking windows counters data., Data Protection and Security – Maintaining Security on Databases servers, including creating new users and their accesses, auditing, data encryption, TDE., Strategy and design – Implementing new SQL Servers, installation of SQL Server tools, including SSAS, SSIS, SSRS, SSDT, VS. Creating New databases, Setup User security, Setup database security. Setting up High availability \ Disaster recovery solutions like Always-ON availability, Database mirroring, replication, log shipping., Capacity Management - Monitoring system resources to determine the growth patterns. Ensure sufficient capacity is available for system upgrades and new requirements. Provide Capacity plan., SSIS \ SSAS \ SSRS \ MDS – Creating and deploying new SSIS packages, SSAS cubes, SSRS reports. Troubleshoot issues with these technologies, performance tuning on SSRS reports. Implementing MDS for customers, migrating business rules from excel to MDS, implement, maintain MDS security., Database Modernization – End to end project delivery for SQL Server database, modernizations from SQL 2005\2008\2012 – SQL 2019\2022, Including database architecture, database upgrades, database cutover solutions with minimum downtime, high availability solutions, security setup, backup strategies., Cloud Migrations and support – SQL Server to Azure readiness and migration, Azure Database monitoring. PostgreSQL to AWS EC2 migration, EC2 to RDS \ Aurora. Centreon monitoring for EC2 and RDS., MongoDB – Implementing MongoDB replica set, Implementing Ops Manager, Implementing Monitoring, automation and backup through Ops Manager, Upgrading MongoDB, database backup \ restore., PostgreSQL \ MySQL – Implementing
- SQL databases, replication setup, Security setup, monitoring solutions like Nagios, Centreon, Grafana, Backup \ Restore, Database health checks.
Bio
My Name is a certified SQL Server Database Administrator with 17 years’ industry experience in Microsoft SQL Server. His expertise lies in SQL Server implementation including installation, database creation, database upgrade, creating database maintenance tasks, configuring SQL Server with best practices. He is also pioneer in setting up high availability \ Disaster recovery solutions like replication, mirroring, always-on availability groups, cluster implementation and performance tuning.
My Name is experienced in project management with wonderful grasp on project life cycle tasks like client requirement review, prioritizing, creating project proposals and baseline project planning.
My Name is currently managing a team of database admins working on database technologies like MySQL, PostgreSQL database and MongoDB.
Personal Information
Title: Team Lead – Emerging Technologies
Awards
- Company 1, 09/01/22, Employee of the Month
- Company 1, 08/01/22, Employee of the Month
- Company 1, 07/01/22, Employee of the Month
Timeline
Team Lead – Emerging Technologies
Company 1
02.2015 - Current
SQL Server DBA
Company 2
07.2013 - 02.2015
Senior Database Administrator
Company 3
12.2011 - 05.2013
Lead Technical Architect - Databases
Company 4
06.2009 - 11.2011
Senior SQL Server DBA
Company 5
11.2006 - 06.2009
Bachelor of Technology - Information Technology
Kurukshetra University