This candidate will design and implement very large multi-tenant databases, and provide initial support of (Software as a Service) database servers operating in a hybrid hosted/cloud environment. The databases include operational data stores as well as data warehouses and data marts. Data Architect proficient with more than one DBMS platform, including relational, columnar, NoSQL, is required.
Define physical architecture, contribute to DBMS and tools selection
Design database, starting from logical through physical data models
Analyze and tune application performance by optimizing SQL, stored procedures and triggers
Advise analysts and developers on specific database features that may help with performance optimization and effective physical database organization.
Install, configure and provide technical support for databases.
Plan, design, develop, and implement:
Data migrations to/from other database servers.
Data generation for stress tests
Database backup and disaster recovery routines.
Perform fine-tuning to ensure the databases are running efficiently.
Assist with capacity planning and performance tuning for very large (Terabyte and Petabyte databases).
Required Skills / Experience
Strive to keep up with fast-paced development environment and newest technology.
Ability and willingness to travel as needed to support project teams.
Proficiency with at least two of the following DBMS: relational (such as MySQL and SQL Server, etc.), columnar (RedShift, Vertica), NoSQL (MongoDB, Redis, Cassandra)
Experience with databases both from a database administration perspective (be able to work with triggers, stored procedures, performance tune, capacity plan, etc), AND from a modeling perspective
Knowledge of different Operating Systems, to include Linux, Windows, and UNIX.
General knowledge of Security Technical Implementation Guidelines regarding security of databases and data encryption.
Experience of mature ETL implementations with job monitoring, data quality checks, notifications, etc.
Expertise and experience in dynamic SQL, stored procedures, triggers, user defined functions.
Data warehousing, OLAP and data mart experience with very large databases required.
Experience data cleansing/conversion using SQL scripts.
Knowledge and experience of object promotion strategies between databases in different development environments.
Extensive database experience in database design of relational databases and database normalization.
Experience with Change Data Capture (CDC), Transactional Replication, Log Shipping and/or equivalent techniques.
Experience with database security and maintenance of security objects.
Experience with data modeling using a tool such as ERStudio, ERwin, Power Designer.
Recent and up to date experience, such as SQL Server 2008 and MySQL 5.1 or later.
Experience performing needs assessment, database planning, design, application testing and integration, production cutover, change management and coordinating off-shore 24x7 support as needed.
Nice to Have
Cloud or remote/managed hosting environments