1st round phone call 2nd round (final) webcam if candidate not local, in person if local
Tampa FL This role will be responsible for supporting multiple applications and data transfers between internal and client facing applications. The successful candidate will have hands-on experience in a multitude of domains; including, but not limited to; 24 x 7 x 365 enterprise and cloud database infrastructure design and management, security, business continuity, disaster recovery, database design, database development, database tuning, enterprise data storage and backup, service delivery, incident tracking, change management, and general database administration *Responsibilities* Design strategies for database systems as well as set standards for operations, programming and security. Definition and governance of all structured and unstructured physical data models, data entities, supporting artifacts and metadata repositories. Develops physical modeling standards and strategies. Executes design sessions to gather requirements, review, approve, and communicate design artifacts with stakeholders. Creates and manages physical models to support Enterprise Data Warehouse domains that include Operational Data Stores, Staging, Integrated EDW, Data Mart, Business, Reference/Master Data and Extract Transform Load (ETL) environments. Ensures physical database features and capabilities are incorporated into data model designs to optimize performance. Designs deliverables that are defined with appropriate database platform and security context. Design and manage models using various Data Modeling tools. Maintains optimal Enterprise Architecture alignment with Solution Architecture, Technical Leads, Business Analysis, Infrastructure, and PMO roles. Design, Implementation and maintenance of database solutions, management of data access, and resolving database performance and capacity issues. Develop, implement, administrate, and maintain policies and procedures for ensuring the security and integrity of our databases. Perform problem-solving of application issues and production errors, including high level critical production issues that require immediate attention. Design and code a high volume of SQL Queries, stored procedures, and SSIS packages Implement processes and procedures for the development and release of products/projects that facilitate high quality and rapid deployment Provide technical documentation as needed Monitor and perform performance tuning on stored procedures and ETL jobs Monitor and analyze SQL Server production metrics Support complex service impacting issues with little to no supervision Participate in an on-call support rotation and provide non-standard work hour support Trouble shooting and resolving data issues Perform other duties as assigned. Extensive knowledge of SQL Server including the writing of complex stored procedures, functions and SSIS packages as well as basic knowledge of database administration Strong understanding and experience of database development methodologies (Agile and Scrum) Expert level knowledge of SQL administration, engineering, and monitoring tools Demonstrated expertise in performance tuning including both query and server optimization Strong knowledge and experience in data modeling, relational database design, optimization for performance, T-SQL, stored procedures, SSIS packages Expertise in understanding complex business needs, analyzing, designing and developing solutions Advanced knowledge of relational database design, testing and implementation Advanced communication and professional skills and the ability to establish relationships across business units Ability to participate in an on-call support rotation and provide non-standard work hour support Extensive SQL Server performance tuning and troubleshooting experience Hands-on development experience in SQL Server 2012/2016 Experience with SSIS Financial technology domain knowledge would be a plus Experience with .NET, MVC, C# HTML5 CSS3 AJAX jQuery IIS and Java script would be a plus Computer Science Degree Highly Desired -- *Naveen Tripathi* * Technical Recruiter* *Zenith tech Solutions* * Desk: **518 621 0048* *Fax:* *518-244-4977* <518-244-4977> *3 COMPUTER DR West,* *Suite #107* *ALBANY, NY 12205* *[email protected] <[email protected]>* *Hangout id: [email protected] <[email protected]>* *DISCLAIMER:* Note: This is not an unsolicited mail. Under Bill 1618 Title III passed by the 105th USACongress this email cannot be considered as spam as long as we include our contact information and an option to be removed from our emailing list. If you have received this message in error or, are not interested in receiving our emails, please accept our apologies.To be removed from our mailing list, please reply with the subject line. All removal requests will be honored ASAP. We sincerely apologize for any inconvenience caused to you -- You received this message because you are subscribed to the Google Groups "RESOURCE OPTIONS, INC." group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/resourceoptions. For more options, visit https://groups.google.com/d/optout.
