Senior Database Architect- Only Locals

Job: Database architect Number of Submission: 2 Location: Hybrid in Austin TX Term: 12+ Interview Process: 2 virtual rounds • • must be local and have a LinkedIn profile with active photo • • Core Responsibilities ·    Develop and maintain production databases by entering and configuring system codes. ·    Use utility programs to monitor database performance (e.g., record distribution, memory usage). ·    Direct programmers and analysts to implement changes to the database management system. ·    Review, debug, and correct database-related programs. ·    Respond to user inquiries and provide technical support. ·    Collaborate with coworkers to assess the impact of database changes on systems and staffing costs. ·    Perform performance tuning to optimize database processing speed. ·    Specialize in one or more database management systems (DBMS). ·    Assist in planning, developing, maintaining, and monitoring integrated database systems. ·    Ensure new applications align with existing database architecture and design standards. ·    Evaluate user requests for new data elements and systems; integrate them into shared environments. ·    Coordinate data usage to maintain integrity and reduce redundancy. ·    Load, reorganize, and maintain databases as needed. ·    Conduct data modeling and prototyping (logical and physical). ·    Design relational database models and convert logical models into physical implementations. ·    Execute security recovery procedures and database backup/restoration protocols. ·    Define and implement database search strategies and storage requirements. ·    Maintain and standardize the data dictionary for consistency across systems. ·    Monitor database performance and recommend efficiency improvements. ·    Create test database environments, including libraries and procedures for application testing. ·    Support disaster recovery planning and execution. ·    Assist with database software installation, analysis, design, and implementation. ·    Conduct benchmarking and threshold testing to ensure optimal performance. ·    Establish and enforce database security standards. ·    Participate in the selection and evaluation of database management software. Required Skills & Knowledge ·    Experience in computer systems analysis or programming. ·    Proficiency in: o    Programming principles and systems design o    Computer operations and procedures o    Project control and cost estimation o    Programming languages and flowcharting o    Database structures, theories, and current technologies ·    Familiarity with EIR Accessibility standards and assistive technologies. ·    Ensure database interfaces (admin, input/output, reporting) comply with accessibility standards. ·    Provide user support for data access and EIR-related issues. Project Focus ·    Lead migration of legacy Microsoft Access databases to cloud-native SQL platforms. ·    Collaborate with program users to analyze existing data structures. ·    Design and execute: o    Schema transformations o    ETL pipelines o    Data validation checks o    Cut-over plans MUST HAVE 10    Required    Proven experience in designing, developing, and maintaining advanced MS Access databases, including the creation of normalized table structures, sophisticated queries for data extraction and manipulation, intuitive data entry forms, and comprehensive rpts 10    Required    Expert-level relational database design, normalization, ER modeling, schema refactoring, and translating Access data models into scalable SQL schemas 10    Required    Experience with Microsoft Access, including table design, complex queries, forms, reports, and Skilled in leveraging VBA for custom functionalities and workflow automation 10    Required    Experience with migrating legacy databases into at least one major cloud SQL service (Azure SQL Database/Managed Instance. PostgreSQL, AWS RDS for SQL Server/MySQL) 8    Required    ETL tool experience with SSIS, Azure Data Factory, AWS Database Migration Service (DMS), or equivalent 8    Required    creating migration runbooks, data dictionaries, technical documentation, and delivering training or knowledge-transfer sessions 8    Required    Experience with RDBMS admin/console tools such as TOAD, SSMS and/or SQL Developer. 8    Required    Configuring data integration and batch processing solutions in Azure Data Factory and/or SSIS; monitoring data ingestion processes and performance; review query plans and identify problem areas in execution plans. 8    Required    Migrating data from legacy database to new target database 6    Preferred    Hands-on experience with CI/CD methodology, GitHub, JIRA 6    Preferred    Hands-on experience with data visualization/reporting tools such as Power BI, Tableau 6    Preferred    Hands-on experience with Agile Development Methodologies 3    Preferred    Prior experience in healthcare or Public Health 3    Preferred    Experience implementing and using agile methodologies and best practices for 1 Thanks & Regards Sudheer Chaudhry, Technical Recruiter Sudheer@tekintegral.com Mob:- +14692832914 https://www.linkedin.com/in/sudheer-chaudhry-ab8535159/ Address: 555 Republic Drive, Suite 240 Plano, TX 75074 Website: www.tekintegral.com