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.

Senior SQL Server 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 Senior SQL Server Database Administrator Skills

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

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

1. SQL

demand arrow
high Demand
Here's how SQL is used in Senior SQL Server Database Administrator jobs:
  • Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data extraction, data loads and transformations.
  • Monitored Databases for Dead Lock, Capturing long running SQL queries, used HINTS for fine-tuning SQL statements.
  • Installed and documented SQL Server 2008 configuration and lead tester and reviewer for new SQL Server replication architecture.
  • Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
  • Involved in developing stored procedures, Triggers, and SQL scripts for performing automation tasks.
  • Designed, developed and configured Nobel's reporting solution using SQL Server Reporting Services.
  • Created a new SQL Server backup schedule based on business needs for quick recovery.
  • Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
  • Installed and managed SQL Server 2012/2014 Always ON availability groups for high availability.
  • Design, deploy, and maintain various SSRS Reports in SQL Server.
  • Performed extensive use of SQL Server DMV's for Performance Tuning.
  • Served as SQL Server administrator for some of those products.
  • Created linked servers to run distributed queries between SQL servers.
  • Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
  • Implemented Clustering features in SQL Server with Nodes and Functions.
  • Create a customized report using SQL Server Reporting Services.
  • Created and configured security using SQL Logins, Roles and Security Modes for various users.
  • Created stored procedures and SQL statements for generating Ad-hoc Reports in SSRS.
  • Implemented SQL Server Analysis Services and OLAP Cubes Managed Symantec backups.

Show More

9 SQL Jobs

No jobs at selected location

2. Database

demand arrow
high Demand
Here's how Database is used in Senior SQL Server Database Administrator jobs:
  • Handled database server tuning, application tuning, maintenance documentation, and database security.
  • Performed acceptance testing to verify that database changes perform without adverse consequences.
  • Maintained two different databases: Read-only reporting database and Disaster recovery database.
  • Implemented and maintained Database mirroring as a Disaster Recovery Solution.
  • Completed documentation about the Database.
  • Managed database security, design, develops, and implement automated database back up and restoration procedures of the existing servers.
  • Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
  • Managed index, statistics and optimizing queries by using execution plan for tuning the database.
  • Created Application Roles, assign required permissions to roles, assign to database Users.
  • Involved in identifying deprecated SQL scripts used in the application to query the database.
  • Performed Database Replication, Automated backups and database snapshots on Amazon RDS.
  • Reorganized databases and sized database objects to meet standards and improve performance.
  • Managed the migration of SQL Server 2000 databases to SQL Server 2005.
  • Performed backups, restores, and database shrink operations.
  • Developed direct connection between Access and SQL databases.
  • Performed Database recovery model - Full/ Bulk-Logged and Transactional log maintenance.
  • Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
  • Loaded data into SQL database and convert it to applicable dataset to make it ready for report generation.
  • Managed logins, server level roles, database roles, partially-contained databases and users.
  • Drop and add users, logins, aliases, and groups to the databases and granting/revoking Permissions on Database objects.

Show More

6 Database Jobs

No jobs at selected location

3. Recovery Procedures

demand arrow
high Demand
Here's how Recovery Procedures is used in Senior SQL Server Database Administrator jobs:
  • Provided disaster recovery procedures and policies for backup and recovery of Databases.
  • Involved in disaster recovery procedures and restore the production databases.
  • Perform everyday backups and develop recovery procedures.
  • Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures with log shipping.

Show More

4. Backup

