Software, Consultant, Data Warehouse, Database, DBA, Unix, SQL, J2EE, Web, Management, Computer, Engineering, Systems, Sybase
Contract W2, Contract Corp-To-Corp, C2H Corp-To-Corp, C2H Independent, C2H W2, Contract Independent
Software Guidance & Assistance, Inc., (SGA), is searching for a Production Support Consultant for a contract assignment with one of our premier financial services clients in Irving, TX .
Responsibilities :
• Have technical expertise on all aspects of Snowflake and deploy following best practices
• Performing Maintenance and Support Activities on a fully operational production grade large scale data solution on Snowflake Data Warehouse.
• Managing Cost of Snowflake Data Warehouse efficiently by tracking the storage and compute costs.
• Estimating the compute processing and memory requirements, and estimates of initial user numbers and projected growth rates.
• Performing Virtual warehouse set up as required for new business units.
• Monitoring the system, and adjusting virtual warehouses (scale-in and scale-out) when appropriate.
• Implementing various backup and recovery techniques in order to ensure quick Disaster recovery.
• Designing solutions to address the needs of both ad-hoc and predefined queries.
• Performing user management activities.
• Managing the environments and ecosystem and tune Snowflake for performance and optimize utilization.
• Work hands-on with customers to demonstrate and communicate implementation best practices on Snowflake technology.
• Maintain deep understanding of complementary technologies and help organizations leverage Snowflake as part of their larger technology stack.
• Proven understanding of complementary technologies and help organization leverage Snowflake as part of their larger technology stack.
• Build, design, architect and implement high-volume, high-scale database and analytics as Snowflake solution in the cloud.
• Provide 24*7 support.
Required Skills :
• Migrating Data from On Prem to Cloud having minimum of one year experience.
• Worked on Database Warehouse migration project of Snowflake.
• Should have experience in shell scripts.
• Minimum 5 years of DBA including 2 years of Snowflake experience.
• Basic knowledge or interest about apps support procedures, concepts and of other technical areas.
• Strong Technical skills must include (but not limited to): Cloud Computing, AWS, Unix, SQL, J2EE Web and shell scripting.
• Participation in proactive process improvements.
• Previous experience or interest in standardization of procedures and practices, especially on RDBMS/data warehouse appliances.
• Basic Business knowledge/ understanding of financial markets and products.
• Knowledge/experience and adaptability of problem Management Tools.
• Evaluates (sometimes complex) situations using multiple sources of information Developed communication and diplomacy skills to persuade and influence.
• Good customer service, communication and interpersonal skills.
• Good knowledge of the business and its technology strategy.
• Consistently demonstrate clear and concise written and verbal communication skills.
• Knowledge of issue tracking and reporting using home grown and 3rd party tools.
• Must be a proven team-player sharing and cross training technology solutions.
• Effectively share information with other support team members and with other technology teams.
• Ability to plan and organize workload to meet strict SLAs.
• Bachelor Degree or foreign equivalent in Computer Engineering, Computer Science Systems Engineering, Information Management, Software Engineering, Information Systems or related field.
Preferred Skills :
• Netezza and Sybase IQ experience is a plus
SGA is a Certified Women's Business Enterprise (WBE) celebrating over thirty years of service to our national client base for both permanent placement and consulting opportunities. For consulting positions, we offer a variety of benefit options including but not limited to health & dental insurance, paid vacation, timely payment via direct deposit. SGA accepts transfers of H1 sponsorship for most contracting roles. We are unable to sponsor for Right-to-Hire, Fulltime, or Government roles. All parties authorized to work in the US are encouraged to apply for all roles. Only those authorized to work for government entities will be considered for government roles. Please inquire about our referral program if you would like to submit a candidate for any of our open or future job opportunities. SGA is an EEO employer. We encourage Veterans to apply. To view all of our available job postings and/or to learn more about SGA please visit us online at www.sgainc.com .