| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
SQL Database AdministratorLocation: Charlotte, NCPhone: PHONE NUMBER AVAILABLEE-mail: EMAIL AVAILABLEProfessional SummaryDatabase administrator with over 8 years of extensive experience in database architecture, configuration, analysis, tuning, data migration, development, and support. Proficient in all SQL Server versions, with a strong track record of optimizing database performance and ensuring data integrity. Proven track record in maintaining high availability and performance of corporate applications across diverse environments. Skilled in interpersonal communication and documentation, adept at collaborating with cross-functional teams to achieve organizational objectives.Technical SkillsExpertise in installation, upgrade, configuration, and administration of SQL Servers in both standalone and clustered environments, ensuring optimal performance and reliability.Installed and configured SQL Server along with SSIS, SSRS, and SSAS, including service packs, to support diverse business needs.Conducted seamless migrations from SQL Server 2000 to 2019, ensuring data integrity and minimal disruption to operations.Proficient in performance tuning, query optimization, client/server connectivity, and database consistency checks using DBCC utilities, enhancing system efficiency and responsiveness.Implemented and managed Azure cloud infrastructure for various projects, ensuring scalability, reliability, and security.Deployed virtual machines, storage accounts, and networking resources in Azure to support application development and production environments.Configured Azure services such as Azure App Service, Azure SQL Database, and Azure Functions to optimize performance and cost-efficiency.Automated deployment processes using Azure Resource Manager (ARM) templates and PowerShell scripts, reducing deployment time by 30%.Conducted training sessions for team members on Azure cloud technologies and best practices, fostering knowledge sharing and skill development.Designed, implemented, and managed high availability solutions, including database mirroring, log shipping, replication, clustering, and Always On, to ensure continuous operations and minimize downtime.Demonstrated solid experience in SQL Server security, controlling permissions, and monitoring audit events to safeguard sensitive data and comply with regulatory requirements.Managed security and database permissions, ensuring appropriate access controls and data protection measures.Implemented proper alerts for system errors, resource deficiencies, fatal database errors, and hardware issues, ensuring proactive monitoring and timely resolution of issues.Provided daily administration and performance monitoring of database-related systems, ensuring optimal system health and performance.Managed SQL Server Agent, automating routine tasks and ensuring timely execution of scheduled jobs.Created and reviewed databases and database objects, including tables, triggers, views, stored procedures, indexes, defaults, and rules, to support application requirements and optimize performance.Collaborated with developers to design efficient database structures and optimize database objects, enhancing application performance and scalability.Designed and implemented backup and restore strategies for SQL Server databases, ensuring data integrity and availability in case of disasters.Proficient in writing and tuning T-SQL queries (DML/DDL/DCL), optimizing database performance and ensuring efficient data retrieval.Supported database environments spanning SQL Server versions 2000 to 2019, ensuring smooth transitions and compatibility across platforms.Experienced in data migration between environments using SSIS packages, backup/restore, detach/attach, and import/export wizard, ensuring seamless data transfer and integrity.Ensured uniform application of service packs and hot-fixes across all environments, maintaining system security and stability.Provided change management support by reviewing, approving, and implementing changes affecting databases, ensuring compliance with organizational standards and procedures.Supported both production and development databases 24/7/365, resolving issues promptly and minimizing service disruptions.Demonstrated excellent communication skills, self-management, and teamwork in multicultural environments, fostering collaboration and synergy.Proficient in writing documentation and providing on-call support on a rotation basis, ensuring comprehensive support coverage and knowledge sharing.Work History2018 -CurrentSQL Server Database AdministratorRed Ventures LLC, Charlotte NCManaged the maintenance and performance of critical SQL Server RDBMS systems, ensuring availability and consistent performance of corporate applications.Developed and sustained the SQL Server Warehouse, ensuring operational readiness, executing data loads, and performing data modeling to support multiple development teams.Provided support for an enterprise application suite of program management tools utilizing the data warehouse.Oversaw SQL Server databases across multiple lifecycle environments, from development to mission-critical production systems.Assisted developers with complex query tuning and schema refinement to optimize system performance.Monitored Azure resources and implemented proactive measures to optimize performance, enhance security, and minimize downtime.Collaborated with cross-functional teams to design and implement solutions that meet business requirements and comply with best practices.Independently analyzed, solved, and corrected issues in real-time, providing end-to-end problem resolution.Configured and maintained database servers and processes, monitoring system health and performance to ensure high levels of availability and security.Applied data modeling techniques to meet integration and performance expectations for development and implementation efforts.Automated regular processes, tracked issues, and documented changes to improve efficiency and transparency.Conducted scheduled maintenance and supported release deployment activities outside of regular hours.Shared domain and technical expertise, providing mentorship and cross-training to peers and team members.Provided cross-platform support for Oracle, MySQL, PostgreSQL, Peyton, Redshift, and MongoDB.Implemented operational policies, procedures, controls, and standards to ensure consistency and compliance.Developed and maintained automation efficiencies using scripting languages (T-SQL, PowerShell) in a Windows environment.Created implementation guides and maintenance processes documentation to ensure consistency and knowledge transfer.Conducted roadmap planning and maintenance management to align database strategies with organizational goals.Performed database environment capacity planning and availability management to meet business demands.Collaborated with partners to resolve database policy compliance and vulnerability violations.Provided 24x7 on-call support for complex production problems, including escalation and communication to senior management.Supported warehouse environment with operational support of ETL processes, ensuring data integrity and reliability.Environment: SQL Server 2005, 2008, 2008R2, 2012, 2014,2016, 2017, 2019, AWS RDS, Redshift, Apache Hadoop, Spark, Scala, AWS S3 Datalake, AWS EC2, Windows Server 2002/2012, 2003, Clustered, SSIS, SSRS, Management Studio, T-SQL, SQL Profiler, Always On, Clustered, SSIS, SSRS, SQL Query Analyzer, SCOM, Logshipping, Transactional Replication2016-08 - 2018-11Database AdministratorRawlings Group, Louisville KYManaged multiple SQL Server instances in production, development, and quality assurance environments within the healthcare sector.Conducted comprehensive database administration for SQL Server installations, encompassing capacity planning, installation, upgrading, configuration, patching, and all functions to ensure high availability, performance, and security.Installed and configured SQL Server versions 2014, 2012, 2008, and 2005, along with SSIS, SSRS, and SSAS components.Successfully migrated databases from SQL Server 2005 and 2008 to SQL Server 2012, ensuring seamless transition and minimal downtime.Implemented high availability and disaster recovery solutions, including clustering, mirroring, log shipping, and AlwaysOn, to safeguard critical data and minimize service disruptions.Provided strategic consultation to senior management on impactful database solutions and management topics, influencing decision-making processes.Led cross-functional initiatives with multiple groups, driving enterprise-wide improvements in data management practices and technologies.Offered oversight, mentoring, and leadership to junior staff, fostering their professional growth and development.Spearheaded the planning, analysis, design, implementation, maintenance, and control of server-class databases, guiding organizational decision-making processes.Designed highly complex logical and physical databases within SQL Server environments, ensuring optimal performance and scalability.Conducted advanced data modeling, mapping, integration, and capacity planning activities, facilitating efficient data management strategies.Developed and enforced management policies, procedures, and standards, aligning database practices with business requirements and industry best practices.Implemented performance monitoring, analysis, and tuning strategies using T-SQL, profiler, tuning advisor, indexes, statistics, and query plan analysis techniques.Created, reviewed, and optimized database objects, including tables, triggers, views, stored procedures, indexes, defaults, and rules, to enhance database efficiency and functionality.Implemented transactional replication and merge replication methodologies to ensure high availability of databases and data consistency.Troubleshooted and resolved database integrity issues, ensuring data accuracy and reliability.Deployed and managed AlwaysOn Availability Groups and clustered environments, enhancing system resilience and fault tolerance.Executed database recovery procedures from backups in disaster scenarios and implemented Point-In-Time Recovery solutions to minimize data loss.Developed and maintained maintenance plans for backups, history cleanup tasks, and index rebuilding operations, optimizing database performance and reliability.Contributed to the development and implementation of backup strategies, ensuring data protection and compliance with organizational policies.Managed database security by granting permissions to users, roles, and objects, and administered security for server logins (Windows and SQL Accounts).Effectively managed time and priorities in a fast-paced 24/7 DBA support environment, ensuring timely resolution of issues and minimal service disruptions.Environment: SQL Server 2005, 2008, 2008R2, 2012, 2014, Windows Server 2012, 2008R2, 2008, 2003, Clustered, SSIS, SSRS, Management Studio, T-SQL, SQL Profiler, SQL Query AnalyzerEducationBSc. Pharmaceutical ScienceThe Ohio State University - 2012 |
