Database Analyst

Defined Software Development, LLC; Tallahassee (FL); On-site; USD 70,000 - 110,000; Full time

Job summary

Defined Software Development, LLC in Tallahassee, FL, seeks experienced Database Analysts for contract consulting roles supporting government and enterprise projects.

The ideal candidate brings strong relational database, SQL, data analysis, and performance optimization skills, plus ability to document technical solutions and collaborate with stakeholders.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Management, or a related field, or equivalent experience.
• 3+ years of experience working with relational databases and SQL.
• Strong SQL development and data analysis skills.
• Experience working with database structures, tables, views, stored procedures, and queries.
• Experience troubleshooting data and database-related issues.
• Strong analytical and problem-solving abilities.
• Ability to document technical information and communicate effectively with technical and business users.

Responsibilities

• Analyze business and technical requirements related to databases and data systems.
• Develop, maintain, and optimize SQL queries, stored procedures, views, functions, and database objects.
• Analyze data structures and relationships within relational database systems.
• Support database design, development, testing, and implementation.
• Perform data analysis and identify data quality issues and inconsistencies.
• Troubleshoot database and data-related application issues.
• Support developers and technical teams with database-related requirements.
• Support data migration, integration, transformation, and validation activities.
• Monitor database performance and identify opportunities for optimization.
• Develop reports, queries, and data extracts as needed.
• Document database structures, processes, procedures, and technical solutions.
• Participate in testing and validation of database changes.
• Assist with database upgrades, modernization, and maintenance activities.
• Work with business and technical stakeholders to understand data requirements.

Skills

SQL development

Data analysis

Problem solving

Documentation

Education

Bachelor's degree in Computer Science / IS / Data Management or equivalent

Tools

MS SQL Server

Oracle

IBM DB2

T-SQL

PL/SQL

SSMS

Oracle SQL Dev

Power BI

ETL

Informatica

Data warehousing

Data modeling

Perf tuning

Azure SQL

Job description

Location: Tallahassee, FL

Job Type: Contract / Consulting

Position Summary

Defined Software Development is seeking experienced Database Analysts for contract consulting opportunities in the Tallahassee area. Our consultants support government and enterprise technology projects across a variety of IT environments. The ideal candidate will have experience working with relational databases, SQL, data analysis, database development, performance optimization, reporting, and data-related problem solving.

Specific project assignments, requirements, and durations may vary based on client and project needs.

Responsibilities

• Analyze business and technical requirements related to databases and data systems.
• Develop, maintain, and optimize SQL queries, stored procedures, views, functions, and database objects.
• Analyze data structures and relationships within relational database systems.
• Support database design, development, testing, and implementation.
• Perform data analysis and identify data quality issues and inconsistencies.
• Troubleshoot database and data-related application issues.
• Support developers and technical teams with database-related requirements.
• Support data migration, integration, transformation, and validation activities.
• Monitor database performance and identify opportunities for optimization.
• Develop reports, queries, and data extracts as needed.
• Document database structures, processes, procedures, and technical solutions.
• Participate in testing and validation of database changes.
• Assist with database upgrades, modernization, and maintenance activities.
• Work with business and technical stakeholders to understand data requirements.

Required Qualifications

• Bachelor''s degree in Computer Science, Information Systems, Data Management, or a related field, or equivalent experience.
• 3+ years of experience working with relational databases and SQL.
• Strong SQL development and data analysis skills.
• Experience working with database structures, tables, views, stored procedures, and queries.
• Experience troubleshooting data and database-related issues.
• Strong analytical and problem-solving abilities.
• Ability to document technical information and communicate effectively with technical and business users.

Preferred Qualifications

Experience with one or more of the following:

• Microsoft SQL Server
• Oracle
• IBM DB2
• T-SQL
• PL/SQL
• SQL Server Management Studio
• Oracle SQL Developer
• Power BI
• ETL processes and data integration
• Informatica
• Data warehousing
• Data modeling
• Database performance tuning
• Data migration and conversion
• Azure SQL / Microsoft Azure
• Reporting and business intelligence
• Enterprise application databases
• Government or public-sector data environments