SQL Architect

» SQL Architect
Information Technology
in Clearwater
, FL
Reference: 19-03559

Position Description: 

  • Serves as senior database technology lead to the IT Department in developing and linking database technical solutions to company requirements, goals, and objectives
  • Is also a technical advisor and subject matter expert on the effective use of database technology in developing business solutions that meet the needs of our client, LLC, and its customers
  • Advises IT teams and executives on business processes regarding the feasibility of proposed approaches to project solutions in terms of systems capabilities and established technology architecture guidelines
  • Responsible for Logical and physical data modeling, as well as overall database design, development and implementation of complex database environments that exist across all platforms
  • Designs and maintains database structures including tables, views, synonyms, procedures, functions, indexes, materialized views, partitioning strategies, and compression
  • Responsible for research and development, as well as proof of concepts for solving business problems or concepts not addressed by existing technology standards, especially focused on data management systems
  • Perform database administration, security, system analysis and database analysis and strategic planning, development and implementation, and maintenance of database management systems utilizing Microsoft SQL Server
  • Responsible for creating, testing, and modifying reports for web based application using Microsoft’s SQL Server Reporting Services (SSRS)
  • Participates in establishing standards and best practices in deploying database technology solutions
  • Assists in developing and managing the established technology architecture governance process
  • Endeavors to minimize component complexity in the design and deployment of the enterprise technology architecture through standards-based product(s) selection and implementation
  • Ensures uniformity across IT systems infrastructure to enable effective application integration capabilities
  • Champions enterprise wide compliance with established technology standards
  • Champions the deployment of enterprise-wide systems management processes and techniques
  • Champions’ enterprise-wide technology re-uses and service management practices
  • Proactively identifies and participates in the implementation of improvement opportunities across Technology Services sub processes
  • Keeps abreast of database technological changes and advancements; identifies opportunities to apply technology for competitive advantage
  • Prepares documentation on proposed and developed technical solutions
  • Participates in client discussions and collaboration around identifying technical solutions to drive business goals and objectives
  • Ensures compliance with data security as it relates to PCI and Pan data
  • Performs full cycle management of technology/business projects as required
  • Develops technology plans and ensures appropriate project documentation
  • Assesses core technical and resource requirements to support assigned projects
  • Advises IT management and business executives during implementation in defining the solution architecture and high level design on key company projects

Job Requirements:

  • 8+ Years with Bachelors degree or 10+ years work experience in database architecting enterprise solutions and sql development in Microsoft SQL Server
  • Experience in Data Integration architecture and design
  • Self starter requiring minimal to no direct supervision
  • Proven track record of implementing and actively managing fundamental data architectural frameworks, methodologies and architectures using Microsoft SQL Server
  • Proven ability to understand business objectives and translate into both conceptual architecture and project level deliverables
  • Professional and strong communication skills
  • Communicates appropriately to audiences verbally and in writing; keeps IT management informed; adapts communication style to the needs of the audience
  • Ability to analyze business operations and processes to understand their relationships, and drive business process optimization
  • Experience with large-scale high-volume application design, development and deployment
  • Implementation experience with enterprise level clustering, load balancing, fail-over, scalability and performance tuning
  • Experience with performance tuning of enterprise databases as well as daily, weekly, monthly database backups
  • Experience in the creation and management of database objects including databases, schemas, tables, stored procedures, synonyms, and views
  • Experience in report writing in Microsoft SSRS
  • Experience in merging complex documents with datasets as used in core business units