demand arrow
high Demand
Here's how Backup is used in Senior SQL Server Database Administrator jobs:
  • Developed and implemented backup and recovery strategies involving complete database backup/restore, transaction log backup/restore.
  • Designed and implemented comprehensive backup plan and disaster recovery strategies.
  • Performed audit of backup strategy and implemented corrections.
  • Solved backup, copy, restore job failure, space, network, latency issues related to Log Shipping.
  • Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
  • Designed enterprise wide database backup, recovery and restore plan using stored procedures and SQL Server Agent.
  • Maintained different backup polices (Full backup, differential backup and transaction log).
  • Configured new backup policy after migration in to MS-SQL 2005 with Light Speed Software.
  • Worked on database Installation, configuration, maintenance, monitoring, backups and recoveries.
  • Verify, maintain & troubleshoot database backups, integrity checks and scheduled jobs.
  • Experienced in creating backup strategy for production, test and development servers.
  • Created, performed, maintained and tested all backups.
  • Plan and Schedule the Backups.
  • Analyzed and defined capacity planning for maintenance of the different Database Backups and Restore scenarios.
  • Develop, manage and test backup and recovery plans Manage security of databases in production and test environments.
  • Involved in development teams including project planning, estimating, programming and testing Managing the San backups.
  • Back up (Avamar) all system-related files to ensure full backup and recovery capabilities.
  • Used Idera SQL safe backup, which provides a high-performance backup and recovery solution.
  • Developed and administered the backup/recovery strategy for the Sandia Health Service Center's Medical Information Systems.
  • Implemented scheduled script to provide shutdown of sql writer to stop blocking backup activity.

Show More

5. Ssis

demand arrow
high Demand
Here's how Ssis is used in Senior SQL Server Database Administrator jobs:
  • Assisted other GMNA customers in developing Web based front end to the tool and improving the interim Access front end.
  • Created SSIS packages to import and export data from various flat files, Delimited, Ragged Right, Fixed width.
  • Used SSIS, Import/Export to Copy, move data from one server to another, Excel to SQL Server.
  • Created, modified, and maintained SQL Server SSIS packages, SSRS reports and CLR stored procedures.
  • Exported or Imported data from other data sources like flat files using Import/Export through DTS, SSIS.
  • Migrated data from different sources to SQL Server database using Integration Services (SSIS).
  • Worked on SSIS Package, DTS Import/Export for transferring data from database to other.
  • Created SQL server configurations for SSIS packages and XML & Windows event logs.
  • Created SSIS packages for COTS applications to be integrated into SQL Server 2008.
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Transferred data (ETL) to Data ware house Environment using SSIS.
  • Modified existing SSIS packages to meet the changes specified by the users.
  • Created jobs, alerts to run SSIS, SSRS packages periodically.
  • Develop, maintain, and administer ETL using SQL Server SSIS.
  • Involved in ETL Process and developed medium to complex SSIS packages.
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Supported developer to write and debug SSIS packages.
  • Developed, monitored and deployed SSIS packages.
  • Used Erwin to design a complex database environment Created SQL server configurations for SSIS packages and XML & Windows event logs.
  • Used various Transformations in SSIS Dataflow, Control Flow using for each loop Containers and Fuzzy Lookups etc.

Show More

Job type you want
Full Time
Part Time
Internship
Temporary

6. Windows XP

demand arrow
high Demand

7. Ssrs

demand arrow
high Demand
Here's how Ssrs is used in Senior SQL Server Database Administrator jobs:
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
  • Involved in Application coding at by using C#.net with in the MVC Architecture to pull the SSRS reports.
  • Involved in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2000/2005/2008 across various environments.
  • Used in designing, developing and deploying reports in MS SQL Server environment using SSRS, SSIS in BIDS.
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Developed a High level reports using SSRS like Drill Down, Drill through, Cross tab reports.
  • Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
  • Developed Custom Selection of reports ordering using SQL Server Reporting Services (SSRS).
  • Worked on SSRS to design reports and deploy them to the Report Manage.
  • Involved in creating various reports using SSRS that helped users made informed decision.
  • Worked on creating reports using SQL server Reporting Services (SSRS).
  • Created SQL Server Reports based on the requirements using SSRS 2012.
  • Designed and created more than 40 variety of reports using SSRS.
  • Worked in SSRS administration and report creation.
  • Involved in Migration of SSRS 2005 to SSRS 2008.
  • Developed Tabular reports, Crystal reports, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS.
  • Developed reporting module using .NET application with set of RDL based reports using SSRS and Complex Stored Procedures.
  • Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2008.
  • Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008.
  • Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.

Show More

8. T-Sql

