Perform database architecture for all technology-enabled capabilities in one or more lines of business.
Develop solution patterns, Data Flow Diagrams, Enterprise Data Models, ER Models, data access, data integration, database design, architectural specifications and work closely with other teams to implement them successfully,responsible for contributing to and implementing enterprise-class database architectures across the organization.
Provide standards and guidelines for the design, development, tuning, deployment and maintenance of logical data models and physical databases. Provide overview for logical and physical data model development across applications teams.
Assist in the development of policies around data access, data retention, data security and data stewardship.
Mentor less experienced members of the entire team, work with the Product owners and other team members across the enterprise to complement and complete the development process in time and with quality.
Participate in product roadmap discussions and identify key areas for improvement in the product and incorporate these goals into ongoing & future development initiatives.
Use proactive approach to identify and improve database performance, reporting, and tuning of Oracle reporting databases, reviewing and tuning SQL & PL/SQL code, designing database packages and procedures, designing database PL/SQL triggers, designing Relational Database models and testing the developed code with test data to make sure the code is error free and responsible for writing database-monitoring scripts.
Prepare and maintain reports of the entire backend development life cycle, supervision of source control of production schemes and development schemes, prepare test datasets including redacting live data or using data generation tools, prepare deployment scripts and producing deployment plans, prepare rollback scripts and producing rollback plans, create unit tests for stored procedures including set-up and tear-down operations for continuous testing and integration.
Create and manage schema documentation and other technical artifacts relating to development
Required Skills & Abilities:
Must be a detail-oriented, security-conscious database architect/developer.
Strong knowledge of Oracle 9i to 11g and/or SQL Server 2005/2008 administration and optimization.
Ability to tune poor performing queries.
Understanding of Best Practices for writing SP & Packages.
Recognized industry certifications related to Data Modeling & DBA
Must possess a passion for technology with the ability to excite and motivate other team members in various roles in the organization.
Experience building highly per-formant, scalable Data Models and Databases with use of modeling tools.
Desirable - Experience in refactoring and tuning enterprise databases and data access.
Experience working in heterogeneous database implementations (MS SQL, Oracle, etc.)
Experience with development and enforcement of standards and guidelines for database design and access
Ability to iteratively and incrementally improve both products and processes