Aaron Sentell Email & Phone Number

Maryville, Tn, Us

Maryville, Tennessee, Us

Responsible for data movement into the Enterprise Data Warehouse, Operational Data Stores, and between operational systems on-prem and on the public cloud such as AWS. Responsible for the development of advanced data infrastructure solutions that present information for decision making, sourcing data from a variety of sources within and outside of the Clayton organization.

Maryville, Tennessee, Us

Serve as a development / production support DBA.• Review database designs to ensure they were normalized, indexed and designed to best meet the requirements of the application.• Troubleshoot poorly performing SQL queries by analyzing execution plans in cache and looking to see if the query can be rewritten to give better performance.• Install and configure SQL Server clusters.• Upgrade SQL Servers and install service packs and security patches as needed.• Daily review of database maintenance jobs, database backups, SQL Server errorlogs and Windows event logs to ensure a well-maintained and healthy database environment.• Conduct quarterly SQL Server security and backup audits.• Configure alerts and advisory conditions in SQL Sentry One for long-running queries, performance abnormalities, blocked sessions and drive capacity to name a few.• Serve as scrum master for our team, working with them to ensure our own projects don’t fall by the wayside as we strive to also keep our customers satisfied.• Lead a group to create SQL Server development and naming standards for the company.• Work with developers and managers to ensure efficient and smooth deployment of database changes while maintaining a good working relationship.• Create SSIS packages to copy, refresh and import data as well as custom packages for quarterly audits.• Ensure best practices are followed in all aspects of database administration, from granting database user permissions to configuring SQL Server optimally to writing of queries, stored procedures, triggers and views.• Ensure transaction log VLFs don’t get too high and when they do, remediate them.• Use sqlio and perfmon to test SAN disk i/o performance for POCs.• Write reports to track statistics such as index fragmentation, index usage and top poorly performing SQL statements across the enterprise.• Spearhead SQL Server performance analysis when there are severe production performance issues.

Charlotte, Nc, Us

Served as a production support DBA.• Review database designs to ensure they are optimized and well-thought out to meet the application requirements.• Review and implement changes as requested by developers, ensuring that proper procedures are being followed.• Review proposed and recommend new architectural designs for SQL Server.• Assist other DBAs with SQL Server-related processes.• Assist developers with questions relating to query design and optimization.• Supported a number of important production systems including Board of Elections, Assessor's Office, Tax Collector’s Office, Criminal Justice Information System (BizTalk), LUESA data warehouse, and jury management.

Charlotte, North Carolina, Us

Served as one of two senior-level DBAs.• Configured and supported several critical production transactional replication jobs.• Monitored, maintained, and tuned critical production database jobs including data purges, migrations, and summarizations.• Administered NetApp SAN storage allocation and capacity planning.• Designed and maintained DTS and SSIS packages, stored procedures, database jobs, and alerts.• Prepared documentation for and participated in the company-wide annual disaster recovery exercise.

Dresher, Pa, Us

Served as a development DBA on a team of DBAs for this mid-size retirement services company. Responsible for development and administration of numerous SQL Server databases including backend source systems, an enterprise-level 24x7 OLTP web database, and the company’s enterprise data warehouse.

Sole database developer and administrator for this mid-size corporate ethical compliance services provider. Responsible for development and administration of the company’s high-profile 24x7 web compliance-reporting SQL Server database.

Tempe, Arizona, Us

Key member of the database administration team for this thriving and growing municipality. Responsible for administration and operational efficiency of numerous critical Oracle and SQL Server databases including tax collection (Tata TaxMantra), utility billing (SCT Banner CIS), and human resources and financial services (Peoplesoft HR and Financial).

Sole database administrator for this mid-size financial analysis company. Responsible for development and administration of the company’s ratings database for inside trades and stock analyst recommendations.

New York, Ny, Us

Integral member of the database administration team for this large financial services company. Responsible for development and administration of numerous highly visible 24x7 web Sybase and SQL Server databases.

Bachelor'S Degree, Mathematics And Computer Science

Mathematics / Undecided