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
Consumer Web • eCommerce • Internet of Things
Own and evolve the cloud-native platform for a multi-tenant DNS-native identity service: design infrastructure architecture, ensure production readiness (SLOs, DR, runbooks), operate DNS and PKI/signing systems, build CI/CD and supply-chain controls, instrument observability, automate audit evidence, manage cost and capacity, lead incident response and on-call, and mentor the engineering team to scale operational practices for enterprise launch.
Top Skills:
ArgocdAWSCosignDnsDnssecEfkElkGCPGithub ActionsGitlab CiGoGrafanaHsmJavaScriptKmsKubernetesOpentelemetryPkiPrometheusPythonSigstoreSlsaTerraformTypescript
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Manage relationships with third-party administrators, vendors, brokers, and Korea-based clients. Negotiate domestic and international vendor and client contracts and SLAs, monitor vendor performance, lead renewals, handle claims escalations, deliver Korean-language onboarding presentations and materials, translate portal/content, and pursue new business opportunities with brokers.
Fintech • Information Technology • Insurance • Financial Services • Big Data Analytics
Lead architecture, modernization, and development of Group Insurance applications. Modernize mainframe monoliths into Java microservices and micro-frontends on cloud, mentor distributed Agile teams, collaborate with enterprise architecture, product owners and infrastructure, and enable test automation and integrations. Approximately 10% domestic travel.
Top Skills:
Ai/MlAWSAzureBpmCicsCloudCobolDb2DevOpsIntegrationsJavaJavaScriptMainframeMicro-FrontendMicroservicesNode.jsNoSQLPythonRdbmsSalesforceSsoUi FrameworksVsam
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
