FIND PERSONALIZED JOBS
Sign up to Zippia and discover your career options with your personalized career search.
Sorry, we can't find that. Please try a different city or state.

SQL Database Administrator

This job has expired and is no longer available.
APPLY NOW
Apply Now
×
FIND
PERSONALIZED JOBS

Sorry, we can't find that. Please try a different city or state.

CONTENT HAS
BEEN UNLOCKED
Close this window to view unlocked content
or
find interesting jobs in

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign Up

SIGN UP TO UNLOCK CONTENT

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Forgot Password?

Don't have an account? Sign Up

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign up to save the job and get personalized job recommendations.

Sign up to dismiss the job and get personalized job recommendations.

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Already have an account? Log in

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Company Saved

Answer a few questions and view jobs at that match your preferences.

Where do you want to work?

Job Saved

See your Saved Jobs now

or

find more interesting jobs in

Job Dismissed

Find better matching jobs in

Your search has been saved!

Top 50 SQL Database Administrator Skills

Below we've compiled a list of the most important skills for a SQL Database Administrator. We ranked the top skills based on the percentage of SQL Database Administrator resumes they appeared on. For example, 14.9% of SQL Database Administrator resumes contained Database as a skill. Let's find out what skills a SQL Database Administrator actually needs in order to be successful in the workplace.

These are the most important skills for a SQL Database Administrator:

1. Database

demand arrow
high Demand
Here's how Database is used in SQL Database Administrator jobs:
  • Implemented and maintained security and integrity controls including backup and disaster recovery strategies for document management system and SQL Server databases.
  • Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution.
  • Implemented and maintained Database mirroring as a Disaster Recovery Solution.
  • Maintained technical documentation for every client/server database implementation and upgrades.
  • Implemented Database mirroring and Log shipping for disaster recovery.
  • Complete documentation about the database.
  • Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder.
  • Created indexes, constraints and rules on database objects to improve the data base performance to have best out of it.
  • Credited with building and migrating a legal company's database environment from MS Access to SQL Server.
  • Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
  • Created the Database Objects like Tables, Views, Functions, Stored Procedures and Triggers.
  • Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
  • Managed the migration of SQL Server 2005 databases to SQL Server 2008.
  • Involved in Up gradation of Touch works Database.
  • Experience in Database security and integrity planning Used log shipping for synchronization of databases.
  • Involved in setting up database mirroring for production server Configured replication methods like snapshot, transactional and merge replications.
  • Compare and synchronize your database schemas or data by using REDGATE Rendered Reports to Microsoft Word using SQL Server 2008.
  • Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
  • Involved in Migration from SQL 2005 to SQL 2008 Managing server logins, database users and permissions.
  • Created Clustered Indices and Non-Clustered Indices to increase the performance of database.

Show More

157 Database Jobs

No jobs at selected location

2. SQL

demand arrow
high Demand
Here's how SQL is used in SQL Database Administrator jobs:
  • Migrated the data from legacy system to SQL Server environment and performed clean up after the migration using the Pervasive tool.
  • Implemented database clustering (Active-Active) with Windows 2000 (Advanced Server) and MS SQL Server 2005/2008.
  • Create Documentation for steps need to be taken while upgrading the SQL server 2008 to SQL server 2012.
  • Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
  • Used ODBC connections to connect Access front-end and Web application to SQL back-end.
  • Installed and configured more than 2GB RAM in SQL Server 2005.
  • Configured Replication from existing SQL Server 2005 to SQL Server 2012.
  • Performed the migration of SQL Server 2000 to SQL Server 2005.
  • Implemented Database High Availability utilizing SQL Log Shipping & SQL Replication.
  • Worked on Data Partitioning and Snapshot Isolation in SQL Server 2005.
  • Perform SQL Server service pack and Windows Service pack upgrades.
  • Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
  • Used Policy Based Administration feature (SQL Server 2008).
  • Experience in performing large scale SQL Server version upgrades.
  • Rendered Reports to Microsoft Word using SQL Server 2008.
  • Installed SQL Server 2008/2012 on hundreds of machines/clusters.
  • Migrated the SQL Server 2008 to SQL Server 2012.
  • Implemented SQL Data Compression Using Sql server 2008 For Compressing Data and Log Files, Back Up Level.
  • Monitor SQL Server activity by profiler.
  • Performed Database Query Tuning using Spotlight and SQL Server Profiler and analyzed OS performance utilizing Windows Perfmon and implemented optimization recommendations.

Show More

180 SQL Jobs

No jobs at selected location

3. Production Servers

demand arrow
high Demand
Here's how Production Servers is used in SQL Database Administrator jobs:
  • Involved in Monitoring Performance of different production servers.
  • Supported production servers in Fail over cluster environment.
  • Handled numerous Change Management requests on production servers.
  • Created all the scripts for the migration for all the databases of both QA and the Production servers.
  • Monitored growth of data and managed space allocation accordingly, Installed and configured Log Shipping for production servers.
  • Implemented and maintained all the production servers using an external tool for monitoring called Fog light.
  • Involved in maintaining reporting services in SQL server 2012/2008 in one of the production servers.
  • Worked in team environment and involved in on call rotation schedule to support production servers.
  • Involved in the maintenance of ACTIVE/ACTIVE and ACTIVE/PASSIVE Cluster environments for the production servers.
  • Experience in Handling 30+ Production servers out of which 10+ Mission critical Databases.
  • Generate Database Health Check & Recommendation Reports monthly basis on Production Servers.
  • Experienced in troubleshooting production servers and fixed the user and application issues.
  • Maintained and updated on call guides for all Production Servers.
  • Resolved Space issue on production servers by implementing effective methods.
  • Deployed SSIS packages and Reports to Production Servers.
  • Upgraded with latest hotfixes for all Development/Test/Production Servers.
  • Maintained Transactional Replication on production servers.
  • Installed, managed and administered the MS SQL Server [ ] Production and Non Production Servers.
  • Worked with Powershell Scripts to Run Test Builds on Test Servers and Release on Production Servers.
  • Supported production servers in 2012 Failover cluster Instance environment.

Show More

1 Production Servers Jobs

No jobs at selected location

4. Windows XP

demand arrow
high Demand
Here's how Windows XP is used in SQL Database Administrator jobs:
  • Encrypted NTFS file system in Windows XP and Windows server 2003 to secure data resources.
  • Enhanced computer skills using Microsoft Office Suite 2007 and Windows XP.
  • Worked in various environments like Windows XP /NT /Server/Vista/2007
  • Implemented CDC on production databases Environment: MS SQL Server 2005/ 2008/2008 R2/2012, Windows XP /Windows 7
  • Assisted desktop support on as needed basis with desktops running windows xp and windows 7.
  • Developed test cases and test scripts.Environment: SQL Server 2000, Windows XP, T-SQL
  • Installed Cygwin on an old Windows XP machine to allow SFTP access for truck routing.

Show More

5. Ssrs

demand arrow
high Demand
Here's how Ssrs is used in SQL Database Administrator jobs:
  • Created Complex SSRS Reports using the Business intelligence development tools and troubleshoot the performance and subscription issues in it.
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Experience in SQL Server (BI) Business Intelligence Development Studio to create SSRS reports and SSIS packages.
  • Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions.
  • Worked on SSRS reports to report the Daily, Weekly and Monthly Statistics of various investors.
  • Worked on creating reports using SQL server Reporting Services (SSRS).
  • Installed and Configured SQL Server Reporting Services (SSRS).
  • Created regular Subscription and Data Driven Subscription in SSRS.
  • Deployed reports using Microsoft Reporting Services (SSRS).
  • Generate experience in converting Actuate reports into SSRS.
  • Experience in installing, configuring SSIS and SSRS.
  • Involved in tuning various reports generated using SSRS.
  • Participated in creating reports using SSRS.
  • Created various reports using SSRS.
  • Administered the SSRS report server.
  • Create extensive reports using SSRS.
  • Design, Development, Configuration and deployment of custom build business reports using MS Reporting Services - SSRS.
  • Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
  • Involved in SSRS 2012/2014 Installation, Configuration, Deployment , Development.
  • Developed Reports using SSRS and Cristal reports according to the requirement.

Show More

2 Ssrs Jobs

No jobs at selected location

Job type you want
Full Time
Part Time
Internship
Temporary

6. T-Sql

demand arrow
high Demand
Here's how T-Sql is used in SQL Database Administrator jobs:
  • Provided database coding to support business applications using T-SQL.
  • Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Experience in the field of Unit Testing, have tested codes of T-SQL and SSIS packages in the testing environment.
  • Create necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.
  • Used DDL and DML for writing complex T-SQL code, Triggers, Stored Procedures and views.
  • Experience in writing complex T-SQL queries using Inner Joins, Outer Joins and Cross Joins.
  • Develop T-SQL scripts to create database objects and perform DML and DDL tasks.
  • Involved in database design, database standards, and T-SQL code reviews.
  • Implemented T-SQL features like Data Partitioning, Error handling and Snapshot Isolation.
  • Used the Execution Plan to improve the optimization of the T-SQL code.
  • Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
  • Involved in writing T-SQL queries, stored procedures, views, functions.
  • Write T-SQL Scripts for database backup jobs and daily/weekly jobs.
  • Created new tables, stored procedures and triggers IN T-SQL.
  • Executed T-SQL scripts against Query analyzer.
  • Filtered bad data using complex T-SQL statements, Cursors and UDFs and implemented various constraint and triggers for data consistency.
  • Migrated data from Oracle 10g to SQL Server 2005 and provided T-SQLs to users for quick query from SQL database.
  • Review T-SQL code to verify it meet standards for both performance and error handling according to DBA standards.
  • Developed many adhoc t-sql scripts, stored procedures and functions using ANSI SQL

Show More

7. Recovery Procedures

demand arrow
high Demand
Here's how Recovery Procedures is used in SQL Database Administrator jobs:
  • Handled clustering between two Production Servers and performed daily backups and developed recovery procedures.
  • Developed administrative tasks of SQL Server of performing daily backups and recovery procedures.
  • Created the standard procedure for disaster recovery procedures for mission critical production servers.
  • Experience in Database Backup, Recovery and Disaster Recovery procedures.
  • Implemented and enhancing corporate level disaster recovery procedures for databases.
  • Developed technical documentation for DR Test and Database Recovery procedures
  • Design and implementation of Backup policies and Recovery procedures.
  • Implemented Backup, Restore and Disaster Recovery procedures.
  • Performed daily backups and developed recovery procedures.
  • Design and automation of disaster recovery procedures.
  • Enhance database performance, perform restores, implement and document recovery procedures, handle performance tuning and conduct regular system backups.
  • Designed and Implemented Disaster Recovery Procedures Log Shipping, Mirroring as well as Backup and Restore Strategies.
  • Installed and Implemented Backup & Recovery procedures, Implemented Hot, Cold, Logical backup plans.
  • Developed backup and recovery procedures for SQL Server, documented each system.
  • Provided the new Disaster Recovery procedures for Extended Stay.
  • Implemented backup and recovery procedures with Oracle's RMAN.
  • Involved in SQL Server disaster recovery procedures.
  • Documented Database environment, Escalation procedures, issues, Installation procedures, Disaster recovery procedures In Database Management Prod Guide.
  • Perform daily backups and developed recovery procedures Created logical and physical databases for various applications.
  • Set up backup using Veritas, checking event viewer on Windows Server 2000/03 and developed recovery procedures.

