| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Address: Street Address
Phone: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLELINKEDIN LINK AVAILABLEPROFESSIONAL SUMMARY: Experienced Database Administrator with Ten years of expertise and extensive knowledge of Relational Database Management System including Database Monitoring, Installation, upgrade Management, High Availability, Disaster Recovery, Log Shipping, Clustering, configuration of Alerts, Operators and Agent Jobs. Well experienced in Performance Tuning and Security. Proficient in diverse range of development native and third-party tools as well as T-SQ languages. Experienced with SQL server Azure Cloud, MS Access, and Power BI. Experienced in Disaster Recovery (DR) Testing and planning. Excellent communication, presentation and delivery skills. Recognized consistently for performance excellence and contributions to success in IT, financial and healthcare industries. Microsoft certified SQL Server Database Administrator for SQL server 2012/2014/2016 and 2017.EXPERIENCE03/2019 - CURRENTSQL SERVER DATABASE ADMINISTRATOR EPIC SYSTEMS INC., HERNDON, VA,COMPANY INFORMATION: EPIC systems is a company with broad-based IT professionals thatprovides reliable IT solutions and consulting services for governmentagencies and privately owned commercial clients.ROLES AND RESPONSIBILITIES:Installed, upgraded, configured and tuned SQL Server 2012/2014/2016 and 2017 systems and all associated middleware in Windows environments.Experience in monitoring and setting up High Availability and Disaster Recovery (HADR) Solutions like Database Mirroring, Replication (Snapshot, Merge, transactional), Log Shipping, and Availability Groups.Proactively monitored database systems to ensure secure services with minimum downtime.Worked in performance enhancement by running index tuning wizard for creating, rebuilding, and reorganizing indexes on various tables.Monitored Performance and Fine-Tuned Stored Procedures, SQL Queries and User Defined Functions to optimize performance and reliability.Worked to ensure all database servers are managed to Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) as per the Service Level Agreement.Built databases, tables, and various database objects per business requirement following SQL Server Database Modeler and ER Studio Data Architecture methodology.Wrote and maintained technical and functional specifications to document database integrations and requirements;Participated in on-call rotation supporting systems after-hours, weekends and holidays.Analyzed and resolved performance issues, database capacity issues, replication, and other distributed data issues for all production and test databases.Monitored Daily backup jobs and automation of daily restores of development databases. (Using Red gate, Idera, and Native backups)Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.Monitored and Troubleshoot Server performance and database activities of users using SQL Profiler, Performance Monitor, Extended Event, Trace flags, Activity Monitors, Stored Procedures, DBCC, and DMVs.Monitored user accounts, created groups, granted necessary privileges to users and groups.Created various server and databases alerts that helps to take actions proactively and reactively;12/2017 - 03/2019DATABASE ADMIN AND DEVELOPER AETNA HEALTH - DALLAS, TXCOMPANY INFORMATION: AETNA offers health insurance, dental, vision and otherplans to its customers. Data management regarding clientsinformation, coverage, plan and payment systems are part of thebusiness.ROLES AND RESPONSIBILITIES:Evaluated, designed, implemented and modified databases and database applications.Provided trend analysis to the service management team enabling them to make informed decisions regarding resource management;Designed, reviewed, and created database objects like views, indexes, stored procedures, functions, and triggers based on logical and physical design models and user requirements;Administered MS SQL Server security through access control mechanisms like creating accounts, roles, and providing privilege.Maintained proper security procedures by dropping and locking unnecessary logins;Configure SQL Server monitoring utilities to minimize false alarms;Authored and coded logical and physical database descriptionsCollected and reviewed database performance metrics and proactively address performance concerns;Configured and monitored log shipping and Database mirroring on Disaster recovery Servers;Evaluate CPU, Disk I/O and Memory related bottlenecks using Performance Monitor and improved SQL server performance;Utilized Alteryx to automate data preparation tasks, reducing manual effort by 50% and increasing efficiency in data processing.Developed complex workflows in Alteryx to clean, blend, and transform large datasets from disparate sources, ensuring data integrity and consistency.Conducted exploratory data analysis using Alteryx to identify trends, patterns, and outliers, providing actionable insights to stakeholders.Created predictive models and performed advanced statistical analysis in Alteryx to forecast sales, customer behavior, and other key business metrics.Collaborated with cross-functional teams to design and implement Alteryx workflows that address specific business challenges and drive decision-making.Rebuild clustered and non-clustered Indexes as part of performance tuningDelivered complex business requirements without any issues by leveraging strong troubleshooting skills and extensive oversightPlanned and implemented security measures to safeguard vital business dataIdentified issues within databases, performed troubleshooting and implemented effective solutionsCreated technical documentation for database technologies, providing updates as needed06/2016 - 11/2017SQL DATABASE ADMINISTRATOR- CAPITAL ONE FINANCIAL CORP.-WASHINGTON D.CCOMPANY INFORMATION: Capital One is one of the largest financial and bankinginstitution that serves millions of customers, businesses andcompanies by providing loans and other financial services.ROLES AND RESPONIBILITIES:Designed and implemented TSQL queries for reporting and complex solution development.Tune slow running T-SQL queries using Execution Plan and Database engine tuning advisor.Developed and produced high-standard database solutions to meet stability, reliability and performance metrics.Worked on data encryption to ensure security of data at rest and data in motion.Participated and support Service Level Agreement (SLA) and operational performance monitoring and reporting.Performed replication for updating a critical table to various branches (Subscribers).Participated in root cause analysis and problem management activities;Administered SQL Server/Database level Security and utilized Auditing and Data Encryption according to requirements.Led incident resolution efforts, participated in incident management activities and engaged appropriate resources to complete corrective actions.Enhanced performance by running index tuning wizard for creating, rebuilding, and reorganizing indexes on various tables.Set up and controlled user profiles and access levels for each database segment to protect important data.Created and managed database objects, stored procedures, triggers, views, and functions.03/2014 - 05/2016SQL SERVER DATABASE ADMIN AND CONSULTANT LEIDOS HOLDINGS INC. RESTON, VACOMPANY INFORMATION: LEIDOS HOLDINGS, INC. is a company whichengages in the provision of scientific, engineeringand information technology services and solutions in the areasof defense, intelligence, civil and health markets.ROLES AND RESPONSIBILITIES:Participated in implementing database architecture and strategies, and defining standards for database environment;Administered, maintained, developed and implemented policies and procedures for ensuring security and integrity of SQL Server databases;Implemented disaster recovery strategy;Developed and maintained standards for documentation, database security, and audit compliance;Explained data results clearly and discussed how it can be utilized to support project objectives;Contributed to internal activities for overall process improvements, efficiencies and innovation;Respond to production incidents and address them with in Service Level Agreement (SLA) framework;Undertook Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools and DMV'sTranslated logical data models into physical database designs and developed physical databases07/2011-02/2014JUNIOR DATABASE ADMINISTRATOR AND DATA ANALYST CENTRAL STASTICS AGENCY: ADDIS ABABA, ETHIOPIACOMPANY INFORMATION: Central Statistics Agency (CSA) of Ethiopia is a government agencywhich is responsible to conduct census, collect data, and generatestatistical data related to the economic and social conditions of thecountry.ACTIVITIES:Created and maintained databases in a client/server environmentImplemented and supported SQL Database transactional and data warehouse infrastructure on-prem.Exported and Imported data from text files and excel to SQL server databases using bulk copy insert and BCP utility.Designed, reviewed, and created primary objects like views, indexes, stored procedures, functions, and triggers based on logical design models, user requirements and physical constraints.Worked to ensure the performance, availability, and security of databases.Led upgrades, backups, and configuration of databases and instances.Installed, authored and managed reports using SQL server Reporting Services.Created Logon trigger to validate users connecting through different applicationsPerform Database security, creating users, roles, and assigning permission to themCreated groups, roles, users and assigned access privileges to users as well as fixing issues related to orphaned usersWorked on Auditing logins and users in multiple serversCreated SQL scripts and defined functions, check constraints, indexes, and views.EDUCATIONBACHELOR OF SOCIAL SCIENCE, ALEMAYA UNIVERSITY, ETHIOPIA; July 2008Master of science: American University, Washington D.C, MAy 2017SKILLSReporting and documentationImplementing security measuresSystems AdministrationPerformance management and tuning.Pl/SQLCORE QUALIFICATIONSMS SQL server 2005/2008/2008R2/2012-2019MS Access 2005/2007/2010/2013/2016Database Tools: SSMS, Database Engine Tuning Advisor, Query Analyzer, Query Store, Visual Studio, SQL Profiler, Power BI, SQL Schema compare, ER Studio,Programming: SQL, T-SQL, XML, Power Shell ScriptingOperating Systems: Windows2012/2008R2/2003,Project management and change management tools like Jira and ServiceNowNetwork Topologies: TCP/IP, DNS, FTP, SNMP, SMTPETL And Reporting tools: SSRS, SSRS, DTS, BCPMicrosoft .NET frameworkData auditsEnsuring data integrity.Backup and recoveryT-SQLCERTIFICATIONMS Certified Database Admin for MS SQL servers 2012/14ITIL Foundation V4 CertifiedMS Certified Azure Database Administrator AssociateMS Certified Azure Data Fundamentals |
