Marian Aile

• Enhanced database performance, implemented recovery procedures and achieved 99.9% up time on all SQL Servers
• Increased efficiency by 30% by providing optimum database performance with efficient backup and restore processes.
• Query Store, Import/Export Wizard, SSMS, SQL Server Profiler, Extended Events and Tuning Advisor tools
• Interacts with clients, application team and project managers to design, implement and support solutions to meet client needs
• Configured and Managed High Availability (HA) and Disaster Recovery (DR) Solutions (Log Shipping, Mirroring, Always On, Clustering, and Replication), TDE (Transparent Data Encryption)
• Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance performance of databases
• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
• Utilized RDBMS tools and utilities to monitor, tune and optimize system performance.
• Set up and controlled user access levels across databases to protect important data
• Built databases and table structures for web applications.
• Set up and controlled user access levels across databases to protect important data.
• Worked with staff to develop and implement procedures to prevent data loss and maximize system availability
• Implemented BI solution framework for business intelligence projects
• Utilized RDBMS tools and utilities to monitor, tune and optimize system performance
• Designed and developed analytical data structures

• Monitored SQL health checks and identified issues and fixed them.
• Perform database administration activities such as storage management,
• Works closely with IT regarding system performance, maintenance and

Usingsing SQL Server Agent monitoring and troubleshooting jobs, event Notifications ions using Database Andl.

• Used Optimization tools such as SQL Profiler, Dynamic Management Views
• (DMVs) and Windows Performance Monitor for monitoring and tuning SQL
• Server performance.
• Implemented Installation, Configuration and Upgrading of SQL Server.
• Automated administrative tasks like creating jobs and schedules, alerts
• Maintained server security by assigning logins, server and database rolesand server permissions.
• Implemented disaster prevention and recovery strategies and supported
• High Availability features like Clustering, Always On, Log Shipping, Database
• Mirroring and Replication.
• Maintained database response times in 24X7 production environment and
• Planned and Implemented database backup/restore and disaster recovery.
• Implemented Log Shipping from Primary to Standby servers.
• Created and maintained SQL objects like Tables, Views, Stored Procedure,
• Constraints and User defined functions.Monitored SQL health checkBackup,dentified issues and fixed them.
• Perform database administration activities such as storage managemenBackup,
• backup, recovery, and perform tuning
• Works closely with IT regarding system performance, maintenance aOptimization.timization.
• Used Optimization tools such as SQL Profiler, Dynamic Management Views
• (DMVs) and Windows Performance Monitor for monitoring and tuning SQL
• Server performance.
• Implemented Installation, CUsinguration and Upgrading of SQL Server.
• Automated administrative tasks like creating jobs and schedules, a Using
• using SQL Server Agent monitoring and troubleshooting jobs, NotificaAndns>notifications using Database Mail.
• • Maintained server security by assigning logins, server and databaseAndles
• and server permissions.
• • Implemented disaster prevention and recovery strategies and supported
• High Availability features like Clustering, Always On, Log ShippinProactively
• Mirroring and Replication.
• • Maintained database response times in 24X7 production environProactivelyi>
• proactively generated reports.
• • Planned and Implemented database backup/restore and disaster recovery.
• • Implemented Log Shipping from Primary to Standby servers.
• • Created and maintained SQL objects like Tables, Views, Stored Procedure,
• Constraints and User defined functions.
• Built databases and table structures for web applications

• Responsible in administering SQL server security by creating User Logins with appropriate roles, monitoring user accounts, granting privileges to users and group
• Implementing TDE (Transparent Data Encryption)
• Configured Log shipping and supported replication (Snapshot\Transaction\Merge\Peers to Peers) in SQL 2008 through 2017 servers
• Successfully Scheduled Jobs Using SQL server Agent and Set up alerts Using Database Mails, Created Routine Jobs for Data integrity checks and coded deployment into production
• Applied Service Packs and security fixes for all SQL servers and provided database administrative support
• Produced SQL server Performance Dashboard Reports
• Oversaw/ Monitored and Integrated Temporal Tables and managed Indexes to improve performance
• Involved in planning, set up and implementations of new servers across entire enterprise
• Production level support for onsite and offshore- On call 24/7 environments
• Increased efficiency by providing optimum database performance with efficient backup and restore processes
• Configured and managed High Availability (HA) and Disaster Recovery (DR) solutions Using Always On, Failover Clustering, Log Shipping, database mirroring and Replication
• Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision
• Produced high-standard database solutions to meet stability, reliability and performance metrics
• Worked with staff to develop and implement procedures to prevent data loss and maximize system availability