Show More

8. High Availability

demand arrow
high Demand
Here's how High Availability is used in SQL Database Administrator jobs:
  • Implemented high availability technologies: Replication/Mirroring/Clustering/AlwaysOn.
  • Configure, managing and monitor Transaction Replication and Log Shipping for high availability on cluster environment.
  • Installed, Configured, and Maintained database High Availability solution using Log-Shipping, Mirroring and Replication.
  • Implemented high availability solutions, including Clustering, Database Mirroring, Replication and Log Shipping.
  • Implemented and Monitored 2-Node Active\Passive SQL Clustering to provide High Availability for mission critical events.
  • Worked on Active-Passive, Active-Active Cluster environment as a High availability solution.
  • Maintained high availability of databases using Database Mirroring and Log Shipping.
  • Maintained clustered servers to provide high availability.
  • Implemented Database mirroring for High Availability.
  • Involved in implementing and monitoring different types of Disaster Recovery and High Availability techniques such as Mirroring, Log shipping.
  • Worked in Active-Passive, Active-Active Cluster and DB Mirroring environment as a High availability solution And Always on.
  • Install, configure and maintain clustering to provide server high availability solution for 6 different environments.
  • Involved in setting up, managing and maintain High availability technologies: Installation Cluster.
  • Used log shipping to create a warm standby server to improve high availability.
  • Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
  • Worked on SQL 2012 AlwaysOn Availability Group as a High availability solution.
  • Implemented SQL Server 2005 Database Mirroring for high availability.
  • Implemented load balance web servers for high availability.
  • Key projects: Developed and tested storage strategies and disaster-recovery plan that guaranteed recovery performance and high availability.
  • Configured Log shipping and support Logship failures across servers in different Datacenters as high availability.

Show More

58 High Availability Jobs

No jobs at selected location

9. DTS

demand arrow
high Demand
Here's how DTS is used in SQL Database Administrator jobs:
  • Developed DTS packages to extract, purge, transform, and apply business logic and load data from multiple sources.
  • Designed new job process, new database maintenance plans, DTS programs and did Performance Tuning of the existing processes.
  • Created DTS Packages & Batch Scripts vital in supporting Web Front End, Decision Support Systems and Reporting Servers.
  • Created DTS package to export and import data from SQL Server to Access, text files and Excel files.
  • Imported Data from Text files and Excel Spread sheet into SQL Server 2005 database using DTS package.
  • Developed DTS Packages to transfer the data between SQL server database and files.
  • Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports.
  • Developed SSIS and DTS packages and scheduled jobs on these packages.
  • Migrated DTS packages from Legacy system to SQL SERVER 2005.
  • Created DTS package and schedule the jobs for batch processing.
  • Created DTS packages for scheduling on SQL Server.
  • Involved in Upgrading DTS packages to SSIS.
  • Migrated DTS packages into SSIS packages.
  • Worked on Access, XML and transformed data to SQL Server 2005 using DTS and SSIS.
  • Migrated DTS packages from SQL Server 2008 to SQL Server 2008R2/2012 as SSIS packages.
  • Migrated DTS and SSIS packages from SQL Server 2008 to SSIS SQL server 2008R2.
  • Migrated DTS packages and jobs from SQL Server 2000 to SQL Server 2005.
  • Used DTS packages to move logins and jobs from one server to another server.
  • Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedure.
  • Created DTS/SSIS Packages to pull data from Oracle, Sybase, MS Access and Flat files.

Show More

3 DTS Jobs

No jobs at selected location

10. Ssis

demand arrow
high Demand
Here's how Ssis is used in SQL Database Administrator jobs:
  • Designed and maintained Ineligible Providers application (SQL 2005, SSIS, SSRS, ASP.net Crystal Reports 9, JavaScript).
  • Selected by this software consulting firm to assist clients with all aspects of data migration and application upgrade initiatives.
  • Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
  • Configured Server for sending automatic mails to the respective people when a SSIS process failure or success.
  • Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
  • Create new SSIS packages to import data from external service providers into the database of the company.
  • Run some SSIS packages to transfer data and generate some reports according to a schedule.
  • Migrated and/or rewritten Microsoft SQL Server 2000 DTS packages to the SSIS packages.
  • Designed DTS/SSIS packages, alerts, store procedures, views, and triggers.
  • Transferred data (ETL) to Data ware house Environment using SSIS.
  • Worked extensively with SSIS SQL Server 2005 to automate DATABASE ADMINISTRATOR tasks.
  • Experience in ETL technologies, developing and deploying SSIS/DTS packages.
  • Involved in DTS/SSIS Package, DTS Import/Export for transferring data.
  • Modified some SSIS packages to make it work more smoothly.
  • Used SSIS to extract data from Excel files.
  • Migrated DTS packages to SSIS packages.
  • Configured and Deployed SSIS Packages.
  • Schedule package execution in SSIS.
  • Created SSIS Package to upload/download encrypted txt files to client FTP Sites.
  • Used DTSXchange tool for migrating DTS packages to SSIS Worked in Active Active Cluster environment as a High availability solution.

Show More

23 Ssis Jobs

No jobs at selected location

11. Query Analyzer

demand arrow
high Demand
Here's how Query Analyzer is used in SQL Database Administrator jobs:
  • Involved in the optimization of SQL queries using Query Analyzer for efficiency and provided queries and procedures for the front-end application.
  • Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server and develop Distributed Queries.
  • Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers through query analyzer.
  • Implemented full unit specific Database maintenance plans including Backups and Data Transfer packages via SQL query analyzer.
  • Performed DBA tasks through Enterprise Manager, Query Analyzer, English Query, Import Export wizard.
  • Used query analyzer to write several DBCC commands and perform database performance tuning.
  • Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.
  • Used SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
  • Used Query Analyzer to optimize SQL Queries and shortened lengthy queries.
  • Created and tuned stored procedures and SQL scripts using query analyzer.
  • Optimized SQL Queries using SQL Query Analyzer.
  • Implement required optimization and fine-tuning of databases using SQL Query analyzer's Profiler and Performance tools for optimization of server.
  • Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
  • Used SQL Profiler and Query Analyzer for troubleshooting, monitoring, optimizing SQL Server and T-SQL statement from developers and testers.
  • Worked with various SQL Server Tools like Enterprise Manager, Management Studio, Query Analyzer, Profiler, SQL Server Agent.
  • Used Query Analyzer and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
  • Diagnose database issues for performance tuning using Query Analyzer and SQL Server Profiler.
  • Performed tune to optimize SQL queries using SQL profiler and query analyzer.
  • Worked extensively on Query Analyzer and Profiler for tuning queries.
  • Monitored SQL Server Performance issues using SQL Server Profiler, Database Tuning Advisor, Activity Monitor, and Query Analyzer.

Show More

1 Query Analyzer Jobs

No jobs at selected location

12. Transactional Replication

demand arrow
high Demand
Here's how Transactional Replication is used in SQL Database Administrator jobs:
  • Configured Transactional replication between Primary Server and three Read-Only servers, with separate Distributor server and experience in troubleshooting replication problems.
  • Implemented Database Mirroring/Transactional Replication as a part of high availability and disaster recovery.
  • Configured Snapshot and Transactional Replication to replicate date to different environments.
  • Worked with Transactional Replication to achieve Load balancing using network authentication.
  • Configured transactional Replication from multiple subscribers for reporting purpose.
  • Implemented Transactional Replication between Primary and Secondary Servers.
  • Configured and maintained transactional replication for production servers.
  • Implemented Snapshot Replication and Transactional Replication.
  • Configured Transactional replication on migrated server.
  • Configured Transactional Replication and Log Shipping.
  • Configured and Monitored transactional replication.
  • Implemented Transactional Replication and Merge Replication for high availability of the databases in SQL Server 2008 R2 across different data center.
  • Configured Replication methods like snapshot replication, transactional replication and Merge replication for Read write with all Read-only's.
  • Implemented Transactional Replication for Real time Reports (Database Server as Publisher and Reporting Server as Subscriber).
  • Managed the hourly transactional replication of data to the web database farms and resolved errors as they arose.
  • Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
  • Implemented Database Mirroring and Transactional Replication as a part of DR plan.
  • Implemented Snapshot and Transactional Replication from SQL 7 to 2000 database.
  • Configured and Monitored transactional replication Create packages, procedures, functions, and triggers; handle database performance and tuning.
  • Created Transactional replication, pull subscription to transfer data from branch to head office and vice versa.

Show More

3 Transactional Replication Jobs

No jobs at selected location

13. Maintenance Plans

demand arrow
high Demand
Here's how Maintenance Plans is used in SQL Database Administrator jobs:
  • Developed and maintained standards across all client environments including monthly maintenance plans and activities.
  • Created different database maintenance plans for database optimization, integrity checks and database backups.
  • Used maintenance plans to set up full/differential/log backup and periodically restored databases.
  • Designed and Implemented database maintenance plans for various database activities.
  • Involved in Analysis, Development and Maintenance of Backup Plan, Disaster Recovery Plan, Procedures and Strategies using Maintenance Plans.
  • Debugged, Optimized existing views, triggers and stored procedures, Modified System Maintenance plans, Backup & Business Continuation procedures.
  • Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.
  • Set up SQL Server Agent Jobs for periodic backups with backup devices, Database maintenance Plans and Recovery.
  • Set up Maintenance plans on databases to run during weekends to have a better performance.
  • Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity.
  • Implemented and Maintained routine DBA tasks like scheduling jobs, creating maintenance plans.
  • Created Database Maintenance Plans for Re-indexing, Database Integrity Checks, Shrink Database.
  • Created Maintenance Plans to make sure the database does not encounter any issues.
  • Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
  • Created Maintenance plans, Scheduled Jobs and SSIS packages.
  • Created and scheduled DB maintenance plans and jobs.
  • Developed SQL Server Maintenance Plans.
  • Build maintenance plans if necessary.
  • Created and monitored database maintenance plans for checking database integrity Responsible for database backups & restoration and scheduling backup strategies.
  • Resolve database corruption or consistency issues after detection thru weekly maintenance plans.

