Overview
General Statement of Duties:
Application SQL Developer is involved in requirements definition, analysis, design, development, deployment, maintenance and enhancement of applications working as part of application development team, with specific focus on databases.
Essential Duties and Responsibilities:
Application Database Administration – Responsible for the administration of existing application databases and working with system DBA’s to create new databases as necessary. Create tables, views, indexes, stored procedures, triggers, and grant permissions. Design and document database architecture. Proactively monitor databases for optimal performance and capacity constraints. Monitor scheduled database jobs to ensure successful and timely completion. Work with system DBA’s to analyze DBMS, tune databases for optimal efficiency, and monitor and administer database security, disk space, auditing, and checking for security problems.
Development Activities – Responsible for writing complex SQL queries, reviewing, promoting, and monitoring changes to the test and production databases. Actively participate application development lifecycle including design, development, and release. Assist the development staff in creating database designs that meet development requirements and optimal performance requirements. Establish standards and best practices for SQL. Interact with and coach developers in optimal SQL techniques. Review scripts before they are applied to test and production databases. Develop database utilities and automated processes. Review existing code for the need of performance tuning, maintain indexes and statistics. Create and maintain SSIS packages and SSRS reports for business communities. Leverage use of Powershell scripts for data manipulation and automation.
Quality Assurance – Trouble shoot application data issues and have them addressed promptly. Ensure that database upgrades and database refreshes are in line with development and security requirements. Conduct post-implementation follow-up activities.
Information Security – Work with IT information security management team to understand information security requirements and follow industry best practices to safeguard Non-Public Information entrusted to IT. Review databases, applications and operational deployments to identity system security vulnerabilities and present ideas on system improvements.
Management Reporting – Develop and maintain reporting standards on database performance and usage forecasts.
Technology – Achieve and maintain a current working knowledge of advancements in database management systems. Stay up to date on new versions of supported DBMS’s and the advantages/disadvantages that each offers. Attend seminars and conferences designed to build knowledge of the same. Achieve and maintain working knowledge of different file formats including XML, JSON, CSV, Excel, formatted text etc. and know how to extract data from them and transform it into SQL tables, also know how to transform SQL data into these formats when requested.
This list of duties and responsibilities is not intended to be all-inclusive and can be expanded to include other duties or responsibilities that management deems necessary.
Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Education/Experience: Bachelor’s Degree in Computer Science or related field is required. Three years minimum of Database Administration. Experience with database design and application development methodologies (such as Agile) are desirable. Certain programming experience is required and coding experience in an object oriented language such as .Net, Java, c++ is highly preferred. Experience within the student loan servicing industry will be beneficial.
Technical Skills: Applied knowledge of Database Administration on Microsoft SQL Server 2008 R2 and newer. Extensive expertise with Microsoft SQL Server, SQL queries, stored procedures, data structures and experience with Agile practice and Change Management. Knowledge of PowerShell is beneficial. Knowledge of SQL Server Integration Services, Reporting Services and Audit is essential.
Communications Ability: Good interpersonal and communication skills (both written and verbal).
Reasoning Ability: Ability to effectively adapt to a dynamic, constantly changing, priority shifting environment. Sound analytical and problem solving skills.
Other Characteristics: High degree of confidentiality and professionalism. Must be able to work with team members and user community. Ability to interact effectively with all levels of staff. Commitment to service and excellence. Self-direction with the ability to manage multiple projects and responsibilities. Dedication to professional development in the IT field through continuing education, certification, and/or seminar attendance.