Database Developer: Tessera

Database Developer

Description

The Database Developer’s role is to strategically design and implement databases across the organization, while ensuring high levels of data availability. This individual is also responsible for defining standards and models for databases and database administration and maintenance. Additionally, the Database Developer will evaluate and recommend all technology components, such as software, hardware, and networking capabilities, for database management systems and their applications.

Responsibilities

Strategy & Planning

· Assess and cultivate long-term strategic goals for database development in conjunction with end users, managers, clients, and other stakeholders.

· Analyze user requirements and, based on findings, design functional specifications for databases and database applications.

· Plan and implement capacity and resource expansion to ensure scalability of company databases.

· Assist with the design of redundant systems, policies, and procedures for disaster recovery to ensure effective availability, protection, and integrity of data assets.

Acquisition & Deployment

· Design and deploy data table structures, forms, reports, and queries.

· Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.

Operational Management

· Coordinate and work with other technical staff to develop relational databases and secondary data structures such as star schemas

· Develop automated database applications, where necessary, using the applicable database packages.

· Identify data entry, retrieval, change, and delete issues, and work to ensure a high level of data availability.

· Work with IT project team members to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion.

· Identify inefficiencies in current databases and leverage solutions.

· Install and configure relevant components to ensure database access.

· Diagnose and resolve database access and performance issues.

· Perform cost estimates for data migration to new databases during upgrades, and plan and coordinate these migrations.

· Evaluate and select database components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.

· Responsible for maintaining database and data security

· Responsible for creating multiple formats of data integration outputs including Excel spreadsheets, XML data formats and complex data transformations

· Responsible for database design and various DBA activities including, but not limited to; performance tuning, partitioning, database replication, backup and restore, maintenance plans

· Mentor and/or provide leadership to junior members of the team.

Position Requirements

Formal Education & Certification

· College diploma or university degree in the field of computer science, information systems, or computer engineering and/or 5 years equivalent work experience

Knowledge & Experience

· Working technical experience with developing, installing, configuring and supporting multi-terabyte database environments.

· Minimum 5 years experience with database platforms, including but not limited to, MSSQL 2000, 2005, 2008, Oracle 9,10,11

· Experience with database design applications

· Strong understanding of relational database structures, theories, principles, and practices.

· Hands-on experience with business requirements gathering/analysis.

· Familiarity with Virtual Machine environments utilizing VMWare and NetApp storage

· Experience with data processing flowcharting techniques.

· Proven project management experience.

· Strong understanding of the organization’s goals and objectives.

· Good knowledge of applicable data privacy practices and laws.

Personal Attributes

· Exceptional analytical, conceptual, and problem-solving abilities.

· Strong written and oral communication skills.

· Strong presentation and interpersonal skills.

· Ability to conduct research into database issues, standards, and products.

· Ability to present ideas in user-friendly language.

· Able to prioritize and execute tasks in a high-pressure environment.

· Experience working in a team-oriented, collaborative environment