demand arrow
high Demand
Here's how T-Sql is used in Senior SQL Server Database Administrator jobs:
  • Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors.
  • Developed & maintained using Power Shell/T-SQL scripts, utility jobs or implement needed software for database maintenance.
  • Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
  • Converted active script task logic in script task and T-SQL and produced the desired result.
  • Generated T-SQL code for creating cursor and handling the data validations.
  • Developed complex T-SQL code for the application.
  • Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
  • Designed and implemented Operational automation tasks using SQL Server Job using Power Shell/T-SQL scripting.
  • Created Tons of Ad-hoc reports using T-sql and sql/Plsql.

Show More

9. DTS

demand arrow
high Demand
Here's how DTS is used in Senior SQL Server Database Administrator jobs:
  • Migrated production databases from SQL Server 2000 to SQL Server 2005, upgraded DTS packages to SSIS packages.
  • Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
  • Created views, SQL joins DTS packages and statements for applications.
  • Involved in DTS Package, DTS Import/Export for transferring data.
  • Created DTS package to schedule the jobs for batch processing.
  • Upgraded SQL Server DTS Packages to Integration Services Packages.
  • Created DTS packages for importing and exporting data.
  • Migrated DTS packages to SSIS packages.
  • Migrated DTS packages from SQL Server 2008R2 to SQL Server 2012 as SSIS Packages.
  • Scheduled SSIS jobs (SQL Agent), Migrating DTS packages to SSIS packages.
  • Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS..

Show More

10. Data Warehouse

demand arrow
high Demand
Here's how Data Warehouse is used in Senior SQL Server Database Administrator jobs:
  • Designed and developed ETL processes using SSIS to receive customer files from data warehouses and load them into transaction processing systems.
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Provided expertise in Data warehouse and Data Marts methodologies as well as extensive knowledge of OLTP/OLAP technologies.
  • Administer data warehouse including processing SSAS cubes and running jobs to populate dimensional and fact tables.
  • Experienced in Design of OLAP Data warehouse using Star Schema and Snow Flakes Schema.
  • Moved all Oracle databases to new IBM P-series servers including all data warehouses.
  • Involved in Production OLTP / OLAP data warehouse Schema design.

Show More

11. Production Environment

demand arrow
high Demand
Here's how Production Environment is used in Senior SQL Server Database Administrator jobs:
  • Experienced on both production environment and non-production environment support.
  • Implemented Event Handlers, Error Handling, Logging and package configuration for deployment to test and production environment.
  • Solved issues related to synchronization of data in development, Test, Smoke, Production Environments.
  • Deployed changes to Production environment and worked with various team on change requests.
  • Experienced on both production environment and non-production environment support Performed Performance Tuning of the database, Stored Procedures and SQL queries.
  • Created and managed TIBCO Spotfire environment for development, testing and Production environment with Spotfire Server, Web-Player and Professional tools.

Show More

1 Production Environment Jobs

No jobs at selected location

12. ETL

demand arrow
high Demand
Here's how ETL is used in Senior SQL Server Database Administrator jobs:
  • Generated SSIS packages based on metadata using BIML for applying code reuse, templates and patterns in ETL solutions.
  • Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
  • Created ETL SSIS packages both design and code to process data to target databases.
  • Created mapping tables to find out the missing attributes for the ETL process.
  • Used ETL to extract files for the external vendors and coordinated that effort.
  • Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
  • Created common reusable objects for the ETL team and overlook coding standards.
  • Created ETL process using SSIS to transfer data from heterogeneous data sources.
  • Performed ETL Auditing to maintain Loads report.
  • Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
  • Prepared ETL standards, naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
  • Developed ETL strategies for back-end processes to serve data to .NET-based capital account management application.
  • Used ETL packages to move logins and jobs from one server to another server.

Show More

13. Schema

demand arrow
high Demand
Here's how Schema is used in Senior SQL Server Database Administrator jobs:
  • Developed physical data models and created DDL scripts to create database schema and database objects.
  • Created Schema Objects and Application Objects using MicroStrategy Desktop and Architect.
  • Involved designing data model using star schema.
  • Developed Cube with Star Schema.
  • Evaluated schema and cube structure eliminated unnecessary data and refactor as necessary to optimize for current reporting needs.
  • Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
  • Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.

Show More

14. Ssas

