With a comprehensive 4-year background in IT, I am a detail-oriented professional excelling as both a SQL Database Administrator and SQL Developer. My expertise encompasses database installation, configuration, maintenance, and performance tuning, alongside robust database security implementation and disaster recovery planning. Certified as an AWS Certified Cloud Practitioner, I possess extensive experience in SSRS report development and customization. A collaborative team player with strong problem-solving abilities, I excel in optimizing database performance, designing efficient SQL Server databases, and writing complex queries for data manipulation and analysis. I am dedicated to maintaining database security, overseeing user access, and ensuring compliance while developing visually appealing reports to meet business requirements.
•Implemented SQL Server security, managed object permissions, and scheduled jobs, alerts, SQL Mail Agent,
and DTS.
• Optimized database performance by monitoring health and implementing tuning recommendations.
• Involved in database refresh activities for system migration, minimizing downtime by 50%.
• Took responsibility for database support, troubleshooting, planning, and migration, including the installation
and configuration of MS-SQL Server.
• Monitored database growth, managed databases, data files, and log files. Oversaw space monitoring and
added space to databases when needed.
• Managing weekly database backups and scheduling jobs using SQL Agent.
• Successfully led the installation and configuration of SQL Server instances, ensuring optimal performance
and reliability.
• Implemented comprehensive performance tuning strategies, optimizing query execution plans and improving
database response.
• Creating joins and sub-queries for complex queries involving multiple tables.
• Developing SQL reports, data extraction, and data loading scripts for various databases and schemas.
• Designing a report for server performance monitoring using Task Manager, providing detailed reports to
management.
• Maintaining SQL scripts for the creation of database objects