All Lines/LANtek is seeking a Database Developer. In this role you will strategically design, write, test and implement database application code. This includes researching, designing, documenting, and modifying software specifications throughout the production life cycle. You must ensure that high levels of database performance and data integrity are met through applying design best practices, code tuning and monitoring system processes. You will also be responsible for defining standards and models for development using the database programming languages. Above all, you will make certain the database design and coding solutions meet business objectives and establishes and maintains a high level of user trust and confidence in the database group’s knowledge of and concern for the users’ business needs. You must also demonstrate a willingness to work with and mentor associates of varying levels of technical expertise within the organization.
Essential Job Functions
Provide first-level application support. Resolve problems and answer questions related to the database application code and layered products; contact vendor support when necessary; facilitate application development and customer problem resolution with optimum speed and efficiency.
Database application performance analysis and tuning closely monitor performance; identify problems and implement solutions; ensure the database is running at optimum speed and efficiency.
Provide database design research and recommend optimal schema, table and index design criteria balancing scalability, data integrity and maintainability; publish entity relationship and data flow diagrams, design standards and work with development staff; standardize environment and improve efficiency.
Perform database development. Develop application code using agreed upon database programming languages, packages, and scripting languages to support application releases; interact with development teams and understand business requirements.
Support database software upgrades and planning. Ensure database environment is updated with current stable versions of software products; maintain currency with operating system and support software.
Analyze user requirements for application releases and, based on findings, provide recommendations for solutions and estimates of work.
Conduct research and make recommendations on database design and development products, new database features, coding techniques and system enhancements.
Develop utilities for automatically monitoring the database application code performance, security and data integrity.
Adhere to departmental policies for reporting and managing trouble tickets and change control.
Establish, administer, and monitor object-level security in the database including the setting of appropriate end-user database access control levels.
Coordinate and perform in-depth tests for modified and new database processes, and other post-implementation support.
Communicate database changes, enhancements, and modifications – verbally or through written documentation – to management and team members so that issues and solutions are understood.
Assist in the development and definition of documentation and standards for the database team.
Provide direction to and work with application development staff to develop database coding standards and best practices.
Communicate complex and technical information in a concise and articulate manner.
Consistently complete tasks within agreed upon target dates.
Manage and/or provide guidance to junior members of the team.
Keep database team apprised of the status of assigned trouble tickets and change requests in preparation for the daily production meetings.
High school diploma or equivalent
Bachelor’s degree in Computer Science, Engineering, or related discipline preferred; equivalent experience is acceptable
Oracle Professional Developer certification is preferred
At least three (3) years’ experience in the design, programming, and support of application utilizing Oracle PL/SQL and SQL programming languages in a distributed Unix (Solaris preferred) computing environment
Experience developing with Microsoft SQL Server’s Transact-SQL is preferred
Thorough understanding of the Oracle database design techniques with attention given to scalability and maintainability
Thorough understanding of Oracle database application performance tuning, design, security scalability and industry best practices for application development
Excellent Oracle PL/SQL and SQL coding skills with particular attention given to detail and accuracy
Excellent Oracle SQL performance tuning and optimization skills
Extensive experience in SQL performance tuning products and utilities (e.g., TkProf, StatsPack, Oracle Enterprise Manager/Diagnostics, Explain utility, DBMS Trace, Precise, DB Tuner)
All Lines/LANtek specializes in industry standard solutions for virtualization, storage, servers, networking, backup and disaster recovery, IT staffing, Microsoft Office 365, SharePoint, 24 x 7 helpdesk, and cloud/managed services. As a value-added solutions provider, we partner with only best-of breed industry leaders that meet the business needs of our clients.
All Lines/LANtek is focused on... recruiting and retaining top talent at every level. We seek out industry leaders who will deliver value and support to our growing customer base. We are constantly searching for energetic, ethical, intelligent, and motivated individuals to join our team. All Lines/LANtek is an equal opportunity employer, and we pride ourselves on creating an environment that is safe, healthy, and productive with many opportunities for training and professional growth.