Job Description

21Tech is looking for a DATABASE ADMINISTRATOR to support our Client in SAN FRANCISCO, CA.  This is a great opportunity to be part of a successful, growing, entrepreneurial international business and a chance to work with many different applications and data networks.

PROJECT TIMEFRAME: 12 months with possibility of extension

POSITIONS AVAILABLE: 1

CANDIDATES MUST __ PROVIDE __ 3 VERIFIABLE REFERENCES OF SUCCESSFUL NEEDS ASSESSMENTS THAT HAVE BEEN USED BY CLIENTS TO IMPROVE THEIR PRACTICES.

RESPONSIBILITIES:

·       Research, analyze, present alternatives, including cost and performance analysis, and recommend cloud alternatives to the current Oracle database

·       Develop and document a plan to migrate to a new database, including conversion, data migration, and data reconciliation.

·       Design, develop, and document the structure for the new database, including database models and schemas, ensuring the integrity and security of the database.

·       Lead and execute the build and deployment of the new database.

·       Lead and execute the migration to the new database, including conversion and data reconciliation.

·       Administer the new database and provide plans and instructions for administration activities.

·       Conduct performance optimization to meet SLA’s.

·       Analyze reported issues and provide recommendations for resolving.

·       Develop auditable data scrubs to correct data issues.

·       Monthly status report.

MINIMUM JOB-SPECIFIC SKILLS/QUALIFICATIONS REQUIRED (IN ORDER OF RELATIVE IMPORTANCE):       

·       5+ years’ experience designing complex, normalized, relational application databases, including Oracle.

·       5+ years’ experience designing, developing, and deploying relational databases in a cloud environment, especially Azure and/or AWS, ensuring the integrity and security of the database.

·       Experience in migrating an on-premise or cloud Oracle DB to any one of the cloud-based solution such as Azure SQL, Azure Oracle in VM, AWS Aurora, or AWS RDS.

·       Excellent written and verbal communication skills, with both technical and non-technical audiences.

·       Experience analyzing requirements, researching alternatives, and making successful recommendations for database solutions.

·       Experience developing and executing successful migration plans from one database solution to another (e.g., Oracle to Azure SQL, not from one Oracle DB to another Oracle DB).

·       Demonstrated knowledge and successful execution of the principles and techniques of the full lifecycle of database design, modeling, development, testing, and documentation.

·       Demonstrated knowledge and successful execution of the principles and techniques of systems implementation including conversion, data reconciliation, and documentation.

·       Experience developing and documenting relational database models, based on functional specifications and conceptual object models.

·       Experience developing and documenting database schemas based on relational models.

·       Experience building and deploying relational databases based on database design, models, schemas.

·       Experience administering relational databases and conducting performance optimization to meet SLA’s.

·       Experience analyzing database configuration to research and resolve database and application issues

·       Extensive experience with Oracle function and procedure packages using SQL.

·       Experience with database performance monitoring and tuning tools and techniques.

·       Experience developing data scrubs to correct data based on knowledge of the application

·       Principles of information systems architecture for enterprise-wide systems deployment such as multi-tier, web-based, distributed system architecture and development principles, and internet/intranet application delivery mechanisms

·       Knowledge of the Service Oriented Architecture (SOA) environment and Object-Oriented design and development.

·       Experience coordinating with 3rd party vendors to resolve database software issues.

ADDITIONAL SKILLS/QUALIFICATIONS DESIRED:        

GENERAL:

·       Experience with software and tools used by the Judicial Council IT office including, ERwin Data Modeler, Toad, Eclipse, JIRA, Clear Quest, and Subversion.

·       Knowledge of other application development technologies, including Linux, J2EE, J2SE, Hybernate, Lucee, ColdFusion, JavaScript, and Crystal Reports.

ABOUT 21TECH: 21Tech services Public and Private sector organizations across the U.S. and Canada, especially those managing asset intensive operations.  We specialize in managing large-scale transformations and application implementations as well as business processes improvement initiatives. We also provide system integration services for Infor products such as EAM, CSF, WFM, d/EPM, Birst, etc.  Our Clients rage from the world’s top transit agencies, large cities and municipalities, Fortune 100 companies, and many more.