| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Senior SQL Database AdministratorEMAIL AVAILABLE PHONE NUMBER AVAILABLELINKEDIN LINK AVAILABLE Chicago ILHighly skilled senior database administrator with rich experience supporting, designing, and delivering heterogenous database solutions in Microsoft (MS), MS SQL, and mixed database environments.Proven success in managing all aspects of database maintenance, including installation, patching, migration, tuning, and upgrades. Adept at leading and training junior DBAs and managing the offshore teams to ensure alignment with companies core IT objectives. Excel at developing, configuring, and managing SQL server systems to meet corporate and client requirements. Proficient in organizing, storing, and analyzing data with attention to quality, security and confidentiality. Ability to support business objectives, optimize network performance, and ensure technical troubleshooting. Excellent interpersonal, communication, and problem-solving skills. Sharp and adaptive; able to quickly learn and apply new concepts, techniques, and technologies.Areas of ExpertiseStorage Management TechniquesData Modelling & Database DesignSystem AdministrationETL & BIPerformance OptimizationDatabase schema creationData Security & IntegrationTuning CapabilitiesCost Analysis & ReductionTeam Leadership & TrainingDisaster Recovery PlanningProject ManagementTechnical ProficienciesMicrosoft SQL Server Enterprise SQL Clustering SQL AlwaysOn Availability SQL Replication SQL Query StoreSQL Reporting Service (SSRS) ETL SQL Business Intelligence Tools Integration Services (SSIS)SOX Compliance Mixed Database Environments T-SQL Performance TuningData Modeling Data Dictionary Database Design Data Migration Data IntegrityCareer ExperienceRESERGY Solutions Inc. Aurora, IL 2014 PresentSQL Database ConsultantPerform as a subject matter expert while delivering SQL support and ensuring development, implementation, migration, and management of complex large-scale solutions across Microsoft and Microsoft SQL and mixed database environments. Deliver effective consultation to clients on SQL performance troubleshooting and remediation. Conduct SQL performance analysis and provide effective recommendations for efficient workflow.Major Contributions:Conducted review of current SSIS processes being used by migration team developing and delivering enhancements and recommendations for large multi-billon row table migrations.Planned and executed SQL upgrades and SQL performance analysis with a focus on identifying and remediating performance bottlenecks.Delivered effective recommendations to improve database performance by identifying tables missing indexes, too many indexes, unused indexes, long running queries, SQL waits, locks, blocking and deadlocks.Contech Systems IncContractor at United Health Group, Remote 2023 - 2024Sr. Software EngineerDevelop, implement, and optimize complex SQL stored procedures.Contribute and lead troubleshooting problematic or slow SQL queries.Design Tables, Stored Procedure, Views, Indexes, Cursors, Triggers, User defined functions, Relational database models & data integrity according to business rules.Develop process to Import extracted MongoDB collections into SQL via MongoDB collection dumps and MongoDB Changestream process by parsing and transforming the JSON Data with SQL OPENJSON.ExperisContractor at WEC Energy Group, Chicago, IL /Milwaukee, WI 2015 2022Sr. SQL Database AdministratorMonitored and managed 24x7 large scale multiple 10+ terabyte (TB) databases with a keen focus on ensuring data integrity and security. Ensured nightly batch processes completed in timely manner, along with troubleshooting processes that have degraded by integrating performance enhancements. Acquired retention days quickly for large multi-billion row tables, such as extracting to archive database followed by a purge process on both live; archived databases on determined schedule and retention in both user test environment and production. Utilized SQL SSIS packages and SQL jobs to deliver scalable, reliable, and high performing backups, restores, performance tuning of indexes and ETL automated data export/import processes. Maintained test and established new environments with ad hoc request refreshes. Facilitated stakeholders decision-making by providing quarterly database growth and projections for SAN space planning. Delivered strategic and timely support to all database emergencies and outages. Contributed to the backup and disaster recovery database planning including SAN replication of database files.Major Contributions:Ensured three multi company data migrations into one customer facing/billing application by managing and leading the DBA teams and supporting ancillary teams during 3-day migration process 24/7. Included the life cycle of Windows servers, capacity planning, SQL upgrades, clustering, AlwaysOn high-availability, and SAN migrations.Conducted ETL analysis ensuring correct data mappings from source to target and post conversion data quality validating the data integrity is accurate and no data loss or discrepancies, as per business requirements.Successfully applied large table structure changes using SSIS ETL following metadata application standards and/or updating to the new metadata set.Restructured user access testing and training environments from production on a weekly basis to fix-it by implementing an automated streamlined process.Developed and delivered index maintenance strategies, performance analysis collections via SQL jobs and/or SQL stored procedures, views, queries, triggers, and SQL alerts using third party Idera Diagnostic Manager.Crafted and presented automated daily email reports on high CPU, blocking and deadlocks via SQL jobs.Offered effective leadership acumen while leading and training Offshore DBAs to achieve set performance goals.Ensured application database SOX compliance via database security and personal Identifiable Information (PII) data is scrubbed, prior to sending database backups to application vendor.Infutor Data Solutions (now Verisk Marketing Solutions), Oak Brook Terrace, IL 2013 2015Database AdministratorAdministered all facets related to the installation, maintenance, and troubleshooting of SQL transactional replication. Leveraged SQL SSIS packages and SQL jobs to develop and implement scalable, reliable, and high performing ETL automated data import/export processes. Monitored and managed database operations on daily basis and ensued 24x7 databases administration. Ensured efficient and optimal data access, return of data and data updates by reviewing and assessing existing SQL queries, functions, stored procedures, and indexes. Documented application database designs, including tables and indexes, database standards, data load processing standards, database security and routine maintenance.Major Contributions:Executed ongoing administration work with a keen focus on assisting office employees to resolve clients key concerns and deliver effective solutions.Served as a key point of contact while developing and delivering databases for a rapidly growing data compiler and database marketing company.Successfully developed logical data models using standardized metadata, translating into physical database designs.Developed and deployed data dictionary standards across product database tables and database naming conventions. Established a new path to use the data dictionary standards in future sprints and releases.Ensured efficient delivery of optimal databases by consulting on existing data models, data sets, source data and database designs, making recommendations, and implementing changes ensuring data integrity and accuracy.Adhered to the company policies while implementing data retention strategies, cleansing data, capacity planning for server upgrades, and executing disaster recovery plans.Contributed to technical troubleshooting, SQL query and index analysis, database tuning, and performance monitoring to deliver effective recommendations for efficient workflow.Additional ExperienceDatabase Administrator Neal, Gerber and Eisenberg LLP, Chicago, ILContractor - Solution Partners, Naperville, ILSystems Engineer - Seyfarth Shaw LLP, Chicago, ILNetwork Engineer - Comp U Time, Inc., Bloomingdale, ILEducationMaster of Business Administration Benedictine University, Lisle ILBachelor of Science in Computer Science Elmhurst College, Elmhurst IL |
