Experience

Systems & Methods, Inc. (SMI)

• United States
• Financial Services
• 100 - 200 Employee

• Database Administrator

  • Sep 2017 - Present

  Tallahassee, Florida Area • Design, develop, test and maintain database schemas and applications in T-SQL. • Write, review and optimize stored procedures, triggers and other database code. • Review T-SQL code to enforce coding, security and change management standards and to optimize performance, reliability, and scalability. • Develop ad-hoc queries, data imports and data exports as needed. • Measure and monitor database systems to ensure they meet requirements for security, performance, availability, and… Show more • Design, develop, test and maintain database schemas and applications in T-SQL. • Write, review and optimize stored procedures, triggers and other database code. • Review T-SQL code to enforce coding, security and change management standards and to optimize performance, reliability, and scalability. • Develop ad-hoc queries, data imports and data exports as needed. • Measure and monitor database systems to ensure they meet requirements for security, performance, availability, and functionality. Propose and make improvements to our systems. • Check scheduled jobs and corresponding logs each day. • Develop and support disaster recovery processes, sites and strategies. • Perform regular audits of key database areas, security configuration, and probable failure scenarios. • Administer appropriate security measures to meet business requirements and corporate goals. • Comply with established processes, procedures and policies for data management and software development. • Keep documentation up to date, as systems change, through the software development lifecycle. • Provide courteous and professional customer service to all staff. Deliver customer satisfaction. • Communicate and collaborate effectively, particularly with remote team members. • Coordinate activities with the other Database Administrators and IS and IT staff, as needed. • Communicate regularly with manager on progress toward defined goals and required results. Provide specific feedback and initiate corrective action when defined goals are not met. • Work on extended or flexible schedules when necessary or when requested by Management. Show less



City of Tallahassee

• United States
• Government Administration
• 700 & Above Employee

• Database Administrator

  • Nov 2015 - Apr 2017

  Tallahassee, Florida • Monitor, administer and optimize databases and database servers for the CDA 911 Emergency System o Check database server service status, disk space availability, and database mirroring/AlwaysOn HA status o Check SQL Server Agent jobs, backup jobs, and verify database and log backups o Check SQL Server Logs, Error Logs and Windows Event Logs o Monitor database server and database activity and performance o Report and work to solve database related issues with Motorola… Show more • Monitor, administer and optimize databases and database servers for the CDA 911 Emergency System o Check database server service status, disk space availability, and database mirroring/AlwaysOn HA status o Check SQL Server Agent jobs, backup jobs, and verify database and log backups o Check SQL Server Logs, Error Logs and Windows Event Logs o Monitor database server and database activity and performance o Report and work to solve database related issues with Motorola agents o Participate in system and database upgrade testing, implementation, and post-upgrade o Generate Worst Performing Query Report for CDA databases o Research and optimize long running queries to improve database performance • Design database objects and work on Business intelligence projects o Design views, stored procedures and functions in OLTP databases and Data Warehouse o Compose ETL process in SQL Server Integration Service to export tables from OLTP databases and perform updates to the Data Warehouse o Design and edit numerous reports in the SQL Server Reporting Service, schedule automatic delivery, and configure security o Generate various ad-hoc reports by querying from databases • Compose Data Dictionary for the Data Warehouse o Document 594 tables, 612 views, 170 procedures and 75 functions  Detail information for each database object to column-level about partitions, structures, keys, relationships, indexes and dependencies o Study and document the ETL process and related SSIS packages and procedures for the Data Warehouse o Record the Source Table information from OLTP databases for tables in the Data Warehouse o Perform database comparison and update Data Dictionary after system upgrade • Design Uniform Database in Access Database for CDA customers Show less



Florida Housing

• Database Administrator

  • Mar 2008 - Nov 2015

  Tallahassee, Florida Area • Planning, designing, maintenance, securing, upgrading and administration of all databases on the FHFC network o Install, configure, safeguard, and administer database server and SQL Server instances. o Upgraded SQL Server Instances from SQL Server 2000 to SQL Server 2005 and then from SQL Server 2005 to SQL Server 2008 R2. o Configure and manage database server security and user administration. o Manage and administer SQL Server logins, users, roles and securities. o Configure… Show more • Planning, designing, maintenance, securing, upgrading and administration of all databases on the FHFC network o Install, configure, safeguard, and administer database server and SQL Server instances. o Upgraded SQL Server Instances from SQL Server 2000 to SQL Server 2005 and then from SQL Server 2005 to SQL Server 2008 R2. o Configure and manage database server security and user administration. o Manage and administer SQL Server logins, users, roles and securities. o Configure SQL Server Agent and automating administrative tasks. o Set up Maintenance Plans to check, optimize, and back up databases regularly o Monitor database server activity, performance, and user activity. o Monitor, manage and optimize SQL Server performance. o Configure and manage Database Mail. o Generate scripts for SQL Server databases, users, logins and passwords. o Develop, implement and maintain backup and recovery plans for databases, database servers and related hardware/software. o Restore databases and synchronize users. o Generate various ad-hoc reports by querying from databases. o Investigate and resolve database and related hardware/software problems. • Programming for SQL Server databases and Business intelligence projects o Work with programmers to design database tables, indexes, views, functions, and stored procedures. o Implement data encryption for PII information. o Configure, monitor and administer Reporting Service data sources, reports, user access and security. o Design and edit various reports with SQL Server Reporting Service. o Use SQL Server Integration Service to import/export/migrate/transform data between multiple data sources o Convert an Oracle 10g database to SQL Server 2005 o Work with programmers on Data Warehouse databases and SQL Server Analysis Service projects. o Work with programmers on different projects through backend databases. Show less



Florida Department of Law Enforcement

• Professional Training and Coaching
• 200 - 300 Employee

• Programmer

  • Jul 2003 - Mar 2008

  Tallahassee, Florida Area • Designed / maintained a large web-based Crime Evidence Management System: with user front-end in Visual Basic, middle-tier in Java and database in Oracle. • Designed / maintained a windows-based crime evidence reporting application: using Visual Basic .NET and XML. • Designed window-based DNA data downloader and uploader applications, to download and upload data between networks: using Visual Basic .NET and SQL Server. • Designed a web-based DNA Offender Search application: using… Show more • Designed / maintained a large web-based Crime Evidence Management System: with user front-end in Visual Basic, middle-tier in Java and database in Oracle. • Designed / maintained a windows-based crime evidence reporting application: using Visual Basic .NET and XML. • Designed window-based DNA data downloader and uploader applications, to download and upload data between networks: using Visual Basic .NET and SQL Server. • Designed a web-based DNA Offender Search application: using ASP.NET and SQL Server. • Designed a web-based crime reporting application: using ASP.NET and Oracle. • Designed / administered databases in Oracle, SQL Server and Access. • Upgraded databases from Oracle 8i to Oracle 9i, and then to Oracle 10g; and SQL Server 2000 to SQL Server 2005. Show less