Senior Database Developer
Company: ITS - Integrated Talent Strategies
Location: Cleveland
Posted on: May 7, 2024
Job Description:
Integrated Talent Strategies (ITS) is seeking a Senior Database
Developer to work in the Cleveland, OH area. - This is a direct
hire position that offers a variety of great benefits, including
health insurance, 401(k), and paid time off. -JOB DESCRIPTIONThe
Senior Database Developer position is responsible for the design,
development, documentation, implementation, and maintenance of
database development in support of web applications for projects,
with a focus on Oracle database applications development, batch
processing and reporting. Maintain and troubleshoot existing
applications following standard coding practices and industry best
practices. This role develops and maintains solutions for new
requests for existing applications. The Developer resolves any
issues dealing with performance for all code released to
production. This position also assists with impact analyses of any
changes made to the database objects. This role develops design
documentation and maintains database versions of code with GIT.The
position requires participation in the complete system development
life cycle including post implementation support. The Developer
provides technical expertise to management, business users, and
works closely with other developers by writing optimized SQL
queries for integration with different applications.
-RESPONSIBILITIESEssential FunctionsStrategy & Planning
- Work with the business units to identify business requirements
for requested projects.
- Identify the technical requirements of projects.
- Analyze all aspects of the projects.
- Provide feasibility and cost/benefit analyses responses for
proposed projects.
- Plan and organize tasks, report on progress, coordinate with
additional development teams.
- Identify, design, and implement internal process improvements:
automating manual processes, optimizing data delivery, re-designing
infrastructure for greater scalability, etc.Development &
Deployment
- Perform complex programming assignments requiring an advanced
aptitude of established programming standards, methods, and best
practices.
- Design application and database components for development
projects.
- Perform analysis of business models, logical specifications,
and/or customer requirements to design and build Internet solutions
utilizing multiple technologies.
- Advanced working SQL knowledge and experience working with
relational databases, query authoring (SQL) and working familiarity
with various databases.
- Mitigate significant risks associated with projects, which have
a high technical complexity and/or involve significant challenges
to the business.
- Guide full stack developer in design approaches and teach them
to create performant queriesOperational Management
- Maintain and modify applications, make approved changes by
amending application documentation, developing detailed programming
logic, and coding changes.
- Provide support for these critical application problems and
issues.
- Analyze existing SQL queries for performance improvements and
implement the improvements.
- Act as a Subject Matter Expert in the discovery and
investigation of critical production problems as required.
- Proactively search for and make improvements on non-performant
database programs.
- Willingness and ability to coordinate the efforts of other
developers.Incidental Functions
- Conduct research into modern technologies, including tools,
components, and frameworks.
- Train and knowledge share with development teams.
- Mentor and coach developers and/or Professional
Apprentices.
- Project and task management and reporting, as necessary.
- Make presentations to management, clients, and peer groups as
requested.
- Schedule and lead project and communication meetings.
- Provide tier 2, on-call support for critical application
problems and issues.
- Analyze program performance and correct deficiencies based on
user consultation. Work with manager to prioritize approved list of
remediations.
- Assist with projects required to contribute to efficiency and
effectiveness of the work.
- Attend management meetings on behalf of team.
- Application server maintenance tasks such as: software/hardware
upgrades, patching, security configuration, batch process
maintenance and migration to new platforms.
- Address internal audit concerns to address Sarbanes-Oxley
compliance.
- Work area is adequately lighted, heated, and ventilated.
- Working outside the standard office 7.5 hours workday may be
required; on-call availability. -QUALIFICATIONSFormal Education &
Certification
- Bachelor's degree (or foreign equivalent) in a Computer
Science, Computer Engineering, or Information Technology field of
study (e.g., Information Technology, Electronics and
Instrumentation Engineering, Computer Systems Management,
Mathematics) or equivalent experience.Knowledge & Experience
- 5+ years of IT experience.
- 5+ years of experience developing OLTP database applications in
Oracle 10g/11g and UNIX/LINUX/Solaris environment within a
multi-tier environment; building and formulating business
requirements.
- Work experience with PL/SQL Types, PL/SQL Collections, SQL
Loader, PL/SQL Functions and Procedures, Packages, and Materialized
view, Triggers, Complex SQLs, and SQL Reports.
- Work experience with PL/SQL techniques in LOBs, Multilingual
character conversion; Optimize the applications using Exadata
Oracle Performance Tuning Techniques; develop Unit Testing Methods
for PL/SQL; develop UNIX scripts for batch processing and work with
Oracle RAC clusters and Exadata systems.
- Experience with relational SQL and NoSQL databases. Build
processes supporting data transformation, data structures,
metadata, dependency, and workload management.
- Experience building and optimizing data pipelines,
architectures, and data sets.Personal Attributes
- Strong and comprehensive verbal and written communications,
including ability to present ideas and solutions to all
levels.
- Responsive and alert to new learning opportunities, growth, and
development of technical, interpersonal, and business skills; able
to recognize and address areas needing improvement.
- Motivated and competent to contribute appropriate time and
effort to work needing attention.
- Attentive to detail with focus on accurate and timely
results.
- Organized and able to prioritize tasks, responding effectively
to competing needs.
- Works well with team members as a peer programmer.
- Attentive and reactive to customer needs and concerns.
- Advanced analytical and problem-solving abilities.
- Strong customer service orientation.
- Able to contribute to team effort and individual
achievement.
- Strong commitment to inclusion and diversity.About Integrated
Talent Strategies (ITS) - -ITS is an international recruiting and
staffing firm specializing in Engineering, Technical and
Professional positions. - Founded in 1984 as a subsidiary of an
engineering firm, ITS continues to remain a strategic partner for
the job seeker. - - -Our clients include some of the largest and
most respected architectural, engineering, and manufacturing
companies in business today. - Our ability to offer a wide range of
services, and the flexibility to adjust to the changing needs of
our clients, has allowed us to maintain a solid reputation for 40
years. - - -
Keywords: ITS - Integrated Talent Strategies, Parma , Senior Database Developer, IT / Software / Systems , Cleveland, Ohio
Didn't find what you're looking for? Search again!
Loading more jobs...