demand arrow
high Demand
Here's how Ssas is used in Senior SQL Server Database Administrator jobs:
  • Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS)-2008/2005.
  • Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/Analysis Services (SSAS).
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Created PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.
  • Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008R2 (SSAS).
  • Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
  • Participated in requirement gathering, cube design, application design, SSAS development, training operational users.
  • Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
  • Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
  • Upgraded Analysis Service 2005 to SSAS 2008r2.
  • Manage memory and performance for SQL Server, SSRS, SSIS, SSAS.
  • Identified and Defined Key Performance Indicators (KPIs) in SSAS 2008r2.

Show More

15. Query Analyzer

demand arrow
average Demand
Here's how Query Analyzer is used in Senior SQL Server Database Administrator jobs:
  • Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.
  • Involved in performance tuning to optimize SQL queries using query analyzer.
  • Used Query Analyzer to optimize SQL Queries.

Show More

16. Business Requirements

demand arrow
average Demand
Here's how Business Requirements is used in Senior SQL Server Database Administrator jobs:
  • Deigned technical documents after analysis the Business Requirements.
  • Defined constraints, rules and indexes (clustered and non-clustered) based on business requirements.
  • Gather Business Requirements from Retail and CC&B stakeholders for new BSS processes.

Show More

17. DBA

demand arrow
average Demand
Here's how DBA is used in Senior SQL Server Database Administrator jobs:
  • Provided technical consultation with Operational DBA's regarding database infrastructure support, sizing, troubleshooting and production database issues.
  • Provided 24/7 on call support with other SQL Server DBA's and production support team members.
  • Automated most of the DBA Tasks and monitoring stats.
  • Supervised and mentored 2 junior DBA/SQL developers.

Show More

18. Dbcc

demand arrow
average Demand
Here's how Dbcc is used in Senior SQL Server Database Administrator jobs:
  • Used System tables, System Stored Procedure, DBCC commands for Database maintenance.
  • Used database consistency checks using DBCC utilities.
  • Experience using various DBCC commands like checkdb/checktable, showcontig, showstatistics etc.

Show More

19. Olap

demand arrow
average Demand
Here's how Olap is used in Senior SQL Server Database Administrator jobs:
  • Used OLAP in storing the historical data to evaluate the trends.
  • Design and development of OLAP database for Voice Portal.
  • Design OLAP database warehouse on SQL Server Analysis Service.

Show More

20. R2

demand arrow
average Demand
Here's how R2 is used in Senior SQL Server Database Administrator jobs:
  • Upgraded to SQL Server 2008 R2and guiding the development and application team to fully utilize SQL Server 2008 R2 enhancements.
  • Advised client on future capacity planning and possible upgrade of SQL Server 2005 to SQL Server 2008r2 database.
  • Migrated SQL server 2000 to SQL Server 2005 in Microsoft Windows Server 2003 R2 Enterprise Edition SP2.
  • Migrated SQL server 2008 R2 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
  • Prepared a database report to the top managers using SQL server 20008r2 reporting service.
  • Worked with team in upgrading the database from MS SQL Server 2008 to 2008R2.
  • Involved with team for the installation and configuration of SQL server 2008R2.
  • Upgraded several SQL Server 2008 R2 databases to SQL Server 2012.
  • Design corporate level audit solution with SQL Server 2008 R2 Audit.
  • Installed, configured and maintained SQL Server 2008, 2008R2, 2012, 2014 and 2016 versions.
  • Managed SQL Server 2003, 2008, 2008 R2, 2012, 2014 database versions.
  • Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
  • Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2005/2008 R2 Reports Services (SSRS).
  • Identified and worked with Parameters for parameterized reports in SSRS 2008r2.
  • Provide customer high availability solutions by designing, building and supporting SQL Server 2012/2008R2/2008/2005/2000 multi-node multi-instance clusters.

Show More

21. DB

