Sr. SQL DBA with Cassandra & Azure DB

Company: Buxton Consulting
Location: Cincinnati
Posted on: March 28, 2020

Job Description:

Minimum Position Qualifications 7-10+ years experience with database administration (SQL or non relational Databases such as Cassandra and Azure) Experience performing DBA tasks for non relational databases Proven communication and presentation skills to effectively communicate information to stakeholders at all levels within the organization. Database migration experience from SQL Server to Azure is desired Ability to interact well in a team environment. Proficient in using and designing with ERwin Data Modeler for SQL Server, Cassandra, Kafka, MS Azure Databases and Data Stores, or other similar technologies. Well-versed with the concepts and application of entity definition, idempotency, normalizationde-normalization of relational models, naming convention, data types, dimensional modeling and modeling for key-value based databases. Demonstrates solid understanding of architectural components and system design principles for effective contribution to all design discussions. Essential Job Functions Articulate andor translate business problem statements to data requirements to proactively work on design and analysis prior to system design for timely delivery Understand and review existing data models and patterns to identify improvements, recommend improvements in functionality, performance, etc. Ideate and develop multiple options for any given problem and present with sound logic and reasoning Recommend and present analysis on platforms of choice for application database, event data stores, data warehouses, reporting, archival, etc., as required Develop data migration strategies for moving, duplicating, retiring data from legacy systems to new applications Understands application code and functions and ensures database features are leveraged Works closely with application team to ensure physical data structures meets application scalability and performance needs Develop database related code (archiving and purging scripts and deploy) Review database queries and recommend query optimization and tuning Perform DDL changes and deploy to Prod Coordinate the Infrastructure requirement for moving from Stage to Production Participate in technical discussions and provide inputs wherever DBA is required Database Security, Monitoring and Availability Backup and Restores Performance Management tuning

Keywords: Buxton Consulting, Cincinnati , Sr. SQL DBA with Cassandra & Azure DB, IT / Software / Systems , Cincinnati, Ohio