System Canada Technologies Logo

System Canada Technologies

Database Administrator

Posted 2 Days Ago
Be an Early Applicant
In-Office
New York, NY, USA
Junior
In-Office
New York, NY, USA
Junior
Administer and support SQL Server databases, including installation, upgrades, backups, recovery, monitoring, maintenance plans, scheduled jobs, troubleshooting, performance tuning, replication, clustering, and documentation. Provide technical support for database-related projects and participate in a rotating 24x7 on-call schedule. The role also requires SQL Server scripting, database design knowledge, Windows administration, and some Oracle administration experience.
The summary above was generated by AI
Company Description

SCT resources have a broad range of skills in different technologies. The large skill-set has been made possible by a conscious focus on strengthening our skills base. Every person selected for our team brings something new, something that adds to our offerings. We learn continuously, both on the job and through formal training programs.

Job Description

Key Areas of Responsibility:

Ability to work as part of a team to plan, design, build, deploy and maintain SQL Server databases.  Provide technical and operational support to other departments as needed to support business objectives.  Additionally:
     Provide 24x7 on call support as part of a team rotation
     Provide application, database and system troubleshooting 
     Provide application, database and system performance tuning
     Provide technical support for database related projects
     Install and upgrade of SQL Server and associated software including third party tools
     Provide basic database administration activities such as backup, recovery, monitoring and management
     Develop documentation for other DBAs, developers and end-users
     Build and maintain SQL Server Maintenance Plans and optimization jobs
     Manage SQL Server jobs and schedules

 

Knowledge, Skills and Experience
     Good written and verbal communication skills
     Good troubleshooting skills
     One plus years of experience installing, configuring and managing SQL Server databases.
     In-depth knowledge of Windows operating system.
     Understanding of relational database design
     SQL Server Cluster
     SQL Server Replication 
     SQL 2008
     SQL 2012
     SQL utilities such as BCP, DTS and SSIS
     T-SQL and knowledge of stored procedures, UDFs and triggers
     Monitoring and tuning tools such as Windows Performance Monitor, Profiler and Tuning Advisor
     Shell scripting (Powershell, Windows batch files)
     Experience with 3rd party monitoring tools like Confio Ignite.
     Data and Process Modeling
     Some Oracle administration experience
     Bachelors degree or equivalent work experience

Similar Jobs

4 Days Ago
In-Office or Remote
New York, NY, USA
113K-193K Annually
Senior level
113K-193K Annually
Senior level
Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
Lead the architecture, administration, optimization, and operational management of enterprise Oracle and Snowflake data warehouses. Manage Exadata, ODA, RAC, and Data Guard environments; tune database performance and infrastructure resources; and ensure high availability and disaster recovery. Develop AI-powered solutions, automated workflows, diagnostic tools, and self-healing runbooks using Python, Bash, and Azure OpenAI. Collaborate with engineering, infrastructure, networking, storage, and data integration teams.
Top Skills: Ai/Ml FrameworksAzure OpenaiBashEnterprise Monitoring ToolsInformatica MdmOracle Data GuardOracle Database Appliance (Oda)Oracle ExadataOracle RacPythonSan/NasSnowflake
6 Days Ago
In-Office
New York, NY, USA
Mid level
Mid level
Information Technology • Software • Consulting • Cybersecurity
Support and integrate PeopleSoft and Oracle systems, with emphasis on pension administration, payroll, HRIS integrations, data conversion, reporting, performance tuning, debugging, upgrades, and regression testing. The role requires expertise in PeopleTools, PeopleCode, Oracle SQL and PL/SQL, Application Engine, Integration Broker, and pension calculations, compliance, interfaces, and reconciliation. Candidates will work independently and collaboratively in a hybrid New York assignment.
Top Skills: Application DesignerApplication EngineBi PublisherComponent InterfaceHrisIntegration BrokerJavaScriptJqueryOracle DatabaseOracle Pl/SqlOracle SqlPeoplecodePeoplesoftPeoplesoft HcmPeoplesoft Pension AdministrationPeopletoolsSqrTimekeeping IntegrationsXML
6 Days Ago
In-Office
New York, NY, USA
Entry level
Entry level
Information Technology • Software • Consulting • Cybersecurity
Provide production support and modernization expertise for customized PeopleSoft workforce management, timekeeping, payroll, pension, leave, and union-compliance systems. Responsibilities include redesigning, testing, deploying, and maintaining contract-driven changes; supporting integrations and migration of more than 20,000 employees; validating requirements; reviewing architecture; baselining performance; supporting QA/UAT; overseeing vendors; and resolving defects. The role requires 24/7 support for mission-critical applications, incident management, high availability, business continuity, and strong knowledge of timekeeping and workforce management systems.
Top Skills: ApexBi PublisherBsc PayrollCis/BoData LakeHastusInsightKronosOraclePeoplesoftTlcs

What you need to know about the NYC Tech Scene

As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.

Key Facts About NYC Tech

  • Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
  • Key Industries: Artificial intelligence, Fintech
  • Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
  • Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account