Database Developer

Company: Full Sail University
Location: Winter Park
Posted on: April 21, 2024

Job Description:

If you're looking for the chance to learn, grow, and make a contribution to the community, look at employment opportunities with Full Sail University. You'll find your choice of career opportunities, great benefits, an environment that welcomes and values creativity, and a work experience that is both challenging and rewarding!

The Database Developer is responsible for working with clients to design and implement data driven solutions in a logical and functional manner. They will be responsible for developing scripts, ETL processes, functions, and stored procedures as well as cloud-based deliverables. This role will assist in evaluating, designing, reviewing, and implementing data driven solutions in support of clients and the Data Management team. Database Developer will serve as a backup Database Administrator for the DBA team and will be responsible for leading the creation and management of new Data Warehouse Initiative.
Essential Duties and Responsibilities:

• Database developer will be responsible for the following:
  • Creating data pipeline that will populate cloud-based data warehouse solution.
  • Management, maintenance, and further development of data warehouse.
  • Development of tableau reports that leverage the data warehouse data.
  • Assistance with architecting and supervising the design of the data warehouse.
  • Educating the remainder of the data management team in theory, usage, maintenance and development of data warehouse. Other Responsibilities:
    • Database developer will also assume database administrator role with responsibilities up to and including:
      • Upgrades of existing SQL Server environments
      • Assistance with database portion of application upgrade releases (may include overnight work 2-3 days a year).
      • Implementation of SQL Server security best practices
      • Performance tuning of stored procedures, views and T-SQL statements.
      • Monitoring and maintenance of existing SQL Server environment
      • Database developer may also be called upon to assist with projects within Full Sail's AWS cloud environment. Services utilized include but are not limited to the following:
        • DMS
        • S3
        • IAM
        • RDS
        • Glue
        • Athena Supervisory Responsibilities: No
          
          Competencies:
          • Data warehouse technologies such as AWS Redshift or SQL Server Analysis Services
          • T-SQL
          • SQL Server 2016-2019
          • ETL: SQL Server Integration Services as well as Cloud based ETL tools such as Glue and DMS.
          • Strong Documentation Skills
          • AWS or other cloud-based experience. Education and/or Experience:
            • 5-7 years working with data warehouses Certificates, Licenses, Registrations:
              • AWS Solutions Architect (Associate or Professional) or other similar certification
              • AWS Developer Associate or similar certification. Computer/Equipment Skills:
                • Proficiency using the following software programs:
                  • SQL Server Management Studio (SSMS)
                  • SQL Server Integration Services (SSIS)
                  • SQL Server Reporting Services (SSRS)
                  • Microsoft Suite: MS Word, PowerPoint, Excel, and Outlook
                  • Programming Language: JavaScript, C# or Python
                    
                    Environmental Factors/Physical Demands:
                    
                    On occasion work will be required to be performed after hours, including nights, weekends, and holidays if a critical system goes down or an upgrade needs to be performed. Work is performed in a virtual environment. While performing the duties of this job, the employee is regularly required to have the ability to maintain active customer and employee communication; access, input and retrieve information from the computer system; enter alpha-numeric data into a computerized system often while listening on the telephone. May be subject to bending, reaching, kneeling, stooping and lifting up to thirty (30) pounds.
                    
                    Full Sail is an Equal Opportunity Employer.

Keywords: Full Sail University, Pine Hills , Database Developer, IT / Software / Systems , Winter Park, Florida