| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Helen HaileEmail: EMAIL AVAILABLELINKEDIN LINK AVAILABLEPhone: PHONE NUMBER AVAILABLESUMMARY OF QUALIFICATIONMicrosoft Certified Candidate's Name with 8 years of experience in IT and Database Technologies. Well-experienced in various aspects of database administration, performance tuning, security, HA/DR solutions, and incident handling. I have an Associate Degree in Information Technology. Dynamic problem-solving ability, team player, detail-oriented, and quick learner. Strong analytical and interpersonal skills, strong work ethic, and effective at meeting project objectives and deadlines in fast-paced environments. Managed Installation, Upgrade, Configuration, and Administration of MS SQL Servers 2008/2008R2/2012/2014/2016/2017/2019 in Standalone and Clustered environments. Set up and executed Database Maintenance Plans, Scheduled and Automated SQL Server Jobs, Configured Database Mail, and Created Alerts, Operators, and Notifications. Administered SQL Server High Availability and Disaster Recovery strategies, including Mirroring, Log shipping, Replication, Clustering, and AlwaysOn Availability Group. Troubleshoot and resolve SQL Server and Database related problems, including but not limited to CPU, Memory, I/O, and Disk space contention. Experienced in MS SQL Server Performance Tuning and Monitoring tools like Database Engine Tuning Advisor, SQL Server Profiler, Activity Monitor, Window Performance Monitor, DBCC, Store Procedures, and DMV. Analyzed queries using Execution Plans and implemented Performance Tuning and query optimization. Conducted root causes Analysis and used SQL Server Profiler, DMVs, and Error Logs for troubleshooting. Extensive experience with SQL Server and T-SQL in constructing database objects: tables, triggers, user functions, views, indexes, user profiles, and relational database models. Experienced in Administering SQL Server security by Creating Logins and users with appropriate permissions, monitoring the user accounts, creating groups, and granting privileges to users and groups following company rules and regulations. Mastered Database Backup, Restore, and Disaster recovery procedures. Proficient in Data migration between SQL Server 2012/2014/2016 and implementing ETL from Excel, Flat file using BCP, Import/Export wizard, and SSIS utility. Experienced in applying service packs and cumulative updates as needed. Well knowledgeable about working with SSRS. Worked with various teams like storage, network, security, and various system administrators in production and migration issues.Tools: - SSMS, DTA, Profiler, PerfMon, Visual studio, Redget, Index Manager, SSCM, Sentry One, iSupport, SAP, SourceTreeCandidate's Name
Helen HaileEmail: EMAIL AVAILABLELINKEDIN LINK AVAILABLEPhone: PHONE NUMBER AVAILABLEPROFESSIONAL EXPERIENCEPPE Casino Resorts Maryland LLC, MDSQL SERVER DBA June 2020 Present Installed and configured MS SQL Server 2017/2019 on Production and Development environment. Managed MS SQL Server 2016/2014 databases. Handled migrating contents from MS SQL Server 2012 to MS SQL Server 2016. Managed users and logins in SQL server, provided appropriate server/database roles, mapped them to specific databases, and granted specific privileges over selected database securable objects to ensure security and integrity. Migrated database from on-premises SQL Server to Azure. Implemented and maintained SQL Server solutions on different platforms, including VMWare, Azure(IaaS/PaaS), and on-premises, using SQL scripts, and PowerShell scripts. Analyzed and deployed scripts and SSIS packages in prod/test environments from different developers based on the CR/change request process. Involved in capacity planning and allocating resources for the databases by assisting application teams in creating databases depending upon the criticality of the databases following current and best practices per the SLA of the company. Responsible for capacity planning, forecasting data growth of databases, and providing reports on a quarterly basis. Created and monitored database maintenance plans and scheduled jobs using SQL Agent/Maintenance plan. Implemented database integrity check, reorganize/rebuild indexes, update statistics, backup/restore, and cleanup job history. Extensively used SQL native tools for performance monitoring /analysis and troubleshooting. Performance tuning by analyzing execution plans, creating, and maintaining indexes (rebuild/reorganize), Statistics, and Client/Server Connectivity. Identified Concurrency issues (blocking and Deadlock) in SQL server by using DMVs, Store Procedures, and Activity Monitor. Reviewed and optimized SQL queries, stored procedures, views, and triggers from other developers to achieve maximum efficiency and scalability. Provided consultation for development teams regarding performance review and the correct usage of database objects. Troubleshoot the most resource-intensive queries on the server and suggest ways to improve performance on each. Supported implementation of AlwaysOn Availability groups by creating availability databases using the high availability and DR strategies in clustered environments. Used native and third-party tools to diagnose server reliability and performance issues. Candidate's Name
Helen HaileEmail: EMAIL AVAILABLELINKEDIN LINK AVAILABLEPhone: PHONE NUMBER AVAILABLE Monitored SQL Server Error Log, Windows Event Logs, Profiler, Query Execution Plan, Database Tuning Advisor, and System Monitor for troubleshooting performance issues. Experienced in implementing, configuring, and maintaining Transactional Replication. PNC Financial Services Group INC, Washington DCSQL SERVER DBA Apr 2018 June 2020 Installed, configured, upgraded, and monitored SQL Server 2014 and 2016. Configured performance tuning and optimization in SQL Server 2014 and 2016. Implemented and configured Backup and recovery process using maintenance plans/and or T-SQL for database servers. Involved in SQL server upgrade from 2012 to SQL server 2016. Experienced in applying 2014 periodic service packs and cumulative updates. Involved in Day-to-Day activities such as monitoring SQL Agent Jobs, trending database growth, monitoring health and consistency of databases, ensuring database maintenance jobs. Involved in designing, configuring, monitoring, and troubleshooting Failover clustering and log shipping technologies on critical databases, as HA and DR solutions respectively. Implemented pre-/post-strategies for upgrading and migrating user databases by scripting all SQL server replications, login/users, linked servers, scheduled jobs, database mail profiles, and server level configurations. Managed efficient backup system to minimize backup/restore time by applying Database Backup Compression, enabling Instant File Initialization, and applying frequent full, differential, and transaction log backups. Performed data migration using Bulk Insert, Bulk Copy Program (BCP), and SSIS from Flat files to SQL Server 2012/2014. Run Database Consistency Checks (DBCC), scheduling the DBCC to run on a daily and weekly basis. Centurion Medical Product, MISQL SERVER DBA Jan 2016 Apr 2018Candidate's Name
Helen HaileEmail: EMAIL AVAILABLELINKEDIN LINK AVAILABLEPhone: PHONE NUMBER AVAILABLE Installed, Upgraded, Configured, and Migrated SQL Server in clustered and non-clustered production environments. Assisted in migration from MS SQL server 2008 to MS SQL server 2012. Involved in planning and administration of Failover clustered environment. Participated in the implementation of database mirroring and log shipping. Involved in performance tuning to optimize slow-running queries and index maintenance. Automated SQL Server Agent jobs for Periodic Backups with Backup Devices and Database Maintenance Plan. Report on a daily basis of server backup status. Administered MS SQL Server security by creating user logins with appropriate roles and permissions. Implemented maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space). Monitored disk space, memory, connections, and trending. Responsible for DR/HA solutions. Deploy scripts from the Development server to production/test servers. Created reports in SQL server using SSRS as per the requirements provided by the Front-End users. EducationMicro Link Information Technology CollegeAssociate degree Information Technology |
