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
Fintech • Machine Learning • Payments • Software • Financial Services
Leads software engineering projects and developers while designing cloud-based, full-stack solutions. Uses IBM z/OS, Scheduler, DB2, COBOL, and JCL to stabilize and modernize mainframe systems for cloud migration. Develops with multiple programming languages, databases, Docker, Kubernetes, and AWS technologies. Provides technical leadership, establishes engineering standards, partners with architects, improves system performance, reduces technical debt, mentors engineers, and drives large-scale Agile initiatives.
Top Skills:
Ai Coding ToolsAsynchronous ApisAutomated Testing FrameworksAWSAzureBitbucketC#Ci/CdCobolDb2DockerFront-End Javascript FrameworksGCPGitGitGoIbm SchedulerIbm Z/OsIde CopilotsInfrastructure As CodeJavaJavaScriptJclKubernetesNode.jsNosql DatabasesObservabilityOpen Source RdbmsPythonRustScalaSynchronous ApisTypescript
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Designs, implements, and operates multi-region cloud and hybrid networking infrastructure. Develops Terraform modules and infrastructure standards, supports AWS architectures, cloud migrations, and data center exits, and contributes to architecture reviews, compliance-aware delivery, CI/CD enablement, documentation, and observability. Collaborates with platform, security, architecture, compliance, and engineering teams to improve scalability, automation, reliability, and operational efficiency.
Top Skills:
AIArgocdAWSAws Network FirewallCi/CdCisco CcnaCisco CcnpDatadogGitlab Ci/CdGitopsHelmIamKubernetesLlmNetwork MonitoringObservabilityOctopus DeployTerraformTransit GatewayVpc
Artificial Intelligence • Big Data • Healthtech • Machine Learning • Analytics • Biotech • Generative AI
Leads security engineering architecture and strategy, including IAM, SSO, authentication, authorization, observability, and distributed event-based systems. Drives build-versus-buy decisions, improves security microservices and tooling, establishes engineering standards, and secures agentic AI infrastructure. Collaborates cross-functionally on priorities and tradeoffs while mentoring engineers, documenting practices, evaluating technologies, and advancing security across a cloud-based microservice architecture.
Top Skills:
AbacAuth0AWSChronicleDockerGCPJavaScriptKubernetesMicroservicesMicrosoft EntraNode.jsOauthOauth 2.1OktaPbacPing IdentityPythonRbacRebacSAMLScimSIEMTerraformTypescript
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
