Administer and optimize Oracle/SQL Server and Amazon Redshift databases. Design schemas, tune queries, manage clusters (spin up/resize), handle backup/recovery, capacity planning, performance analysis, issue resolution, and perform SQL-based query optimization on Unix/Linux environments.
Company Description
Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.
- Overall DBA experience (on Oracle or SQL Server) of over 10+ years.
2. 2+ years of experience on Amazon Redshift (MUST)
3. Database design and optimization skills with a strong understanding for performance analysis, tuning, maintenance to ensure continuous data integrity & perfo
rmance
4. Experience with distribution and sort keys and column encodings
5. Experience spinning up and resizing clusters
6. Issue analysis and resolution
7. Knows Backup and recovery process
8. Storage capacity planning and analysis
9. Working knowledge of unix / linux
10. Hands on experience with SQL statements, query analysis for performance improvements
** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.
Note:-
- This is a Contract job opportunity for you.
- Only US Citizen, Green Card Holder, GC-EAD, H4-EAD, L2-EAD, OPT-EAD & TN-Visa can apply.
- No H1B candidates, please.
- Please mention your Visa Status in your email or resume.
** All your information will be kept confidential according to EEO guidelines.
Similar Jobs
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Lead client engagements to optimize supply chain planning using Kinaxis and analytics. Manage projects, mentor staff, design inventory and distribution strategies, implement SCM technology, and ensure performance and compliance.
Top Skills:
Data AnalyticsKinaxisSupply Chain Management Software
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Lead strategy engagements for asset and wealth management clients: analyze market trends, develop and implement growth and operational strategies, manage client accounts, lead and mentor teams, conduct competitive research, and drive business transformation while promoting innovation and maintaining professional standards.
Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Lead supply chain planning and Kinaxis-focused optimization efforts: analyze processes, recommend technology and analytics-driven improvements, manage client relationships, lead teams, and drive cost, responsiveness, and operational excellence.
Top Skills:
Data AnalyticsKinaxisSupply Chain Management Software
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