Show More

8 Maintenance Plans Jobs

No jobs at selected location

14. DBA

demand arrow
high Demand
Here's how DBA is used in SQL Database Administrator jobs:
  • Performed daily DBA management tasks including troubleshooting, performance and tuning, database monitoring and backup/recovery.
  • Handled Primary DBA roles and responsibility for multiple applications.
  • Promote activities and dialog within the DBA group that encourages the sharing of ideas and the exploration of alternative solutions.
  • Provide technical support to internal developers and external clients with 24/7 on-call availability on a rotational basis with DBA team.
  • Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements.
  • Engaged to mentor/teach a System Administrator who has taken on the role of SQL Server DBA.
  • Implemented Disaster recovery for SQL Server DBA Production Database as Fail-over or standby servers.
  • Employed as SQL 2005-2008 DBA and Hyperion Financial Software and Hardware Administrator.
  • Lead onshore/offshore DBA teams for DBA support for 24/7 system availability.
  • Managed Global DBA team located in USA, Europe and Asia.
  • Serve as Production Support DBA in a dynamic, fast-paced environment.
  • Automated most of the DBA Tasks and monitoring stats.
  • Created alerts to notify Senior DBA of Server errors.
  • Documented Database structures and trained Junior MySQL DBA.
  • Managed database changes based on feedback.
  • Worked as Primary DBA for 50 Instances and 70 as Alternate DBA.
  • Work as the lead DBA for EFG and VistaCollege.
  • Lead the (DBA) team.
  • Work with Transversal Engineering team to optimize robust DBA Automation.
  • Project: Shared-DC (Shared Services) Roles & Responsibilities: Act as a Technical Mentor for junior DBAs in team.

Show More

73 DBA Jobs

No jobs at selected location

15. ETL

demand arrow
average Demand
Here's how ETL is used in SQL Database Administrator jobs:
  • Designed high level ETL Architecture for overall data transfer from the Source Server to the Enterprise Services Warehouse using SSIS 2012.
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Achieved high performance and more accurate ETL processes from OLTP to OLAP by rewriting the T-SQL scripts and utilizing SSIS.
  • Used SSIS (SQL Server integration services) 2008 for data extraction, transformation and loading (ETL).
  • Created Complex SSIS Packages (ETL) Applications, using BIDS and troubleshoot couple of Execution and development issues.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Ensured the entire ETL process completed within the deadline time and investigated various stages and reasons for delays.
  • Use SQL Server Data Tools for Business Intelligence in Visual Studio to develop ETL packages with SSIS.
  • Worked environment which MS SQL Server is being used to host ETL scripts of the given application.
  • Experience with optimizing and performance tuning the queries for a large SQL cube and ETL.
  • Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
  • Provided custom SQL reports and ETL for other analysts and external researchers.
  • Created and upgraded SSIS packages for creating files and for ETL process.
  • Used various transformation tasks to create ETL packages for data conversion.
  • Worked with different upstream team for downloading ETL MART data.
  • Developed ETL process of data feeds (XML and flat files) from FuelQuest to load AP and receipts into Epicor.
  • created extensive SQL Server Integration Services (SSIS) packages for ETL.
  • Implemented ETL for large datasets.
  • Performed ETL tasks from flat files to the servers and from SQL server to the flat files, csv files.
  • Trained in the Informatica PowerCenter 7 ETL tool that was used to populate reporting databases via extracts from the mainframe databases.

Show More

3 ETL Jobs

No jobs at selected location

16. Production Environment

demand arrow
average Demand
Here's how Production Environment is used in SQL Database Administrator jobs:
  • Maintained database response times in 24X7 Production environments, proactively generated performance reports.
  • Monitored and scheduled existing/new jobs on production environment.
  • Analyze and recommend changes to the stored procedures before deploying them into production environment to generate reports for the end users.
  • Installed and configured SQL server 2005, 2008 and 2008R2 on a test environment to be the future production environment.
  • Manage corporate SQL server 2008 R2/SQL Server 2005 production environments as well as development, test and DR environments.
  • Tested backup and recovery strategies in a test environment before and then moved it to the production environment.
  • Installed Configured SQL Server 2008/2008 R2 /2012 and managed the servers in production, and non-production environments.
  • Supported and performed SQL Server administration activities on Development, Staging, and QA & Production environments.
  • Experience in (24x7) production environment carried and had on call on a regular basis.
  • Migrated databases from SQL Server 2005 to 2008, 2008R2 in test and production environment.
  • Created and managed tables, functions, indexes using T-SQL in development and Production environment.
  • Supported 24 X 7 Production environments and solved many incident Tickets.
  • Supported 24 X 7 production environment as a Tier 3 Support.
  • Configured and deployed SSIS Packages from Test to Production Environments.
  • Managed very large databases in 24/7 Production Environments.
  • Worked in 24x7 production environment.
  • Configured and installed Foglight Monitoring tool across the production environments.
  • Worked on ACTIVE/ACTIVE and ACTIVE/PASSIVE clusters Managed Production environment for High Availability in Active/Active and Active/Passive mode.
  • Used the Powershell scripting to get the most consistent production environment.
  • Use Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers and uptime in production environment.

Show More

2 Production Environment Jobs

No jobs at selected location

17. Dbcc

demand arrow
average Demand
Here's how Dbcc is used in SQL Database Administrator jobs:
  • Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing using DBCC commands.
  • Checked the efficiency and inefficiency of indexes by checking the density vectors and histograms of indexes using DBCC Show statistics.
  • Used DBCC and ALTER C statements to check and manage database consistency, index fragmentation/rebuilding, statistics.
  • Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes.
  • Created and managed maintenance jobs for performing SQL Backups, DBCC, and Index creation/recreation.
  • Managed SQL Maintenance Jobs, Backups & Recovery, Index Rebuilds and DBCC Checks.
  • Managed DB Maintenance Plans and DBCC utilities and fixed data corruption in User databases.
  • Performed DBCC commands to test the physical and logical consistency of the Database.
  • Rebuild the indexes using DBCC re-index and also check index fragmentation.
  • Run DBCC consistency checks, fixing data corruption on application databases.
  • Performed DBCC utilities and fixed data corruption in User databases.
  • Used DBCC to troubleshoot issues related to database consistency.
  • Maintained the database consistency with DBCC at regular intervals.
  • Worked with Various DBCC commands to ensure Database Consistencies.
  • Used database consistency checks using DBCC utilities.
  • Used DBCC commands for maintaining the databases.
  • Scheduled and monitored all maintenance activities including database consistency check, index defragmentation using the DBCC commands.
  • Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks) Created reports based on database usage and perform capacity planning.
  • Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks) Responsible for creating user groups and assigning permissions.
  • Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.

Show More

5 Dbcc Jobs

No jobs at selected location

18. R2

demand arrow
average Demand
Here's how R2 is used in SQL Database Administrator jobs:
  • Involved in Database Administration and Production support for SQL Server2000/2005 on Windows NT 4.0 and Windows 2003.
  • Migrated and configured SQL Server 2008 R2 to SQL Server 2012 on a Clustered and Standby Environments.
  • Handled Responsibilities like installing, configuring and maintaining SQL server 2008 R2 Active/ Passive cluster.
  • Worked on 2008R2/2008& 2003 windows servers including Active Directory and proper disk configurations.
  • Maintained various databases for Production and Testing using SQL Server 2005/ 2008/ 2008R2.
  • Maintained various databases for Production and Testing using SQL Server 2014/2012 R2.
  • Worked on upgrading database from SQL Server 2008 R2 to 2012.
  • Maintained Production and Test Database Environment in SQL server 2012/2008R2/2008/2005.
  • Deployed and administered SQL 2008R2/2008 enterprise servers.
  • Implemented Database mirroring in SQL 2012/2008R2.
  • Migrated existing SQL Server 2000 databases to SQL 2005, SQL 2000 and SQL 2005 to SQL 2008 and SQL 2008R2.
  • Worked on a proof of concept for upgrading Windows 2008 with SQL 2008 to Windows 2012R2 with SQL 2014.
  • Migrated the SQL Server 2000/2005 to SQL Server 2008 and 2008 R2 versions.
  • Upgraded databases from SQL Server 2005 to SQL Server 2008 R2.
  • Migrated SQL Server 2005 to SQL Server 2008R2.
  • Upgrade Servers from SQL Server 2008 to SQL Server 2008R2 and extensively used upgrade advisor utility.
  • Deployed and Debugged SSIS packages using BIDs 2008 R2 and scheduled jobs for these packages.
  • Implemented DatabaseMail setting up Alerts in SQL 20012/2008R2.Implemented table partition on very large table.
  • Transferred Logins and Jobs from SQL Server 2005 to SQL Server 2008R2.
  • Maintain documents, standards, guidelines and methods Skills Used SQL Server 2012/2008R2/2005/2000, Perforce Version control tool.

Show More

4 R2 Jobs

No jobs at selected location

19. Disk

demand arrow
average Demand
Here's how Disk is used in SQL Database Administrator jobs:
  • Analyze memory and disk requirements across servers and provide recommendations to infrastructure team.
  • Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification.
  • Performed compression of historic data for VLDB and compressed backups to reduce amount of space it takes on disk.
  • Created and Deployed RDL in SSRS server to maintain Disk space monitoring of all servers including Stage Environment.
  • Maintain databases as assigned (monitor disk utilization, restore versions, etc.).
  • Monitored the server's status, database file growths, disk space alerts etc.
  • Monitored the SQL Server Jobs, database size, disk space in SQL Server.
  • Worked on Index optimization, Performance, Disk management, Disk partitions and optimizing.
  • Worked effectively in implementing Space, Disk Management and Security alerts using SQL Mail.
  • Prepare daily report on the job failures, backup failures and disk space.
  • Average results included 30 to 60 percent reduction in disk space requirements.
  • Created Maintenance Plans that helped in effective disk utilization and index maintenance.
  • Experienced in managing the use of disk space, memory and connections.
  • Monitored the use of disk space usage, memory and connections.
  • Configured Different RAID Levels (Redundant Array of Independent Disks).
  • Managed databases on multiple disks using Disk Mirroring and RAID technology.
  • Used space manager tool find space occupied on the disk.
  • Optimized the Disk space, Memory and User Connections.
  • Managed Disk space, memory and User connections.
  • Respond to backup failure alerts, high disk space usage alerts and take immediate action to resolve the issue.

Show More

2 Disk Jobs

No jobs at selected location