demand arrow
average Demand
Here's how DB is used in Senior SQL Server Database Administrator jobs:
  • Define DBMS specific requirements to accommodate physical data models.
  • Provided Primary support DBA to various business critical SQL Server applications hosted over 300 servers (SQL 2008 R2/2008/2005).
  • Promoted automation of DBA tasks for increased productivity reducing daily workload by 50% to increase team's support capacity.
  • Scripted the Database Consistency Checks (DBCC), scheduled the scripts to run daily and weekly basis.
  • Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
  • Migrated data from IBM-DB2 to SQL Server 2008/2012 with SQL Server Integrated Services (SSIS).
  • Transformed data from various data sources using OLE DB connection by creating various DTS packages.
  • Worked with the DBA and Database developers to convert the functional specification to technical specification.
  • Developed service level agreements and metrics required to govern the outsourced DBA services.
  • Performed Log shipping to a standby server to safeguard valuable data.
  • Provided strategic vision and tactical direction for the DBA function.
  • Maintained the database consistency with DBCC at regular intervals.
  • Designed DBA workload reporting for ease of administration.
  • Worked on different sources in SSIS (XML, Flat file, Excel, OLEDB Source).
  • Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs.
  • Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs.
  • Check the database for any torn page errors by running DBCC checkdb command Installation and configuration of SQL Server 2005/2008/2008R2 components.
  • Manage multiple instances of SQL Server, Oracle and Sybase DB technologies.
  • Led a team of 4 employee DBAs and 9 contractor DBAs - on-shore / off-shore.
  • Led DBA team to transfer a PeopleSoft financials application from off-site vendor datacenter to our on-site datacenter.

Show More

22. XML

demand arrow
average Demand
Here's how XML is used in Senior SQL Server Database Administrator jobs:
  • Involved with programming languages C#, XML.

Show More

23. C # .NET

demand arrow
average Demand

24. Sub Reports

demand arrow
average Demand
Here's how Sub Reports is used in Senior SQL Server Database Administrator jobs:
  • Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
  • Created sub reports, bar charts and matrix reports.
  • Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.

Show More

25. Disk

demand arrow
average Demand
Here's how Disk is used in Senior SQL Server Database Administrator jobs:
  • Perform capacity planning and disk configurations for new hardware infrastructure.
  • Performed RAID calculations to identify system disk bottlenecks and recommended adding physical disks to provide for future growth.
  • Configured Different RAID Levels (Redundant Array of Independent Disks).
  • Moved Tempdb to separate disk allowing the faster creation of indexing on some of the larger tables.

Show More

26. Oltp

demand arrow
average Demand
Here's how Oltp is used in Senior SQL Server Database Administrator jobs:
  • Constructed OLTP and OLAP Databases.

Show More

27. High Availability

demand arrow
average Demand
Here's how High Availability is used in Senior SQL Server Database Administrator jobs:
  • Implemented database replication and mirroring as of High availability options to cloud database.
  • Detect and correct issues with high availability and disaster recovery technologies.
  • Created new replications and addressed the Replication Issues to maintain high availability of the data between the servers.
  • Implemented the DR (Disaster Recovery Mechanisms), High availability and Always ON features for SQL Servers.
  • Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
  • Configured High Availability Techniques like database Mirroring and different Replication models like Merge, Snapshot and Transactional on test environment.

Show More

2 High Availability Jobs

No jobs at selected location

28. CPU

demand arrow
average Demand
Here's how CPU is used in Senior SQL Server Database Administrator jobs:
  • Resolved issues for mission critical high usage of system CPU, Disk, Deadlocks and Transaction per/sec, Memory.
  • Monitored database status including CPU, memory, I/O, space, and deadlocks using SQL Server utilities.
  • Analyzed the long running and high cpu utilized queries on the server by using profiler and performance monitoring.

Show More

29. Management Studio

demand arrow
average Demand
Here's how Management Studio is used in Senior SQL Server Database Administrator jobs:
  • Implemented the calculations to aggregate physical measures using management studio.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
  • Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent and Database Tuning Advisor.

Show More

30. Regular Intervals

demand arrow
low Demand
Here's how Regular Intervals is used in Senior SQL Server Database Administrator jobs:
  • Created, Removed and rebuilt the indexes at regular intervals for better performance of Queries and Packages.

Show More

31. Setup

demand arrow
low Demand
Here's how Setup is used in Senior SQL Server Database Administrator jobs:
  • Install SQL Server Management tools using SQL Server Setup Program.

Show More

32. Performance Issues

