Senior Database Developer
Senior Database Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
ABOUT THE ROLE:
The Senior Database Engineer role designs and develops robust and reliable database management systems that are secure reliable meet the organizations needs. They will develop technical platforms using modern tooling build systems and processes for operations and maintenance that facilitate production needs and speed application development. By doing so they bring significant value to the organization by ensuring that business operations run smoothly and efficiently and change can be efficiently performed and managed. The incumbent works collaboratively with cross-functional teams that include developers data analysts data scientists business analysts and other relevant stakeholders within the organization.
Responsibilities
WHAT THE ROLE WILL DO:
Design and develop database management systems standards guidelines and quality assurance for database deliverables.
- Patch and maintain database systems for optimal security and supportability
- Document and communicate database designs to relevant stakeholders and analyze the impact of the data architecture
- Code complex programs and develop logical processes on technical platforms.
Participate in quality assurance by developing and testing database code in client server environments.
- Adapt business requirements and develop data database specifications and table and element attributes for applications.
- Develop an understanding of the organizations data and storage mechanisms and assist with capacity planning.
- Determine appropriateness of data for storage and optimum storage organization.
- Determine how tables relate to each other and how fields interact within the tables for a relational model.
- Work with stakeholder to define the database Disaster Recover plan database back-up recovery and archiving strategy
This position is not eligible for sponsorship for work authorization now or in the future including conversion to H1-B visa.
Job duties include contact with other employees and access confidential and proprietary information and/or other items of value and such access may be supervised or unsupervised. The
Company therefore has determined that a review of criminal history is necessary to protect the business and its operations and reputation and is necessary to protect the safety of the Companys staff employees and business relationships.
Qualifications
Education
Bachelors degree in Computer Science Statistics or Information Systems or in lieu of a degree at least 7 years of experience in the field of database engineering and administration
Skills and Experience
- 4-6 years of experience in database engineering and administration
- Knowledge and experience with database design implementation documentation and management
- In-depth understanding of database management systems and data structures
- Experience translating business data needs into technical language
- Ability to deal with large pool of data often unstructured coming from disparate sources
- Experience with relational databases such as Oracle DB2 Postgres MySQL or Microsoft SQL Server
- Experience with query and coding languages such as SQL PL/SQL Python
- Knowledge and experience in database performance tuning backup and recovery strategies and data security practices
Preferred
- 5 years of experience developing OLTP database applications in Oracle 19c 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.
- Experience in cloud databases.
- Proficiency in data modeling software like ER diagramming tools database design tools and data modeling languages.
Technical Skills
- Programming Languages
- Database Management Systems
- Software Development Lifecyle (SDLC) Methodology
- Project Management Methodology
- Cloud Technologies & Platforms
- Continuous Integration and Continuous Deployment (CI/CD)
- Data Analysis
- Data Security
- Database Performance Tuning Backup & Recovery Strategies
- Monitoring and Logging
- DevOps Methodology
- Emerging Technologies and Automation Tools
Required Experience:
Senior IC
Employment Type
Full Time
