Avatar for Zoonga

Tickets made simple, for everyone, everywhere

DBA

₹0 – ₹1,000
Apply now
Responsibilities:

Admin

Database Administration for the SQL Server 2005 and above (Maintenance, Security, Upgrades, Performance Tuning, etc.)
Installing, Configuring and Upgrading SQL Server/Applying Service Packs
Server and Database Security Administration
SQL Server Replication Designing SQL Server Systems and Implement
A good knowledge of the physical database design
Create database objects (tables, indexes, etc.)
Write database procedures, functions and triggers
Tune database queries, tuning and Monitoring SQL Server
Code or data synchronization
Ensure data consistency in the database through DBCC commands.
Should have experience with using Trace flags / Profiler to solve Dead Locks/Long running queries.
Should be very strong in replication concepts and troubleshooting replication issues with in SLA.
Disaster recovery/high availability
Failover Clustering
Data Modeling
Data Transformation and Loading
Experience with SSIS and SSRS troubleshooting
Upgrade from DTS to SSIS packages
Backup the current code for rollback purposes
Analysis - Analyze the data to determine the core problems
Testing - Test the various options to ensure they perform better and do not cause worse performance in other portions of the application
Plan growth and changes (capacity planning)
Perform general technical trouble shooting and give consultation to development teams
Interface with Microsoft Corporation for technical support.
Patch Management and Version Control

Tools

Should have good understanding of the MS SQL, related utilities and tools
Identification - Use native tools like Profiler, Perfmon, system stored procedures, dynamic management views, custom stored procedures or third party tools
Backing Up and Restoring SQL Server, Knowledge of ALL MS DB backup and recovery scenarios
Establish and maintain sound backup and recovery policies and procedures
Backup tools
Performance tools
Check for failed processes
Research errors, Validate disk space is not low, validate none of the databases are offline or corrupt
Perform database maintenance : Perform both MS SQL and operating system performance tuning and monitoring

Automation

Monitor application related jobs and data replication activities (Automated)
Setup custom scripts to query for particular issues and email the team
Write error messages centrally in the application and review that data
Setup Operators and Alerts on SQL Server Agent Jobs for automated job notification

General

Setup and maintain documentation and standards
Review the current process to understand what is occurring
Determine what the business and technical problems are with the process
Document the requirements for the new process
Provide a strategic database direction for the organization
Should have the ability to handle multiple projects and deadlines
Should possess a sound understanding of the business
Good understanding of the underlying operating system
Database administration including troubleshooting, database recovery, and database admin using SQL
Designing database structures and writing database objects in SQL Server 2000 i.e. Complex Stored Procedures, Indexes, Triggers, Views, and Functions etc.
Database performance tuning and optimization of queries
Backing up and restoration of database
Troubleshooting using SQL Profiler
Database performance tuning and optimization of queries.
Development of reports using SQL Server stored procedures.
Setting database access controls for the development team
Database administration including troubleshooting, database recovery, and database admin using SQL

Qualifications/Requirements:

BS/MS in Computer Science.
2-6 years of MS-SQL server administration experience.
Experience in replicating technology including mirroring, archiving and indexing data.
Proficient in navigating and utilizing windows, IIS environment and Framework.
Knowledge of Dot Net Framework and asp scripts.
Knowledge of Exchange Server and administration.
Proficient in web Server operations.
Oracle administration experience is a plus.
Experience in E-commerce website is desirable.
Result oriented and dedicated.
Strong troubleshooting and problem solving skills.
Strong work ethic.
Excellent communication skills in English.
Strong interpersonal skills.

Zoonga at a glance

Tickets made simple, for everyone, everywhere

Zoonga focuses on Machine Learning, Big Data, Artificial Intelligence, and Ticketing. Their company has offices in New York City and Melbourne. They have a mid-size team that's between 51-200 employees.

You can view their website at https://www.zoonga.com/ or find them on Twitter, Facebook, and LinkedIn.

More jobs at Zoonga

View all jobs

Data Scientist

Full Stack Developer

VP Engineering

.Net Core Developer

Android Developer

CTO