20. Service Packs

demand arrow
average Demand
Here's how Service Packs is used in SQL Database Administrator jobs:
  • Applied service packs & cumulative updates as per the requirement and/ or as a pro-active measure to meet Microsoft support deadlines.
  • Major responsibilities are SQL Server Installation and applying service packs, schedule database backups, database upgrades, performance tuning.
  • Installed SQL Server 2008/2005 on windows 2003/2008 servers, applied service packs and security fix for all servers.
  • Tested and installed latest SQL server / Windows server service packs on all SQL servers.
  • Applied Patches and Service packs to update different versions of MS SQL SERVER.
  • Applied SQL Server Service Packs on several installations of SQL Server 2012.
  • Evaluate Service Packs and provide minimal risk based strategy for implementation.
  • Patched server with latest SQL Server service packs and Cumulative updates.
  • Performed installation and update of latest SQL Server Service Packs.
  • Experience in applying Service Packs at database and OS Level.
  • Installed necessary Service Packs for SQL server 2008.
  • Apply Service Packs for SQL Server database.
  • Upgraded SQL Server 2000/2005/2008 to 2008 R2/2012 versions and applied SQL service packs and patches.
  • Applied service packs on SQL Server 2000 and SQL Server 2005.
  • Installed and configured standalone SQL Server 2005/2008, multi-instance servers and applied cumulative update packages & service packs.
  • Installed MS SQL Server 2005/2008R2/2012 updating with latest service packs and security patches.
  • Update SQL Servers with the new service packs and hotfixes as needed.
  • Worked on SQL Server 2005 with latest Service Packs.
  • Applied service packs and hotfixes to SQL servers.
  • Applied service packs on SQL servers Upgradation from SQL 2000/20005 to SQL 2008.

Show More

8 Service Packs Jobs

No jobs at selected location

21. Setup

demand arrow
average Demand
Here's how Setup is used in SQL Database Administrator jobs:
  • Installed, setup, configured and administered Blackberry server and managed Blackberry wireless devices.
  • Setup/configured replication between data center and DR facility.
  • Created Shared storage, created machine user names to resolve configuration issues in AlwaysOn availability setup.
  • Worked on SQL Always ON Setup and maintenance, MSSQL native replication, Backup and Recovery.
  • Experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control.
  • Experience in BI Reports design and BI Server setup and maintenance using Oracle 11G.
  • Involved in Setup high availability options such as database mirroring in SQL Server 2012.
  • Manage the setup of MS SQL Server databases at Business Continuity site.
  • Configured SMTP Server for Database Mail setup and received Alerts.
  • Installed SQL Server Management tools using SQL Server Setup Program.
  • Configured database mail, setup alert, created linked server.
  • Experienced with Clustering setup and Active Directory in Windows 2010.
  • Involved in replication setup, configuration and maintenance in Transactional Replication.
  • Configured two Active/Passive Clustering setups for failover on production servers.
  • Involved Setup active passive cluster in SQL 2012 environment Setup log shipping for several databases in SQL Server 2012.
  • Worked with business owners and other teams to setup and troubleshoot issues relating to replication and log shipping.
  • Worked with the Windows team to configure Windows Failover Cluster on which the Always-On setup was done.
  • Help setup data center including Racking Server, Cabling, IP-Planning, Firewall and OS.
  • Created and scheduled jobs to setup log shipping between production servers.
  • Configured ALWAYS ON setup between different Data centers and on Multi Subnet Cluster.

Show More

5 Setup Jobs

No jobs at selected location

22. Capacity Planning

demand arrow
average Demand
Here's how Capacity Planning is used in SQL Database Administrator jobs:
  • Involved in Capacity planning for large databases periodically and also in change management procedures, used remedy software.
  • Involved in Database optimization, performance tuning, monitoring and capacity planning.
  • Experienced with database sizing and capacity planning for production servers.
  • Customized Management Pack for database growth for capacity planning.
  • Monitored growth of database objects for capacity planning.
  • Involved in Capacity planning for large databases periodically.
  • Provided capacity planning and forecasting.
  • Conduct Capacity Planning - Monitor space usage, and adjust database as needed to support and satisfy all business initiatives.
  • Involved in capacity planning to estimate disk capacity, Processors and Memory as part of the future needs.
  • Maintain databases, including Updating statistics, Re-Indexing, Structure Modifications, Capacity Planning and Index Analysis.
  • Created Capacity planning templates for our department to project disk requirements for new and existing environments.
  • Worked on Capacity planning and database sizing for each of the projects.
  • Prepared Estimates for Database, table size growth rate for capacity planning.
  • Plan databases growth and changes as a part of yearly capacity planning.
  • Involved in capacity planning, sizing and database growth projections.
  • Created a number of databases for design and capacity planning.
  • Involved in capacity planning for new and existing applications.
  • Planned growth and changes (capacity planning.)
  • Involved in Capacity Planning, Database Normalization and De-normalization process.
  • Involved in Capacity Planning and adding new storage space as needed Configured Linked Servers.

Show More

25 Capacity Planning Jobs

No jobs at selected location

23. Ssas

demand arrow
average Demand
Here's how Ssas is used in SQL Database Administrator jobs:
  • Created multidimensional optimized cubes using SSAS.
  • Involved in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
  • Worked with Engineering & Prod teams on SSIS, SSAS, SSRS architecture, configuration, security, and administration.
  • Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
  • Involved in Installing and Configuring SSAS/SSRS as per the business requirements and working with the Technology Engineering team accordingly.
  • Managed MSSQL data warehouse, Wrote SSIS for ETL tools, SSAS for data analysis, SSRS for reports.
  • Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.
  • Partitioned the cube for better query performance and involved in processing the cube using SSAS.
  • Generate and process cubes using SSAS and using this data in the Dashboard reports.
  • Worked on various different deployment methods for SSIS, SSRS, and SSAS objects.
  • Created Cubes using SQL Server Analysis Services (SSAS) according to business requirements.
  • Created star schema in SSAS and developed SSRS reports based on the cubes.
  • Designed and developed OLAP using MS SQL Server Analysis Services (SSAS).
  • Involved in cube creation, and Browsing cube data using SSAS.
  • Experienced with SSAS cubes migration from 2000 to 2014.
  • Involved in deploying SSAS Databases using manifest files.
  • Secure and Deploy SSAS Cubes.
  • Build the cubes by using SSAS and SSIS.
  • Worked extensively on SSAS storage and partitions, aggregations and calculations Designed Master Package which executes a number of Child Packages.
  • Created various multi-dimensional cubes (SSAS), processed facts, dimensions and populated data for front end users.

Show More

1 Ssas Jobs

No jobs at selected location

24. DMV

