Senior Database Architect

» Senior Database Architect
Information Technology
in Ft Lauderdale
, FL
Reference: 19-01722

Job Description:

A Senior Database Architect is responsible for building Enterprise applications in Cloud and local internal systems. Your primary responsibilities will be to design and develop these database layers and help in architecting the applications that need to scale up to the Cloud. You would need to coordinate with the rest of the team working on different layers of the application and environmental infrastructure. Commitment to collaborative problem solving, sophisticated design, and quality product is essential. Looking for a passionate database architect who has experience in various databases including noSQL.

Responsibilities:

  • Provide development and administration support for various databases, primarily SQL server databases in a client-server development environment including stored procedures and triggers, SQL and index performance tuning, and database design and file storage
  • Develop, deploy, and maintain Extract-Transform-Load (ETL) scripts and schedules
  • Develop and implement all database indexing, maintenance, backup, transformations, and stored procedures
  • Expose data to application various business tiers
  • Assist software developers in implementing appropriate data access permission schemas
  • Participate in the refinement and development of user stories, assessing the impact of new development on current database implementation and providing level of effort estimates during sprint planning
  • Communicate with technical and product product owner stakeholders to help them anticipate and mitigate configuration management issues
  • Responsible for and/or support the development of engineering artifacts and documenting the system’s design and architecture

Required Skills:

  • 10+ years of work experience in database design, architecture, development and production support for enterprise SaaS applications
  • Hands-on database tuning and troubleshooting experience (partitioning, compression, indexing, statistics and query optimizer)
  • Life cycle experience in architecting new or redesigning existing systems
  • Strong experience with database management in a commercial Cloud environment (AWS, Azure)
  • Working knowledge of AWS RedShift, AWS DynamoDB, and AWS Data Pipeline
  • Expertise using other RDBMS platforms such as Microsoft SQL server
  • Working knowledge of Java, PHP, Perl or other programming languages
  • Deep knowledge of transactional database and data warehouse architecture, design, and development (star schema, high dimensional model, fact tables, etc.)
  • Mastery in developing/instantiating conceptual, logical, and physical data models
  • Extensive data migration skills and working experience with ETL concepts and tools
  • Deep knowledge of relational database’s objects and their functions
  • Deep expertise in all aspects of management and development in SQL server versions
  • Strong ability to independently write complex SQL queries to answer multi-layered analytics questions from team members and clients
  • Experience performing remote server management and troubleshooting
  • Solid understanding and work experience with Schema-less data structures
  • Experience with high transaction volume e-commerce or related applications
  • Strong computer science fundamentals in data structures, algorithms, and complexity analysis
  • Strong interpersonal and communication skills to facilitate working well in a team and mentor more junior developers
  • Highly innovative, flexible and self-directed
  • Experience with the full development life cycle from inception to production