demand arrow
low Demand
Here's how Performance Issues is used in Senior SQL Server Database Administrator jobs:
  • Generated reports (SSRS) to identify performance issues on remote servers using SSIS to extract data.
  • Resolved database performance issues, database capacity issues, replication, and other distributed data issues.
  • Evaluated the Database Performance of Index tuning with using DTA to resolve Performance issues.
  • Resolved some performance issues on critical servers.
  • Resolved the performance issues with very large SharePoint application databases Supported the existing databases.
  • Experienced in monitoring and troubleshooting performance issues and optimized TSQL queries, stored procedures, functions etc.

Show More

33. Asp.Net

demand arrow
low Demand

34. Trouble Shooting

demand arrow
low Demand
Here's how Trouble Shooting is used in Senior SQL Server Database Administrator jobs:
  • Experience in trouble shooting Client connections, viewing error logs and application logs.
  • 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.

Show More

35. System Performance

demand arrow
low Demand
Here's how System Performance is used in Senior SQL Server Database Administrator jobs:
  • Monitor system performance, including providing management with historical performance statistics.
  • Involved in planning & administration of the entire migration and system performance.

Show More

36. Complex Queries

demand arrow
low Demand
Here's how Complex Queries is used in Senior SQL Server Database Administrator jobs:
  • Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Optimized system performance, wrote stored procedures and complex queries to be used by GMNA customers.
  • Used SQL Server analysis services to simplify complex queries and enhance speed of execution.
  • Analyzed complex queries and tuned the same to optimize application and system performance.
  • Embedded complex queries and procedures in DTS Packages based on business requirements.

Show More

37. Update Statistics

demand arrow
low Demand
Here's how Update Statistics is used in Senior SQL Server Database Administrator jobs:
  • Index Data Management to determine Defragmentation level; whether to Update Statistics or Rebuild Indexes.

Show More

38. Text

demand arrow
low Demand
Here's how Text is used in Senior SQL Server Database Administrator jobs:
  • Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
  • Involved in creating SSIS packages for importing data from text file to database tables.
  • Created SSIS Packages to migrate the data from database to Text files.

Show More

39. Production Servers

demand arrow
low Demand
Here's how Production Servers is used in Senior SQL Server Database Administrator jobs:
  • Configure Mirroring as an effective solution for a hot standby server for production servers.
  • Worked on critical issues on production servers with the help of Microsoft tech support.
  • Implemented the database Mirroring concept on production servers.

Show More

40. Export

demand arrow
low Demand
Here's how Export is used in Senior SQL Server Database Administrator jobs:
  • Created SQL Jobs to export data from various databases to tables and flat files.
  • Performed and validated manual data imports and exports as required.

Show More

41. Column

demand arrow
low Demand
Here's how Column is used in Senior SQL Server Database Administrator jobs:
  • Designed the complex views that we can use from the source to populate the warehouse with required columns.
  • Involved in gathering the requirements to integrate new data sources to design column mapping document.
  • Install and configure SQL Server 2012 new features such as High Availability / AlwaysOn , Contained databases, or ColumnStore indexes.
  • Modified existing SSIS packages for new requirements and modified existing SSRS reports to add new columns.

Show More

42. Server Performance

demand arrow
low Demand
Here's how Server Performance is used in Senior SQL Server Database Administrator jobs:
  • Involved in improving the server performance using Performance monitor using I/O, memory and CPU counters.
  • Experienced in involving SQL Server performance using index tuning wizards, SQL Profiler and SQL Query Analyzer.
  • Monitored SQL server performance using profiler to find performance and dead locks.

Show More

43. MDX

demand arrow
low Demand
Here's how MDX is used in Senior SQL Server Database Administrator jobs:
  • Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
  • Created various MDX queries as per the business requirements.
  • Involved in writing MDX queries for various calculated members.
  • Created SSRS Reports on the top of the cube using some MDX queries.

Show More

44. Sharepoint

demand arrow
low Demand
Here's how Sharepoint is used in Senior SQL Server Database Administrator jobs:
  • Monitored daily activities of SharePoint and Remedy SQL Server 2008 databases.

Show More

45. Html

