Desired Candidate Profile
"Job Description
- Design, implement and manage large-scale, high-volume relational database systems
- Design, implement and develop ETL integration processes between operational systems and enterprise data warehouse
- Data Modeling - logical and physical design in a both OLTP and OLAP environment
- Insure data quality through development and testing best practices
- Design reporting platform to support both internal and external customers
- Participates in technical design and code reviews for all new enhancements and maintenance work delivered
- Participate in collaborative work with DBAs, Software Engineer, Business Analysts, Subject Matter Experts and Project Managers to achieve software solutions
- Participate on critical projects by providing development lead and developer duties
- Perform code reviews for peers
- Work closely with development teams to provide technical guidelines and deliver projects
- Ensure a well-tested and high quality product is delivered
- Minimum 5+ years experience performing data analysis and database design on enterprise DBMS
- Significant experience in enterprise data modelling
- Excellent interpersonal and communication skills, written and oral
- Proven ability to work both independently and in team-based environments
- Expertise in relational databases, SQL Server, BIDS and experience with Power Designer or similar modeling tools
- Demonstrated experience leading the technical design of a ROLAP/ MOLAP on an enterprise data warehouse
- Demonstrated experience leading the technical design of a OLTP database design
- Experience with ETL tools, data cleansing tools, customized web reporting
- Experience through the entire development cycle to ship software a must
- Proven ability to work both independently and in team-based environments
- Must be able to facilitate clarification of customer requirements as well as systems/software architecture and design
- Must be able to define and implement design and coding reviews, and to mentor others in appropriate techniques and patterns
Develops and implements state of the art information technology strategies and platforms that meet current and future business needs. Performs all aspects of data and database administration including hardware and software evaluation and installation, logical and physical database design and implementation, structured testing of database designs, applications, and technology platforms, security administration, backup and recovery planning, capacity planning, performance and tuning, research and evaluation of new tools and techniques, and development of policies, standards and procedures related to the database environment.
Education:
UG: B.Tech/B.E. - Any Specialization
PG: Any Postgraduate - Any Specialization
Doctorate: Doctorate Not Required
Contact Details:
Keyskills:
C
Java
SQL Server
DBMS
.Net
MS SQL
Oracle
Software Architecture
Software Engineering
C++