Aarthi Arjunan

Work Experience

SQL Database Administrator

Responsibilities:

1. Database Management:

- Managed and maintained multiple SQL Server databases across various environments, ensuring optimal performance and availability.

- Performed regular database backups and restorations to ensure data availability and continuity.

- Upgraded and patched SQL Server instances to maintain security and compliance.

2. Performance Tuning:

- Conducted regular index maintenance (rebuilding, reorganizing) and updated statistics to enhance query performance.

- Used SQL Server Profiler and Performance Monitor to identify and resolve performance bottlenecks.

3. Security and Compliance:

- Implemented database security measures, including user access control, roles and permissions management, and encryption.

- Ensured compliance with data protection regulations and internal security policies.

- Conducted regular audits to verify security configurations and practices.

4. High Availability and Disaster Recovery:

- Set up and managed high availability solutions, including AlwaysOn Availability Groups and database mirroring.

- Developed and tested disaster recovery plans to ensure minimal downtime and data loss.

- Configured and monitored SQL Server replication for data redundancy and distribution.

5. Monitoring and Automation:

- Implemented automated monitoring solutions using SQL Server Agent and third-party tools to proactively identify issues.

- Developed and maintained PowerShell and T-SQL scripts to automate routine maintenance tasks.

- Monitored key performance metrics and generated regular reports for stakeholders.

6. Troubleshooting and Support:

- Provided 24/7 support for critical database systems, troubleshooting and resolving issues promptly.

- Conducted root cause analysis for recurring problems and implemented permanent solutions.

- Collaborated with development and infrastructure teams to ensure seamless database operations.

7. Documentation and Reporting:

- Maintained comprehensive documentation of database configurations, procedures, and incidents.

- Prepared regular reports on database performance, backup status, and security audits for management review.

- Documented best practices and standard operating procedures for database administration.

Key Achievements:

- Successfully migrated several legacy databases to the latest Evergreen SQL Server versions, improving performance and security.

- Improved query responses through effective indexing and query optimization techniques.

- Implemented a robust disaster recovery solution that minimized downtime and data loss during critical incidents.

Projects:

Project 1:

• Client: LifePro version upgrade
• Support: DBA
• Role : Program Analyst
• Team size: 16

Project 2:

• Client: Jhon Hancock(MSM)
• Role : Program Analyst
• Team size: 12

Certifications:

- Microsoft Certified: Microsoft SQL Server Database Administration Course

- Microsoft Certified: Azure Database Administrator Associate.

-Preparing and Processing: Bash Scripting and Shell Programming.