demand arrow
low Demand
Here's how Html is used in Senior SQL Server Database Administrator jobs:
  • Used Power BI Cloud version of Power View which has an HTML5 option as preview for some of the chart types.

Show More

46. Lookup

demand arrow
low Demand
Here's how Lookup is used in Senior SQL Server Database Administrator jobs:
  • Created covering indexes to reduce Bookmark Lookups.

Show More

47. Ad-Hoc

demand arrow
low Demand
Here's how Ad-Hoc is used in Senior SQL Server Database Administrator jobs:
  • Designed Reports in SSRS, with several prompts and built ad-hoc reports in Report Manager.
  • Create and execute various ad-hoc database queries, as needed.
  • Participated in dimensional modeling and designed project workflow frameworks on service and accounting module for Ad-hoc reporting requirements.

Show More

48. Execution Plans

demand arrow
low Demand
Here's how Execution Plans is used in Senior SQL Server Database Administrator jobs:
  • Monitored and modified Performance using execution plans and Index tuning.
  • Checked performance and tuning, indexing, query optimization and query execution plans.
  • Complete analysis of database performance with execution plans, DMVFs, traces and perfmons.

Show More

49. Data Analysis

demand arrow
low Demand
Here's how Data Analysis is used in Senior SQL Server Database Administrator jobs:
  • Used Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.
  • Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
  • Performed Data Analysis and Data validation by writing complex SQL queries using SQL against the SQL server database.
  • Perform data analysis, database design and creation, and data modeling and optimization.
  • Worked with Oracle transportable table spaces for real-time data analysis.

Show More

50. IIS

demand arrow
low Demand
Here's how IIS is used in Senior SQL Server Database Administrator jobs:
  • Configured IIS Server for QA and Production environment and load the intranet web base application with Windows server 2003..
  • Identified and resolved complex issues for applications, SQL and IIS configurations.
  • Supported ColdFusion 8 and IIS applications; helping developers resolve problems.

Show More

Senior SQL Server Database Administrator Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A Senior SQL Server Database Administrator

SQL

19.2%

Database

12.9%

Recovery Procedures

9.9%

Backup

8.1%

Ssis

5.4%

Windows XP

5.3%

Ssrs

4.8%

T-Sql

4.1%

DTS

4.0%

Data Warehouse

3.9%

Production Environment

3.1%

ETL

3.0%

Schema

2.5%

Ssas

2.4%

Query Analyzer

2.2%

Business Requirements

2.2%

DBA

1.9%

Dbcc

1.7%

Olap

1.7%

R2

1.7%
Show More

Typical Skill-Sets Required For A Senior SQL Server Database Administrator

Rank Skill
1 SQL 14.5%
2 Database 9.8%
3 Recovery Procedures 7.5%
4 Backup 6.1%
5 Ssis 4.1%
6 Windows XP 4.0%
7 Ssrs 3.6%
8 T-Sql 3.1%
9 DTS 3.0%
10 Data Warehouse 3.0%
11 Production Environment 2.4%
12 ETL 2.2%
13 Schema 1.9%
14 Ssas 1.8%
15 Query Analyzer 1.7%
16 Business Requirements 1.7%
17 DBA 1.4%
18 Dbcc 1.3%
19 Olap 1.3%
20 R2 1.3%
21 DB 1.2%
22 XML 1.1%
23 C # .NET 1.1%
24 Sub Reports 1.1%
25 Disk 1.0%
26 Oltp 1.0%
27 High Availability 1.0%
28 CPU 0.9%
29 Management Studio 0.9%
30 Regular Intervals 0.9%
31 Setup 0.9%
32 Performance Issues 0.9%
33 Asp.Net 0.8%
34 Trouble Shooting 0.8%
35 System Performance 0.8%
36 Complex Queries 0.8%
37 Update Statistics 0.8%
38 Text 0.7%
39 Production Servers 0.7%
40 Export 0.7%
41 Column 0.7%
42 Server Performance 0.7%
43 MDX 0.6%
44 Sharepoint 0.6%
45 Html 0.6%
46 Lookup 0.6%
47 Ad-Hoc 0.6%
48 Execution Plans 0.6%
49 Data Analysis 0.6%
50 IIS 0.6%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

6,607 Senior SQL Server 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.