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