demand arrow
average Demand
Here's how DMV is used in SQL Database Administrator jobs:
  • Resolved issues related the long running SQL queries using Dynamic Management Views (DMV's) & Activity Monitor.
  • Identify and resolved Blocking and Locking issue using DMV (Dynamic Management View) and Activity Monitor.
  • Analyzed and identified unused indexes in the databases using Catalog Views and DMV's and dropping them.
  • Tuned the Production Server to get the performance improvement by using my own DMV's.
  • Used server scoped DMV's and database scoped DMV's to trouble shoot issues.
  • Experience in using DMV and dynamic management functions for finding out long running queries.
  • Performed DBCC and DMV commands to troubleshoot issues related to database performance consistency.
  • Used DMV's to diagnose problems and monitor health of server instance.
  • Used DBCC and DMV commands for day-to-day troubleshooting tasks.
  • Used DMVS, DMFS, SP_PROCS for the instant analysis.
  • Checked Database Health and consistency by using DBCC Commands and DMVS Monitored and modified Performance using execution plans and Index tuning.
  • Resolved the Memory/IO/CPU/TempDB bottlenecks to achieve performance by making use of Windows Performance counters, SQL traces and DMVs.
  • Utilized DMVs, Performance Dash Boards, DB Mirroring, DB snapshots and tracking Performance Counters.
  • Worked with performance monitor, SQL Profiler and DMV's for Performance Monitoring.
  • Index Tuning and Optimization using Index Related DMVs and DTW.
  • Developed and optimized databases using stored procedures, DMVs, Triggers, Full-Text Indexing, XQuery, XML and user-defined functions.
  • Used DMVs, DMFs for Identifying missing indexes and Index usage stats, Fragmentation levels of Indexes for query/stored procedures tuning.
  • Involved in performance monitoring and tuning using SQL Profiler, DBCC commands, DMVs and Windows Performance monitor.
  • Tuned SQL Server using DMVs, SQL Profiler and Windows Performance Monitor.
  • Resolved long time running queries, Blocking, CPU/IO/Memory/Tempdb bottleneck issues by making use of dmvs and windows perf mon counters.

Show More

25. Performance Issues

demand arrow
average Demand
Here's how Performance Issues is used in SQL Database Administrator jobs:
  • Identified and resolved database performance issues, database capacity issues and other distributed data issues.
  • Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure optimal performance of the server.
  • Worked with functional staff to resolve day to day business processing issue or any performance issues on concurrent managers.
  • Worked on performance issues like server wide performance issue, database wide performance and stored procedure tuning issue.
  • Used Dynamic Management Views (DMV's) for monitoring and trouble shooting performance issues.
  • Created/collected performance trace logs and analyzed the trace log information to troubleshoot hardware performance issues.
  • Identified, tested, and resolved database performance issues to ensure data optimization.
  • Involved in troubleshooting dead lock issues and performance issues for optimal performance.
  • Involved in troubleshooting all the performance issues for different database applications.
  • Identify and resolve database performance issues, database capacity issues.
  • Resolved Performance Issues and Fine-tuned Queries and Stored Procedures.
  • Worked in performance issues on very large databases.
  • Respond and resolve database access and performance issues.
  • Resolved complex SQL server database performance issues.
  • Resolved the TEMPDB performance issues.
  • Moved production BI data & dev data between different file groups to resolve the space and database performance issues.
  • Utilize DMVs, Performance Monitor Counters and Alerts to quickly find the Root Cause of performance issues.
  • Involved in troubleshooting front end applications designed in ASP.NET for connectivity issues and backend performance issues.
  • Set up traces and Profiler to fix performance issues.
  • Monitored SQL server performance using profiler to find performance issues, deadlocks and blockings.

Show More

26. Trouble Shooting

demand arrow
average Demand
Here's how Trouble Shooting is used in SQL Database Administrator jobs:
  • Used DBCC commands, System monitor, Dynamic views, Actual Execution plans as part of trouble shooting and performance tuning.
  • Performed trouble shooting of Client connections, viewing error log and applications and designed cubes with star schema using SSAS.
  • Trouble shooting various SQL Server 2008, 2005 and 2000 Database connectivity issues from the web applications.
  • Configured and Monitored Log shipping server to create standby environment and trouble shooting of errors.
  • Trouble shooting of various 400 and 500 level error in IIS based web application.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Managed trouble shooting of Client connections, viewing error log and applications.
  • Perform general technical trouble shooting and give consultation to development teams.
  • Involved in trouble shooting performance issues after the server moves.
  • Trouble Shooting and Solving the Production issues.
  • Experience in trouble shooting database issues.
  • Involved in Monitoring and involved in trouble shooting replication issues Configured Server Memory for maximum Performance and effective utilization.
  • Monitored Log shipping/ Transactional Replication and trouble shooting of errors.
  • Trouble shooting and supporting all user problems by using SQL server profiler and network traces, windows logs etc.
  • Trouble shooting performance issues and resolve them in a timely manner.
  • Trouble shooting Problems by using SQL server profiler.
  • Trouble shooting Tempdb full issues.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency Monitoring the servers using Idera third party software.
  • Set up and Monitored transactional replication, Database mirroring on Production, QA and Dev servers and trouble shooting of errors.
  • Installed, Configured, Worked with Foglight for SQLServer tool Experience in trouble shooting database issues.

Show More

27. Hot Fixes

demand arrow
average Demand
Here's how Hot Fixes is used in SQL Database Administrator jobs:
  • Installed Windows 2003 x64 server nodes with Sp2 and hot fixes, allocate SAN space and configure MSCS cluster.
  • Worked with other enterprise teams to coordinate deployment, configuring services, applying patches and hot fixes.
  • Installed and applied Service Packs/Hot fixes and created documentation for tracking and SQL server installation purposes.
  • Experience in upgrading SQL Server software to new versions and applying Service packs and hot fixes.
  • Experience in upgrading SQL Server and applying service packs and hot fixes and unattended Installations.
  • Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes.
  • Coordinated with admins on implementing hot fixes and service packs on production servers.
  • Worked on upgrading SQL server instances and applying service packs and hot fixes.
  • Installed and configured SQL server 2000 and applied service packs and hot fixes.
  • Created documentation to install SQL Server, apply service pack, hot fixes.
  • Planned & executed upgrades such as Service Pack, Hot fixes etc.
  • Involved in installation of service packs and hot fixes.
  • Applied hot fixes and Service Packs in clustering environments.
  • Managed and coordinated SQL Patches, Hot Fixes.
  • Installed the services packs and hot fixes.
  • Upgrade from SQL server 2005 to 2008, applies patches and hot fixes.
  • Performed upgrades through Oracle version 7.6/8/8i & 9i and Installed Patches and Hot Fixes accordingly maintaining uninterrupted system applications uptime.
  • Install and configure latest Service Packs/Hot Fixes on SQL 2008R2, 2012 and 2014 servers.
  • Applied patches, hot fixes, cleared .NET framework corruption errors.
  • Applied SP and HOT Fixes on SQL Server 2000, 2005, 2008R2 Managed Security.

Show More

28. Server Performance

demand arrow
average Demand
Here's how Server Performance is used in SQL Database Administrator jobs:
  • Worked on Performance counter Monitoring server performance.
  • Monitor SQL Server/Oracle database server performance.
  • Monitored and tune databases, indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2008.
  • Evaluated Application, CPU, Disk I/O and Memory related bottlenecks using Performance Monitor and improved the SQL server performance.
  • Configured schedules to capture counters on regular basis to bench mark the SQL server performance.
  • Monitored SQL server performance for hundreds of thousands of transactions during daily peak load processing.
  • Rebuild and reorganize Indexes on tables to reduce fragmentation and enhance SQL server Performance.
  • Experienced with improving SQL Server using windows performance monitor to improve the server performance.
  • Solved SQL Server performance issues; Tuned and optimized Queries for maximum efficiency.
  • Designed report on the monitoring of SQL Server Performance using MS Access.
  • Designed a report on the monitoring of SQL Server Performance.
  • Monitored MS SQL Server performance and network issues.
  • Experience in improving SQL Server performance by using index tuning wizards, performance tuning methods, execution plans and profilers.
  • Worked with SQL Server Performance Monitoring Tools like Microsoft Performance Monitor, SQL Server Profiler and Helped in Database Consistency.
  • Used Quest Foglight and Quest Spotlight tools to monitor SQL Server Performance and to generate Performance reports.
  • Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
  • Used 3rd party tools like Red gate and LANsweeper to monitor SQL server performance.
  • Implementedmaintained customized log shipping and monitored MS SQL Server performance and network issues.
  • Monitored SQL Server performance using profiler to find performance and dead locks.
  • Monitored SQL server performance using profiler, Index tuning advisor for query tuning, stored procs.

Show More

29. BCP

demand arrow
average Demand
Here's how BCP is used in SQL Database Administrator jobs:
  • Verified program logic by preparing test data for trial runs by designing SQL Server 2000 DTS processes and utilizing BCP/Bulk load.
  • Automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases.
  • Exported and imported data from text files and Excel to SQL Server using bulk insert and BCP utility.
  • Used BCP and Bulk Insert utilities and Worked with SQL Server Reporting Services (SSRS).
  • Implemented several packages to import and export using BCP and bulk insert programs.
  • Performed various data transforms between various servers using BCP and DTS.
  • Used Stored Procedures, DTS packages, BCP for updating Servers.
  • Import data across multiple instances using BULK INSERT and BCP Utility.
  • Used BCP to move in or out data from different sources.
  • Used BCP utility to publish table output to text files.
  • Migrated databases among the servers using BCP, attach/detach utilities.
  • Imported and exported data using BCP and bulk insert utilities.
  • Configured SQL Mirroring as BCP for DR.
  • Used BCP and Bulk Insert utilities.
  • Used BCP for data transfers.
  • Performed data transfers using BCP.
  • Transfer data from flat files, Excel spreadsheets to and from SQL Server using DTS, BCP and Bulk Insert.
  • Experience with Data migration utilities (Import & Export, BCP, Bulk Insert) from text to SQL Server.
  • Utilized SSIS for BCP processing of data from RPData in Australia to store data locally.
  • Used BCP to export the xml data between different servers.

Show More

30. Wizard

demand arrow
low Demand
Here's how Wizard is used in SQL Database Administrator jobs:
  • Experience in troubleshooting ASE/SQL issues by using SQL Tools, execution plans, Trace, statistics, index tuning wizard etc...
  • Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
  • Created and modified Clustered and Non Clustered Indexes to optimize the queries using Index Tuning Wizard.
  • Migrated DTS packages to SSIS (SQL Server Integration Services) using DTS migration wizard.
  • Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
  • Created/Managed databases using SSMS, Database Wizard and T-SQL Statements (Scripts).
  • Performed Query Optimization by extensive use of Index implementation and Index Tuning Wizard.
  • Used the Index tuning wizard and rebuilt indexes for faster query response.
  • Performed data transfers through SQL Server import and export wizard.
  • Optimized stored procedures and indexed query using Index Tuning Wizard.
  • Worked with Index tuning wizards for development databases.
  • Created many SSIS packages using Import/Export Wizard.
  • Experienced in trouble shooting, performance tuning, query tuning, index tuning using DBCC command, Wizards and SQL Profiler.
  • Involved in performance tuning using Activity Monitor, Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
  • Provide and Monitor database health - availability, reliability, performance and capacity planning using SQL Profiler, Database Tuning Wizards.
  • Involve in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
  • Used SQL Server Tools Import/Export Wizard, Enterprise Manager, SSMS, SQL Profiler and Query Analyzer.
  • Identified and resolved the query performance using SQL Profiler and Index tuning wizard.
  • Updated the multi-dimensional cube data using SSIS- Import/Export wizard.
  • Experience using Native SQL Server tools including Profiler, Index tuning wizard, database tuning advisor.

Show More

31. Data Warehouse

demand arrow
low Demand
Here's how Data Warehouse is used in SQL Database Administrator jobs:
  • Worked closely with Data Warehouse team and performed optimization of SQL queries which resulted in substantial performance improvement.
  • Developed and implemented centralized reporting database and data warehouse combining data from multiple sources.
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
  • Design, development, troubleshooting, debugging and maintenance of enterprise data warehouse systems of more than 1TB of database.
  • Support & maintain existing systems including; data warehouse, scale house dispatch system, employee directory & file transfers.
  • Created and maintain SSIS/ETL packages using Business Intelligence Development Studio (BIDS) 2008/2010 importing and exporting data warehouse.
  • Worked with SQL Server 2005 Integration Services to create complex packages for numerous Data Warehouse projects.
  • Created stored procedures to build the Fact tables in the data warehouse cubes for Multi-Dimensional analysis.
  • Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
  • Implemented SQL Server Database Partitioning, Archiving and Purging to improve the performance of data warehouse.
  • Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
  • Created packages using SSIS to migrate data from different data sources to data warehouse.
  • Constructed views, tables and complex queries to upload data to data warehouse.
  • Designed, developed data warehouse, creating archival system for Costco Accounts Payable.
  • Involved in Tabular Data warehouse operations for SSAS 2008 OLAP databases.
  • Design, Deploy and Process cubes for Data warehouse database.
  • Involved in database Normalization, logical and physical data modeling Transferred data (ETL) to Data warehouse Environment using SSIS.
  • Designed and facilitated the implementation of data warehouses required by application systems Supported OLAP team to providing data from SQL Servers.
  • Involved in Design of Data warehouse using Kimball and Star Schema and created Fact tables and dimension table.
  • Developed SSAS cubes for newly created data warehouse for analytical teams to generate ad hoc analysis charts and reports.

Show More

8 Data Warehouse Jobs

No jobs at selected location

32. IIS

demand arrow
low Demand
Here's how IIS is used in SQL Database Administrator jobs:
  • Access programmer and I was also the IIS admin and Admin of SQL SPO Tracking database.
  • Configured the IIS in all the servers during the process of configuring the reporting services.
  • Installed, implemented and administered web-based systems (IIS/SQL) for employees and customers.
  • Install and Configure SSL Certificates to ensure security of the websites deployed on IIS6.0/7.0.
  • Assisted developers in various aspects with all SQL / IIS and network problems.
  • Configured DNS and Load balanced request for IIS 7.5 and IIS 8 websites.
  • Trouble shooting IIS and reporting services errors like (HTTP:401 etc).
  • Experience with IIS (Internet Information Services) 5.0/6.0.
  • Installed, configured and administered IIS and SQL Servers.
  • Experience with IIS support for SSRS Reporting Website.
  • Have good understanding in IIS Administration and configuration.
  • Resolved issues between IIS and SQL Server.
  • Installed, Deployed and administered IIS.
  • Experience in IIS & Web Server.
  • Worked with IIS (Internet Information Services) 5.0/6.0 Creation and management of Database maintenance plan for various database consistency checks.
  • Installed and configured .NET applications on IIS 4.0 web server and Microsoft Windows 2000 and 2003 server.
  • Sole IIS admin and SQL admin for company servers hosted at Rackspace.
  • Load balanced IIS sites using F5 BIG-IP load balancer.
  • Managed Security by creating login/groups and assigning appropriate permissions Provided Secondary Support to IIS Web Servers.
  • Supported the netsclar load balancer, Akamai and IIS servers as part of the routine activities.

Show More

33. Execution Plans

demand arrow
low Demand
Here's how Execution Plans is used in SQL Database Administrator jobs:
  • Analyzed Query Execution plans and created clustered and non-Clustered indexes for better query performance.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Analyze execution plans and generate suggestions for improvement.
  • Involved in analyzing execution plans for database optimization.
  • Implemented troubleshooting of SQL Server performance issues using SQL Tools, execution plans, Trace, statistics, index tuning wizard.
  • Involved in the Query optimization and Performance tuning, and also tuned SQL queries using Show plans and Execution plans.
  • Tuned SQL Queries by examining execution plans, creating plan guides, adding hint words, tuning indexes.
  • Identify issues in execution plans, index coverage, SQL Server statistics and query optimization.
  • Monitored and modified Performance using execution plans and Tuning the Index's as per requirement.
  • Worked on Performance Tuning and Optimizing Queries by analyzing Execution Plans and Re-designing Indexes.
  • Checked performance and tuning, indexing, query optimization and query execution plans.
  • Analyzed execution plans, and tuned queries and databases for better optimal performance.
  • Fine-tuned complex SQL queries by analyzing the query execution plans.
  • Used Execution Plans to fine tune Stored Procedure performance.
  • Analyze estimated and actual execution plans in depth.
  • Tuned stored procedures by using execution plans.
  • Perform query optimizations and query execution plans.
  • Performed stored procedure and SQL script tuning using Microsoft best practices, execution plans and the profiler information.
  • Involved in running the SQL Profiler for better execution Plans.
  • Involved in improving the databases performance tuning using profilers, execution plans and index tuning wizards.

Show More

34. Management Studio

demand arrow
low Demand
Here's how Management Studio is used in SQL Database Administrator jobs:
  • Schedule backups for databases and transaction log across different environments using SQL Server Management Studio.
  • Implemented the calculations to aggregate physical measures using management studio.
  • Used SQL server 2005 tools like Management Studio, Query Editor, Business Intelligence Management Studio including SSIS and Reporting Services.
  • Performed daily tasks including backup and restore using SQL Server tools like SQL Server Management Studio and, SQL Server Agent.
  • Developed SSIS packages for importing and exporting data from MS Access, Excel and deployed into SQL server management studio.
  • Migrated SQL Server 2008R2 databases to SQL server 2014 by using Backup-Restore and Management Studio Wizards and custom scripts.
  • Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
  • Used SQL Server Management Studio (SSMS) for monitoring, troubleshooting and addressing database related issues.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Used SQL server management studio and reporting tools to design, and manage SQL environments.
  • Performed daily tasks such as backup and restore by using SQL Server Management Studio.
  • Create and manage databases across Development and Production instances using SQL Server Management Studio.
  • Worked on Client/Server tools like SQL Server Management Studio to administer SQL Server.
  • Created database diagrams in SQL Server Management Studio (SSMS).
  • Created SSIS jobs and scheduled Packages using SQL Server Management Studio.
  • Reviewed many T-SQL issues using management studio for better performance.
  • Set up asynchronous mirroring using MS Management Studio.
  • Configured Transactional Replication and Log Shipping using SQL Server Management Studio.
  • Experienced with SQL Server 2005 profiler, SQL Server management studio and Business intelligent development studio.
  • Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Show More

35. CPU

demand arrow
low Demand
Here's how CPU is used in SQL Database Administrator jobs:
  • Used System monitor to find the bottlenecks in CPU, Disk I/O and memory devices and improved the database server performance.
  • Experience in Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008.
  • Experience in analyzing the behavior of the production system data such as performance logs, CPU Usage and Pages/Sec.
  • Resolve blocking and deadlocking issues, high CPU / memory, analyze job timeouts, or performance problems.
  • Monitored database status including CPU, memory, I/O, space, and deadlocks using SQL Server utilities.
  • Created Daily System Health Checks Reports for Space, CPU, Memory, Table Statistics, Indexes.
  • Involved in monitoring of server performance like checking up the CPU usage status and I/O status.
  • Detected and troubleshoot SQL Server related CPU, memory, I/O and disk space.
  • Monitor database space, performance issues, CPU, memory and connectivity issues.
  • Identify high CPU, network contention queries and assist developers with tuning queries.
  • Involved in Data Compression, Hot add CPU, Fact Table size reduction.
  • Identified and resolved Performance bottlenecks at CPU, Memory and Disk I/O.
  • Detected and troubleshot Server related CPU/memory, I/O using Performance Monitor.
  • Fixed problems related to memory, CPU, I/O, Disk, etc.
  • Applied CPU/PSU and one off patches.
  • General Tuning and Troubleshooting Bottlenecks (Memory, I/O, CPU) Reversed engineering ASP.NET code to troubleshoot embedded SQL Queries.
  • Reviewed, recommended and installed Patches, Patch Sets and CPUs (Critical Patch Updates) for the databases.
  • Monitored all databases status including CPU, Memory, I/O, Space Management, Backup and recovery.
  • Used PerfMon and Profiler Trace to monitor the Memory, CPU and Disk usage.
  • Configured monitoring jobs to monitor CPU usage, Blockings, Login tracking, Tempdb utilization on Production servers.

Show More

2 CPU Jobs

No jobs at selected location

36. SAN

demand arrow
low Demand
Here's how SAN is used in SQL Database Administrator jobs:
  • Worked with the Windows, VM and SAN, Networking, Security teams for building new servers and migrating servers.
  • Involved in the migration of existing DB environment to a highly available Active Passive Clustering SAN DB environment.
  • Installed and administered two-node cluster Active/Passive on Microsoft Windows Server 2008 R2 Enterprise Edition in SAN environment.
  • Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
  • Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
  • Worked in Automatic Storage Management (ASM) with EMC storage for managing data in SAN.
  • Involved in maintenance and configuration of Database Servers to connect with SAN Storage Environment.
  • Installed and configured Storage Area Networks (SAN) in a heterogeneous environment.
  • Used Cassandra (NoSQL) to build user achievement system.
  • Implemented row and page compression to save SAN space.
  • Implemented SQL Server with high availability architecture using SAN.
  • Experience working both SAN/ NAS storage technologies.
  • Implemented Failover Clustering in Active/Active and Active/Passive configurations for High availability and managed SQL Server Clusters in SAN environments.
  • Applied DBArtisan, OEM, and automated scripts to establish: dynamic performance monitoring, database troubleshooting and resource contentions resolution.
  • Performed Installation and Configuration of SQL Enterprise 2014 SP1 to utilize SAN storage on Windows 2012 SP1 Failover Clusters.
  • Experience in adding the SAN to the windows cluster for the failover mechanism.
  • Optimize the tempDB performance by striping and move to dedicated SAN.
  • Configured the new servers using failover clustering and SAN technology.
  • Experience working with SAN disks solution for database servers.
  • Experience with BMC Patrol, DBArtisan, Quest Fpass.

Show More

37. Oltp

demand arrow
low Demand
Here's how Oltp is used in SQL Database Administrator jobs:
  • Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
  • Played the role of a Production DBA giving 24/7 support to crucial OLTP and DSS systems on standalone and Virtual systems.
  • Configure the physical design of the database by implementing OFA compliance that suites both OLTP and Data warehouse applications.
  • Experience with Distributed transactions building linked servers, complex queries, error handling using SAVEPOINT in OLTP transactions.
  • Supported Very Large databases (VLDB) up to 3TB and troubleshooting the problems in OLTP Environment.
  • Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
  • Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
  • Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
  • Provided 24x7 support for OLTP and Data warehouse environments for both production and non-production.
  • Created Physical Data Model (PDM) for the OLTP application using ER Studio.
  • Developed Logical and Physical Database models to design OLTP systems for IBO applications.
  • Developed SSIS packages to export data from OLTP database to OLAP database.
  • Experienced in Enterprise Data Warehousing and Data Mart in OLTP/OLAP environment.
  • Provided database support for databases involving huge transactions (OLTP/OLAP).
  • Facilitate and manage efficiently the transactions by OLTP and OLAP.
  • Implemented Partitioning on OLTP table to boost up Performance.
  • Implemented in memory OLTP feature in SQL Server 2014.
  • Involved in normalization of the Database in OLTP.
  • Experience in working high transacted OLTP systems.
  • Configured transactional replication between OLTP server and report server.

Show More

13 Oltp Jobs

No jobs at selected location

38. XML

demand arrow
low Demand
Here's how XML is used in SQL Database Administrator jobs:
  • Imported / exported and manipulated data between different platforms such as XML, Excel, Access for SAIS and its vendors.
  • Experience in creating master and child packages, using package configurations (XML, SQL Server) and SSIS logging.
  • Involve in Data Extraction, Loading using SSIS and create very complex SSIS packages to import data using XML files.
  • Experience in using XMLA protocol for SQL Server Analysis Services2005 for interaction between client application and instance of Analysis Services.
  • Performed Dimensional Modeling, Indexing, SVN Subversion (Source Code Repository), XMLA, MDX and DAX.
  • Designed and implemented XML extraction code in Python modules for extracting XML documents in readable format for management.
  • Implemented and designed SSAS server, cubes, automated backup and restore using PowerShell and XMLA scripts.
  • Implemented the use of Microsoft Index Server for the indexing and searching of XML files.
  • Deployed reports in various sources like XML, Web Browser and PDF.
  • Involved in writing stored procedures, triggers and generating XML objects.
  • Created XML files by using SSIS Package Configuration.
  • Set up XML data structure for internal database.
  • Parse and Create XML and update database.
  • Create export file in XML format.
  • Generated XML plan for T-SQL performance.
  • Utilized VB DLL, EXE, XML, XSLT, XML Schema, Source Safe.
  • Created XML, PDF, EXCEL files using SSRS.
  • Worked on SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
  • Design & Development of various UI of the application using ASP.NET, XML, HTML &JavaScript.
  • Created XML Queries and produced complex XML structure for Frontend processing.

Show More

39. Regular Intervals

demand arrow
low Demand
Here's how Regular Intervals is used in SQL Database Administrator jobs:
  • Evaluated indexes at regular intervals and rebuilt as necessary for performance improvement.
  • Perform database consistency checks at regular intervals.
  • Refresh DEV\TEST environment databases at regular intervals.
  • Checked consistency, fragmentation, torn page detection in databases using DBCC commands and DMV's at regular intervals.
  • Monitored the SQL Server Logs and Application Logs at regular intervals to analyze the application and system behavior.
  • Worked on rebuilding the indexes at regular intervals by setting up the fragmentation levels for better performance.
  • Identified unused indexes and created a script to identify the same at regular intervals.
  • Experience with rebuilding the indexes and statistics update at regular intervals for better performance.
  • Rebuild, reorganized and monitored the Indexes at regular intervals for better performance.
  • Maintained the database consistency with DMV and DMF's at regular intervals.
  • Verified backups in regular intervals of time and created disaster recovery plan.
  • Involved in rebuilding and reorganizing the indexes on regular intervals.
  • Rebuild indexes at regular intervals for better performance.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Rebuilding the indexes at regular intervals for better performance.
  • Performed Query Optimization by extensive use of Index implementation and ITW Maintained the database consistency with DBCC commands at regular intervals.
  • Experienced in troubleshooting production servers and fixed the user and application issues Rebuilding the indexes at regular intervals for better performance.
  • Handled numerous change management requests on production and UAT servers Maintaining the database consistency with DBCC utility at regular intervals.
  • Worked on simple to complex SQL Queries and TSQL statements Rebuilding the indexes at regular intervals for better performance.
  • Created, removed and rebuilt the indexes at regular intervals for better performance of queries and packages.
  • Automated the Databases Consistent Check ( DBCC) using maintaince plan at regular intervals.

Show More

40. Security Policies

demand arrow
low Demand
Here's how Security Policies is used in SQL Database Administrator jobs:
  • Created new security policies and implemented them across database environments.
  • Implemented and maintained security policies and procedures.
  • Contribute content to corporate security policies.
  • Worked as SQL Server DBA to lead the team in audit action plans including security policies & its compliance & remediation.
  • Used SCCM to monitor Servers, keeping the software-up-to-date, setting configuration and security policies.
  • Developed best practices, maintenance, security policies and procedures, disaster recovery strategies.
  • Lead for SQL Server Compliance and Auditing to satisfy Auditors and client security policies.
  • Designed, implemented and enforced SQL Server security policies according to client's Baseline.
  • Design, implement and maintain database backup and recovery strategies and security policies.
  • Created and managing Users, Roles and Groups and handling database security policies.
  • Designed and implemented Security policies as per the business requirement for SQL Servers.
  • Implemented MS SQL Server security policies and granted object level permissions.
  • Implement and enforce Database Security policies of the company.
  • Managed SQL Server accounts and security policies.
  • Implemented SQL Server and Database security policies.
  • Implemented security policies for SSRS reports.
  • Safeguard production systems by implementing proper security policies, as well as managing the MS service pack / hotfix deployment process.
  • Implemented of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
  • Implemented SQL Server security policies and granted object level permissions to ensure least privilege.
  • Implemented SQL server logins, Users and Roles as a part of security policies.

Show More

41. Update Statistics

demand arrow
low Demand
Here's how Update Statistics is used in SQL Database Administrator jobs:
  • Performed maintenance activities like analyzing/rebuilding indexes, update statistics based on business needs.
  • Experience in Index Maintenance, Handling Fragmentation, Creating Indexes, running DBCC checks and Update Statistics to ensure Data Integrity.
  • Created Maintenance Plan for Database Integrity Checks, Update Statistics for Indexing, Online Re-indexing and SQL Server backup.
  • Configure and manage database maintenance plans for update statistics, database integrity check, backup operations and Indexing updates.
  • Configured the Maintenance plans such as Rebuild, Re-organizing Indexes and Update Statistics accordingly to increase the DB performance.
  • Configured SQL Server maintenance plans to automatically back up SQL Server Databases, optimize index and update statistics.
  • Run DBCC consistency checks, rebuild indexes, and update statistics for databases on regular basis.
  • Created Maintenance Plans for backups, rebuilding of indexes, database integrity checks and update statistics.
  • Created Maintenance standards like Index Reorganization, Tuning, Update Statistics, Maintenance plans etc.
  • Created Maintenance jobs for database and log backups, Shrink DB, Update Statistics.
  • Scheduled Maintenance plans for Backups, Rebuild-Index and Update statistics.
  • Update statistics, database integrity check and Backup operations.
  • Update statistics, and database integrity.
  • Update statistics, database integrity check.
  • Scheduled and monitored all maintenance activities of SQL Server, including checks on database consistency, index de-fragmentation and update statistics.
  • Create and Maintaining Database Maintenance Tasks, including Database Consistency Check, Re- Index Update Statistics and Backups.
  • Created and scheduled Database Maintenance plans for Database Consistency checks, Index Rebuild/Reorg/Update Statistics etc.
  • Index Data Management to determine Defragmentation level; whether to Update Statistics or Rebuild Indexes.
  • Created backup, Integrity check, Index reorg/rebuild and update statistics using Maintenance plan.
  • Index rebuild and update statistics, Database Backup , Data Imports and Exports.

Show More

42. Sharepoint

demand arrow
low Demand
Here's how Sharepoint is used in SQL Database Administrator jobs:
  • Implemented a Customer Records Management system using SharePoint Portal Server.
  • Used SharePoint server as Ticketing System/ Documentation.
  • Delivered SharePoint training to users and administrators.
  • Deployed reports to the Report server in Native Mode & SharePoint Integrated Mode and implemented Report delivery using Subscription in SSRS.
  • Installed and configured Active/Passive SQL cluster with SQL Server 2008 R2 for high availability of SharePoint 2010.
  • Implemented the Reporting Services in SQL Server 2008 and integrate the Microsoft SharePoint portal with Reporting services.
  • Worked with SharePoint administration team to configure and implement Business intelligence features for SQL Server i.e.
  • Created log-shipping for Microsoft SharePoint (Content databases) using Lite speed for SQL server 2005.
  • Supported SQL server databases in ERP, SharePoint, BizTalk applications, Microsoft Dynamics- CRM.
  • Installed, configured, operated and troubleshot Windows SharePoint Portal Services.
  • Provided support to SharePoint servers, MySQL, PostgreSQL databases.
  • Created reports using SSRS and deployed on to SharePoint Servers.
  • Deployed these reports into the SharePoint after developing the reports.
  • Created and maintained websites using Windows SharePoint Team Services.
  • Worked with SharePoint developers in building custom web parts.
  • Managed and monitored content databases in Sharepoint 2010.
  • Worked on databases with Citrix based Sharepoint environments.
  • Supported and maintenance of Enterprise Asset Management Maximo, MS Dynamics GP, Laserfiche, and SharePoint
  • Worked with Sharepoint teams to recover Sharepoint databases.
  • Worked on Sharepoint database schema's, Sharepoint Primer, Sharepoint Performance & High Availability environment.

Show More

43. Olap

demand arrow
low Demand
Here's how Olap is used in SQL Database Administrator jobs:
  • Created and Configured OLAP Cubes using SQL Server 2005 Analysis Services and Performance tuning and scaling to large numbers of users.
  • Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments.
  • Involved in Designing and Implementation of data warehousing solution which includes Building an OLAP database, creating data source.
  • Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS 2012 and 2008 OLAP databases.
  • Configured the Analysis Services 2008, setup the cubes, configured the HTTP for OLAP Cubes.
  • Created / modified OLAP Cubes using SQL Analyzer including fact tables, dimensions and calculated measures.
  • Evaluated OLAP tools, and built web-based OLAP cube reporting systems around it.
  • Installed and configured SQL Server Analysis services for OLAP, Data Mart.
  • Worked on setting up backup jobs for OLAP databases.
  • Maintained 3.5 terabyte data warehouse used in OLAP and multi-dimensional analysis.
  • Work with SQL Server 2005 Analysis Services to build OLAP Cubes as a backend Data Source for SSRS.
  • Involved in Migration all SQL Analysis services (OLAP) cubes from old Eportal Servers to the new servers
  • Implemented an OLAP Data warehouse to Create BI reports using Crystal Reports& Excel for Multi-Million dollar Arbitration.
  • Designed and architected of OLAP cubes to support business reporting and forecasting processes.
  • Researched and developed a data warehouse using Microsoft Sql OLAP server.
  • Develop various types of OLAP ad-hoc reports using Micro strategy.
  • Involved in creating Olap Cubes and experienced in Data Mining.
  • Created a multi-partition of Finance Cube for improving OLAP performance.
  • Developed customized reports utilizing multi-dimensional tables using pre-aggregated OLAP cubes that provided drill down capability of historical loan data.
  • Created report models for ad-hoc reports using SSRS 2012 Developed reports from OLAP cubes using SSRS 2012.

Show More

2 Olap Jobs

No jobs at selected location

44. DEV

demand arrow
low Demand
Here's how DEV is used in SQL Database Administrator jobs:
  • Developed Oracle Database Backups & Recovery Strategies and created High Availability processes using Windows Clustering and Database Replication Technologies and FTP.
  • Created and administered multiple development, training and production databases.
  • Developed load-balancing processes to eliminate down time for backup processes.
  • Created Backup strategy for production and development environment.
  • Developed source to target specifications.
  • Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
  • Involved in developing E-R diagrams, logical & physical data modeling, development and implementation of the system with ERWIN.
  • Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
  • Involved in Weekly Change Management, in which code developed by developers is being run on production server.
  • Installed and Configured Microsoft SQL server 2000 instances on Production, Development Environments and Replication servers.
  • Developed data models for applications, metadata tables, views or related database structures.
  • Worked with development teams in the design of physical databases and in modification.
  • Developed or maintained archived procedures, procedural codes, or queries for applications.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Installed of MS SQL 2008/2012 on production, Test and Development boxes.
  • Developed backup & restore scripts for SQL Server as needed.
  • Assist SQL developers to optimize SQL queries and Stored Procedures.
  • Mocked up data and testing Environment: Oracle 9i, Windows NT/2000, SQL developer, Oracle Data Modeler
  • Planned and Successfully Installed SQL Server 2005, 2008 on the Production and Development Servers.
  • Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.

Show More

45. Vmware

demand arrow
low Demand
Here's how Vmware is used in SQL Database Administrator jobs:
  • Maintain consistent development, testing, staging and production environments, both on physical machines and VMware virtual machines.
  • Installed SQL Server 2012 standalone instances on Virtual servers (VMware) in Production, UAT and development environments.
  • Experience in installing and configuring MS SQL Server Database Engine on physical and virtual servers (VMWare).
  • Installed, Configured, Monitored, Troubleshooting SQL server 2012/2008R2/2008/2005 on VMware and Standby Environments.
  • Experience MS SQL & Sybase server VMWARE and WSFC Clustering configuration and support.
  • Experienced in designing and deploying HA and DR solutions using VMware technologies.
  • Experienced configuring and working Microsoft SQL server 2012/2008R2/2005 on VMware Environment.
  • Experience in solving SQL server performance issues on VMware environments.
  • Installed and administered Microsoft SQL SERVER on VMWare virtual machine.
  • Migrate SQL server database from physical to VMware servers.
  • Installed configured SQL Server in Virtual Environments using VMWare.
  • Experience in maintaining database in virtual environment like VMware.
  • Worked extensively on Virtual and VMware Environments.
  • Set up SQL Server configuration settings and analyze hardware requirements for server clusters in VMware virtualized environment.
  • Analyzed hardware requirements for server clusters in VMware virtualized environment.
  • Migrated databases from SQL Server 2005/2008R2 to SQL Server 2008 R2/2012/2014 Migrated SQL servers from physical to VMware virtual environment.
  • Installed and configured SQL Server on 100+ VM's and workstations using VMware Workstation and vSphere.
  • Performed new SQL Server 2012 installations on VMware host servers and Hypervisor environments.
  • Completed certified training from VMware in vSphere 5.1 Install, Configure, Manage.
  • Experience of sql servers on VMware virtualization technologies.

Show More

46. Database Integrity Checks

demand arrow
low Demand
Here's how Database Integrity Checks is used in SQL Database Administrator jobs:
  • Created maintenance plans for database/log backups, offline index reorganize/rebuild, statistics update, database integrity checks.
  • Developed database maintenance plan for database backups and recovery, reorganizing data and database integrity checks.
  • Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing on IT and Mobility environments.
  • Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing through Maintenance Plan.
  • Performed database integrity checks using DBCC utilities and maintenance plan configuration wizard.
  • Developed and implemented maintenance stored procedures for Database Integrity Checks, Update Database Statistics, and rebuilding and reorganizing the indexes.
  • Set up Database Maintenance Plan for the Database Integrity Checks, Update Database Statistics, cleansing and solving data base troubles.
  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Created maintenance jobs for performance of SQL Server which includes updating statistics, database integrity checks and Index Rebuild.
  • Create Maintenance planes for Database integrity checks and Index-rebuild on a Regular basis to maintain good database health.
  • Created Database Maintenance Plans for Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Created Database Maintenance Planner for SQL Server which covers Database Integrity Checks.
  • Scheduled the Administrative Tasks like Database Integrity Checks and maintenance plans.
  • Created Database maintenance plans and performed DBCC Database Integrity Checks.
  • Created Database Maintenance Plansfor Database Integrity Checks, Update Database Statistics and Re-indexing and backups.
  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks using DBCC utilities and DMVs.
  • Used Symantec Netback up for backups and maintenance jobs which includes updating statistics, database integrity checks.

Show More

47. DDL

demand arrow
low Demand
Here's how DDL is used in SQL Database Administrator jobs:
  • Used DDL to define indexes (keys), specifies links between tables, and imposes constraints between tables.
  • Created and modified tables After/Instead of Stored procedure, run DDL and DML, create indexes and views.
  • Used DDL and DML to writing triggers, developed stored procedure, functions, views and triggers.
  • Used DDL trigger and change data capture (CDC) for Data base Auditing.
  • Used DDL and DML for writing triggers, stored procedures, and data manipulation.
  • Perform complex DDL and DML operations to create, maintain and optimize T-SQL scripts.
  • Developed T-SQL (DDL, DML) statements using dynamically generated SQL.
  • Created DDL triggers for auditing any DDL change in SQL 2005/2008R2/2012.
  • Developed views, DDL triggers and user-defined functions.
  • Ensured Middleware application programs and documentation were correctly performed as specified prior to full release to supported sites.
  • Developed and implemented test procedures and processes related to configuration management of Middleware application programs.
  • Provided Engineer support for production database systems application and Middleware application programs.
  • Installed updated software patches to Middleware application software.
  • Created Auditing procedure for PCI related Data using DDL/DMLTriggers to keep track all the changes to database and data in tables.
  • Used Oracle Data Modeler to do the physical data modeling Wrote DDL to create tables, indexes and constraints.
  • Designed, created and maintained the Single Stock Fund Middleware Support Website.
  • Performed DDL and DML replication from test and dev instances into EDW.
  • Provided testing and feedback of Middleware Software program for program fixes.
  • Used DMA (Database Middleware Automation) for installing SQL instances.
  • Architected the 'Middle Tier' for handling the business logic

Show More

1 DDL Jobs

No jobs at selected location

48. C #

demand arrow
low Demand
Here's how C # is used in SQL Database Administrator jobs:
  • Developed and deployed electronic forms in ASP.Net C # and stored procedures in SQL Server 2012.

Show More

49. I/O

demand arrow
low Demand
Here's how I/O is used in SQL Database Administrator jobs:
  • Introduced and Implemented Features like Data and Backup compression and transparent data encryption to reduce I/O and to maintain security respectively.
  • Worked with developers to optimize stored procedures and scripts, which significantly reduced execution time and I/O values.
  • Detect and troubleshoot SQL server related CPU / memory, I/O, disc space and other resource contention.
  • Worked closely with Storage groups to find out the underlying Disk I/O sub system issues with SAN.
  • Collected performance data (I/O, Memory, CPU) for capacity planning and trend analysis.
  • Involved in improving the Server performance using Performance monitor using I/O, memory and CPU counters.
  • Analyzed values of performance monitor counters to identify potential disk, I/O subsystem issues.
  • Performed table partitioning to improve I/O access the production server every six months.
  • Performed performance analysis using CPU, I/O and memory counters using performance monitors.
  • Planned for storage spaces requirements and placing them for optimum I/O performance.
  • Monitor, analyze and identify disk I/O, memory and processors bottlenecks.
  • Manage and maintain indexes, Databases I/O information.
  • Table partitioning to improve I/O access.
  • Analyze logical and physical I/O.
  • Monitored all databases status including CPU, memory, I/O, space Management, block, and dead lock.
  • Handled performance tuning on main production farm (specifically disk I/O errors related to incorrect LUNs on SAN).
  • Analyzed the complete environment for resource utilizations and suggested upgrades to increase I/O and avoid bottlenecks.
  • Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
  • Used SQL Sentry to check the blockings, TOP SQL, and memory issues and DISK I/O issues.
  • Resize tempdb and split it into multiple files for I/O optimization.

Show More

50. Business Requirements

demand arrow
low Demand
Here's how Business Requirements is used in SQL Database Administrator jobs:
  • Helped in translating business requirements into technical design specifications and preparing high-level documentation for the Database Design and Database Objects.
  • Involved in analyzed and designed disaster recovery / replication strategies with business managers to meet the business requirements.
  • Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
  • Developed complex Stored Procedures / Functions / Triggers according to business requirements.
  • Created stored procedures/Packages using Pl/SQL programming according to the business requirements.
  • Configured SQL instances in different domains to satisfy business requirements.
  • Implemented Backup and Recovery Strategies base on Business requirements.
  • Translated business requirements into architecture and functional requirements.
  • Deigned technical documents after analysis the Business Requirements.
  • Created database triggers to implement business requirements.
  • Created logical and physical design of new database to fit new business requirements and implemented new design into SQL Server 2005.
  • Worked on Capacity Planning, and optimizing the sizes of Databases, Purging\Cleansing of data based on business requirements.
  • Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
  • Implemented transactions at package level and task level to meet the business requirements.
  • Created stored procedures, views and triggers according to the business requirements.
  • Interacted with the clients to gather business requirements to create requirement documents.
  • Created several MDX queries according to Business requirements.
  • Configured Mirroring and Transactional Log Shipping between Primary and Secondary Servers depending on the business requirements.
  • Conducted business requirements analysis to understand the business problems at hand.
  • Implemented Transactional Replication base on business requirements.

Show More

1 Business Requirements Jobs

No jobs at selected location

SQL Database Administrator Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A SQL Database Administrator

Database

19.9%

SQL

16.0%

Production Servers

7.3%

Windows XP

6.9%

Ssrs

4.5%

T-Sql

4.0%

Recovery Procedures

4.0%

High Availability

3.8%

DTS

3.8%

Ssis

3.6%

Query Analyzer

3.6%

Transactional Replication

3.0%

Maintenance Plans

2.9%

DBA

2.8%

ETL

2.5%

Production Environment

2.4%

Dbcc

2.4%

R2

2.3%

Disk

2.2%

Service Packs

2.0%
Show More

Typical Skill-Sets Required For A SQL Database Administrator

Rank Skill
1 Database 14.9%
2 SQL 12.0%
3 Production Servers 5.5%
4 Windows XP 5.2%
5 Ssrs 3.4%
6 T-Sql 3.0%
7 Recovery Procedures 3.0%
8 High Availability 2.9%
9 DTS 2.8%
10 Ssis 2.7%
11 Query Analyzer 2.7%
12 Transactional Replication 2.2%
13 Maintenance Plans 2.2%
14 DBA 2.1%
15 ETL 1.8%
16 Production Environment 1.8%
17 Dbcc 1.8%
18 R2 1.7%
19 Disk 1.7%
20 Service Packs 1.5%
21 Setup 1.5%
22 Capacity Planning 1.4%
23 Ssas 1.4%
24 DMV 1.3%
25 Performance Issues 1.2%
26 Trouble Shooting 1.2%
27 Hot Fixes 1.1%
28 Server Performance 1.1%
29 BCP 1.0%
30 Wizard 1.0%
31 Data Warehouse 0.9%
32 IIS 0.8%
33 Execution Plans 0.8%
34 Management Studio 0.7%
35 CPU 0.7%
36 SAN 0.7%
37 Oltp 0.7%
38 XML 0.7%
39 Regular Intervals 0.7%
40 Security Policies 0.6%
41 Update Statistics 0.6%
42 Sharepoint 0.6%
43 Olap 0.6%
44 DEV 0.6%
45 Vmware 0.6%
46 Database Integrity Checks 0.5%
47 DDL 0.5%
48 C # 0.5%
49 I/O 0.5%
50 Business Requirements 0.5%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

8,969 SQL Database Administrator Jobs

Where do you want to work?

To get started, tell us where you'd like to work.
Sorry, we can't find that. Please try a different city or state.