SQL Server Database Administrator Resume Samples
4.7
(136 votes) for
SQL Server Database Administrator Resume Samples
The Guide To Resume Tailoring
Guide the recruiter to the conclusion that you are the best candidate for the sql server database administrator job. It’s actually very simple. Tailor your resume by picking relevant responsibilities from the examples below and then add your accomplishments. This way, you can position yourself in the best way to get hired.
Craft your perfect resume by picking job responsibilities written by professional recruiters
Pick from the thousands of curated job responsibilities used by the leading companies
Tailor your resume & cover letter with wording that best fits for each job you apply
Resume Builder
Create a Resume in Minutes with Professional Resume Templates
CHOOSE THE BEST TEMPLATE
- Choose from 15 Leading Templates. No need to think about design details.
USE PRE-WRITTEN BULLET POINTS
- Select from thousands of pre-written bullet points.
SAVE YOUR DOCUMENTS IN PDF FILES
- Instantly download in PDF format or share a custom link.
KH
K Heaney
Kacie
Heaney
6101 Dale Extension
Los Angeles
CA
+1 (555) 909 7086
6101 Dale Extension
Los Angeles
CA
Phone
p
+1 (555) 909 7086
Experience
Experience
Detroit, MI
SQL Server Database Administrator
Detroit, MI
Robel Inc
Detroit, MI
SQL Server Database Administrator
- Recommend to IT management changes to database design to improve process throughput and ensure performance as identified above
- Work with vendors to provide and monitor provided services
- Reviews database design and integration of systems, provides backup recovery and makes recommendations regarding enhancements and/or improvements
- Evaluate and implement products to enhance existing database solutions (reduce costs, improve efficiency, improve performance)
- Interfaces with user departments remotely and on-site to assist in the implementation of work requests and provide operational support
- Design, develop, maintain and execute SSIS packages for database automation and cross network connectivity
- Provide technical guidance to McKesson developers on areas and opportunities to improve SQL code
New York, NY
Ms SQL Server Database Administrator
New York, NY
McGlynn-Wolf
New York, NY
Ms SQL Server Database Administrator
- Manage infrastructure performance and capacity and data security and make recommendations for improvements
- Assist in the monitoring and review of the performance and quality of service provided by the infrastructure
- Help create, enforce and manage the policies and procedures
- Implement infrastructure systems, either leading as project manager, or assisting as part of a team
- Participate in development and implementation of disaster recovery plans
- Excel in a fast paced, rapid development environment
- Implementing performance tuning on the databases
present
New York, NY
Senior SQL Server Database Administrator
New York, NY
Anderson, Wuckert and Collins
present
New York, NY
Senior SQL Server Database Administrator
present
- Provide development and design assistance to development and other application support teams
- Perform all database management responsibilities in Microsoft Azure for production and non-production workloads
- Provide database administration, performance tuning support for Markets Business
- Acts as an expert technical resource to client and development staff in all phases of the development and implementation process
- Perform database hygiene and maintenance to ensure optimum performance
- 2 or more years supporting a production environment, working as part of an on-call rotation, and supporting off hour releases
- Performance monitoring & tuning
Education
Education
Bachelor’s Degree in Computer Science
Bachelor’s Degree in Computer Science
West Virginia University
Bachelor’s Degree in Computer Science
Skills
Skills
- Ensure the databases are highly secure, available, and recoverable
- Solid knowledge of index management, integrity checks, configuration, patching, statistics
- Strong analytical, planning, and organizational skills with ability to manage competing demands
- Strong knowledge of Windows platform
- Strong knowledge of SQL Azure
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
- Strong knowledge writing TSQL, stored procedures, functions and triggers, data transformations using BIDS
- Creative approach to problem-solving with the ability to focus on details while maintaining the “big picture” view
- Strong knowledge normalized and dimensional database experience
- Strong knowledge in entity-relationship models and DWH design techniques
15 SQL Server Database Administrator resume templates
Read our complete resume writing guides
1
SQL Server Database Administrator Resume Examples & Samples
- Managing and supporting database systems,
- Managing incidents and executing changes to support Production, DR, Test and Development applications
- Contributing to service improvement
- At least 3 years experience with SQL server 2005, 2008r2, 2012, Windows, Clustering, SAN, T-SQL, database security, disaster recovery scenarios
- Excellent English skills (both written and spoken)
- Database maintenance, patching and DR
- Experience in project build, test and implementation of Database components
- Experience of working in a production and development database support environment
2
SQL Server Database Administrator Resume Examples & Samples
- 6+ years of practical experience using MS SQL Server in a production environment
- College diploma or university degree in the field of computer science
- Experience in designing, implementing and maintaining SQL 2008 and 2012
- Experience participating in all phases of the software development life cycle (analysis, design, implementation, testing, debugging, documentation, release, and maintenance)
- Strong skills designing, developing and maintaining stored procedures, views, tables, T-SQL scripts, etc. as well as creating associated documentation
- Demonstrated skill in relational table design and applying optimized indexes
- Experience with solving performance problems with execution plans, Database Tuning Advisor and SQL Profiler
- Experience in creating / maintaining multiple test environments with obfuscated data
- Good written and verbal communication and interpersonal skills
- MCDBA certification
- Exposure to DB2, IBM System I, Power7, WebSphere, and/or FileNet systems
- Experience with tools like IDERA and SSDT
- Strong skill in designing, developing and maintaining SSIS packages
3
SQL Server Database Administrator Resume Examples & Samples
- BS/BA Degree is required
- 8+ years experience working with and supporting enterprise database applications, specifically all recent versions of MS SQL Server (2008R2 – Required: 2012 Preferred)
- Knowledge of supporting databases in a large decentralized financial services organization
- Experience with SSIS and ETL packages
- Experience with performance tuning, optimizing, and scaling all server instances and databases
- Experiencel with SQL Security
- Experience with SQL Server backup/restores and maintenance plans
- Demonstrable experience with Transactional Replication desired
- Must have outstanding customer service skills
4
SQL Server Database Administrator Resume Examples & Samples
- Fluent English language
- Database administration knowledge in at least one of the following Microsoft SQL Server versions: 2000, 2005, 2008, 2012
- Basic T-SQL skills
- Hands-on experience with any of the following will be considered an advantage
5
Senior SQL Server Database Administrator Resume Examples & Samples
- Provide database administration, performance tuning support for Markets Business
- The day-to-day responsibilities are to install, maintain and tune MS SQL Databases
- Production support experience for critical database systems. -
- Monitor and optimize system performance; implement, configure, and troubleshoot database instances; and replication, partitions, storage, and security for SQL versions 2005 and 2008
- Support backup and recovery procedures for all MS SQL Server database systems according to industry best practices
- Supporting a Financial business experience a plus
6
SQL Server Database Administrator Resume Examples & Samples
- Provide SQL DBA expertise/advice on key projects
- Respond to escalated 3rd level support calls
- Assist in the planning and implementation of changes/releases/upgrades to the SQL databases/app environment
- Provide after hours support for the SQL database/app infrastructure when required
- Monitor SQL server and database performance and proactively address potential performance issues
- Work with the development team to resolve bug-fixes and assist in relevant testing through various environments
- Ability to act independently at times
- Flexible to multiple demands with the ability to shift priorities
- Senior SQL Server DBA and 3rd Level Support, Minimum 5 years
- SQL Server 2005 and/or 2008 is must
- Experience in support of business intelligence solutions/applications or experience in managing large SQL data warehouse database will be highly regarded
- Strong understanding of server technology & SAN storage is must
- Experience in management of communication at high levels in the organisation is must
- No supervisory responsibilities
- Due to our global organization and global operating model there may be cross border reporting lines (no direct team lead within the country)
- Your manager may be based in another country
- At least 5 years of experience as a Senior SQL Server DBA with 3rd level support
7
Senior SQL Server Database Administrator Resume Examples & Samples
- Tune the database stack to meet SLAs/OLA's. DBA must also have a good understanding and exposure to Storage, Unix and Network technologies deployed in database platforms and collaborate with other infrastructure teams
- Participate in Cost efficiency & Service improvement initiatives, Incident Management and RCA
- Perform capacity planning and forecast of storage, database growth and server utilization
- Work closely with Business Stream leads and Risk Remediation leads to meet business objectives and resolve security and other operational risk in the environment
- Regularly review the database estate and provide architecture recommendations to improve scalability and system stability
- Key role in certification and testing Database toolsets and new technology
- Regular weekend work is required (on-call, site isolation, power down etc.)
- 4 year Bachelor's degree (or international equivalent) in Computer Science, MIS, CIS ore related technical field
8
R&D Dba-SQL Server Database Administrator Consultant Resume Examples & Samples
- 7+ years working with SQL Server technology
- Demonstrated experience managing large scale database deployments in term of database size and number of servers
- Demonstrated experience managing high transactional databases servicing OLTP and DSS applications
- Solid understanding of SQL Server internal architecture
- Performance tuning of SQL Server database, stored procedures and SQL is a must
- Hands on experience with designing and implementing database replication strategies, including database mirroring/always on, peer to peer and transactional replication
- Hands on experience with Window Clustering and SQL Server Clustering implementation including Always On
- Demonstrated experience with project management and customer interaction
- Solid understanding of backup and recovery strategies
- Experience in designing repetitive processes
- MCITP Database Administrator certification for SQL Server 2008-2014 is a must
- Experience with data warehousing database system
- Knowledge of any database programming language(C#) and scripting (Powershell/Python)
- Financial industry experience
9
Senior SQL Server Database Administrator Resume Examples & Samples
- Apply VTM and one-off infrastructure patches
- Ensure databases are setup and maintained to standards
- Coordinate, plan and/or deploy major projects
- Provide level 3 support for Client applications
- Subject matter expertise in database architecture, design, maintenance, Citi change management processes and implementation
- Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, etc
- Certification in database administration and a minimum of 7 years database administration work experience
- Bachelor’s degree or relevant work experience required
10
SQL Server Database Administrator Resume Examples & Samples
- Analyzes long-term database performance trends to optimize database and application performance
- Minimum four years Microsoft SQL Server 2008/2012/2014 DBA experience
- Experience supporting multiple production and development servers
- Good Transact SQL skills – ability to write and tune complicated stored procedures and views utilizing inner and outer joins, etc
- Experience with large databases (> 250 GB)
- Experience supporting SQL Server 2005/2008/2012/2014 replication
- 3- 5 years client server experience with emphasis on SQL programming
- Experience recovering databases after hardware or other catastrophic failures
- Good customer service, interpersonal and communication skills
- General knowledge of Windows 2008/2012 and hardware including RAID configurations; EMC SAN experience
- Experience with Oracle 11g (or higher) RAC
- Experience with Analysis Services cubes and dimensions
- Experience with Windows Power Shell
11
Senior SQL Server Database Administrator Resume Examples & Samples
- 5+ years of DBA Experience (Systems)
- Proficiency with Microsoft SQL Server, versions 2008 R2 through 2014
- Strong understanding of SQL Server relational databases, data structures, and SQL
- Proficient with Backup and Recovery
- Experience with SQL Sentry monitoring tools
- Experience with production and development environments
- Scripting Experience (PoSH, T-SQL)
- Ability to work with colleagues from all over the globe
12
SQL Server Database Administrator Resume Examples & Samples
- 2+ years of DBA Experience (Systems DBA)
- Understanding of SQL Server relational databases, data structures, and SQL
- Experience with log shipping and availability groups
- Experience with EMC Data Domain strongly desired
13
Senior SQL Server Database Administrator Resume Examples & Samples
- Operate SQL databases ensuring that systems are running optimally ensuring availability, efficiency and recoverability
- Designing, planning and implementation of new SQL Server estate
- Design and implement monitoring solutions for SQL databases
- Ability to establish alliances with other teams through recognition of dependencies
- Acts as an expert technical resource to client and development staff in all phases of the development and implementation process
- Expertise in managing SQL Server 2005, 2008, 2012, 2014
- Experience in Performance Tuning, Query Optimization, using SQL Server monitoring utilities such as Idera SQLdm, BMC Patrol, NewRelic, Spotlight, SQLSentry
- Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering
- Experience with AlwaysON Availability groups, clustering, replication, log shipping, mirroring and storage replication technologies
- Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
- Working knowledge of Business Intelligence (BI) platforms including SSIS, SSAS and SSRS
- Any skills in open source and/or No SQL databases
- Experience with Cloud database hosting providers AWS EC2, Azure VM and Azure SQL Database
- Possess a keen interest within SQL technologies by understanding new current/forthcoming versions (e.g. SQL 2016, etc.)
- SQL Server certified professional – Added advantage
14
Treasury Management SQL Server Database Administrator Resume Examples & Samples
- At least 3 years experience with tools, facilities and techniques for managing and administering data
- 5 years performing Database Server Administration (preferably SQL Server) tasks including
- Setting up of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication, testing of backups to ensure we can meet the business’ recovery time
- Install and configure SQL Servers and apply service packs as needed. This supports Microsoft releases to keep our system up to date and compliant
- Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc
- Detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention
- Monitor and maintain security and performance needs of relational databases
- 2+ years working on a development team: gathering requirements, designing and building databases from requirements, working with application team to build the interface between the application and users, and testing the application and database processes
- Ability to work closely with business line personnel and gain a solid understanding of their processes. Then take that knowledge into development of ad hoc reporting as well as designing of databases used by AAB application developers to support those business processes
- Ability to work closely with Application development personnel to assure that the design and structure of the database works with the application
- This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills
- Excellent written and verbal communication
15
SQL Server Database Administrator Resume Examples & Samples
- Proactively optimize performance of databases through ongoing administration including monitoring, performance and index tuning, and updating/verifying current backup/recovery procedures, troubleshoot network bottlenecks, disk queue issues, table configurations, load monitoring, integrity checks
- Design and maintenance of SSIS packages. Perform daily, weekly, and monthly data maintenance tasks
- Monitoring of scheduled jobs and logs
- Support of business and system processes and procedures
- Installation and Configuration of multiple instances and versions and components of SQL server, including SQL server clustering, reporting services, notification services, and analysis services
- Performance tuning expertise
- Experienced in clustered and non-clustered environments, MS performance tools ( SSMS & Performance dashboard)
- Ability to work on multiple tasks/production issues
- Knowledge to run SQL profiler and capture info
- On call rotation, available for 24/7 support if contacted. Expected to work some weekend, and after hours
- Ability to interact with multiple levels of personnel within the organization and externally
- Ability to work independently, with minimum supervision
- Ability to independently complete assigned tasks and new initiatives
- 3+ yrs SQL Server Database Administrator experience
- Experience with TSQL and Stored Procedure development and troubleshooting
- Experience with MS SQL Server (2005 or greater) tools, including all of the following use of Query Analyzer, SSIS, SQL Agent Jobs and Profiler
- Experience with Windows Server platforms in relation to SQL installations and upgrades
- Able to work on-call as needed
- Associate's or Undergraduate degree (or higher) in computer science
- Experience in SQL Version Migration
- Proficient in SQL performance tuning
16
SQL Server Database Administrator Resume Examples & Samples
- We are seeking a SQL Server DBA to administer and support numerous SQL Server databases in the client Enterprise Data Centers and plants
- The applicant needs to have 5 years of recent SQL Server DBA experience (including 2 years of experience with SQL Server 2012 or 2014)
- The applicant must be able to demonstrate strong technical skills in the use of the components of SQL Server and demonstrate the ability to troubleshoot SQL Server issues
- The individual must be a solid team player with good communication and writing skills
- Experience with Microsoft System Center Operations Manager (SCOM)
- Writing, testing and maintaining T-SQL and stored procedures as they relate to DBA support - Writing, testing and maintaining SSIS packages
17
SQL Server Database Administrator Resume Examples & Samples
- Experience administering SQL Server (2008, 2012 and 2014)
- Experience with virtualization technologies ( Hyper –V, VMware and Citrix)
- Experience with SQL Server failover clustering, replication, and AlwaysOn availability groups
- Strong T-SQL language experience
- Working knowledge of networks, server and storage technologies, preferred
- Proficiency with SQL profiler, Extended Events, Change Data Capture, SSRS and SSIS, preferred
- High level of analytical ability
- Excellent oral and written communication skills to effectively interact with internal and external customers and department staff
18
SQL Server Database Administrator Resume Examples & Samples
- Experienced in clustered and non-clustered environments, MS performance tools (SSMS and Performance dashboard)
- Experience with TSQL and Stored Procedure Development and Troubleshooting
- Experience with MS SQL Server (2005 or greater) tools, including all of the followinguse of Query Analyzer, SSIS, SQL Agent Jobs and Profiler
19
SQL Server Database Administrator Resume Examples & Samples
- Recommend, implement, and maintain database architecture, including deciding whether clustering, mirroring, and replication are recommended to ensure optimal reliability and scalability
- Design and develop data access and repository layers using C# in a domain driven environment
- Troubleshoot and resolve SQL database performance issues and errors using profile traces and other tools
- Oversee database backup, recovery, and migration
- 5+ years MS SQL Server Administration experience
- Experience with database replication
- Ability to analyze, troubleshoot and performance tune SQL queries, stored procedures, packages and functions
- Creative approach to problem-solving with the ability to focus on details while maintaining the “big picture” view
- Ability to organize and plan work independently in a dynamic environment
- Azure SQL
- Agile/Scrum methodologies
- Visual Studio Team Foundation Server or Team Services
- Web Development using MVC, JavaScript, JQuery, HTML, CSS, APIs
20
SQL Server Database Administrator Resume Examples & Samples
- SQL Server Database Engineering, part of Hosting Engineering department involves engineering new versions of SQL Server Database, evaluate security patches, and provide L3 support, EAA, HIR etc
- 5+ years SQL Server DBA experience, supporting SQL Server 2008/2012/2014
- Experience with SQL Server Reporting Services, Integration Services, Analytical Services
- Experience with research and engineering of features (installation, configuration, monitoring, security, etc.) for SQL Server database, so that it can be deployed in a standard method across the Enterprise
- Experience with design and engineer SQL Server database with other infrastructure technologies (backup tool, monitoring tool, O.S. Configuration, application interface, etc.)
- Ability to provide third level support (troubleshoot and problem solving) to SQL Operations DBA
- Experience with architecting and engineering of High Availability and Disaster Recovery solution for SQL Server
- Strong knowledge of Windows platform
- Strong knowledge of SQL Azure
- Experience with Other DBMS (e.g. Oracle) a plus
- Inter-personnel skills working with other team members in same and across organization
- Experience with Microsoft Azure services is a plus
21
SQL Server Database Administrator Resume Examples & Samples
- SQL Server configuration,integration, fail over, updates, and optimization with versions 2008 and 2012
- Review and create stored procedures
- Improve performance and security of the SQL Server databases
- Additional experience in T-SQL, Batch scripting and ITIL experience is ideal
22
SQL Server Database Administrator / Developer Resume Examples & Samples
- Apply data modeling techniques to ensure development and implementation projects meet integration and performance expectations
- Design and develop database application solutions using tables, indexes, views, stored procedures, functions, triggers, jobs, etc
- Independently analyze and resolve issues in real time, providing problem resolution end-to-end
- Automate data import and update processes, track issues, and maintain documentation
- Provide technical mentorship and cross-training to other team members
- Participate in the validation process through unit and integration testing and bug fixes
- 5+ years MS SQL Server administration and development experience
- Experience in database design, development and data modeling
- Experience with backup, restore, and recovery models
- Experience working with Windows Server, including Active Directory
- Translate business requirements and functional specifications into detailed system and program design specifications
- Ability to develop, analyze, troubleshoot and performance tune SQL queries, stored procedures, packages and functions
- Ability to identify problems, and effectively communicate solutions to peers and management
- Strong analytical, planning, and organizational skills with ability to manage competing demands
- Business Intelligence (BI)
- SQL Server Analysis Services (SSAS)
- Redgate
- Microsoft .Net Framework / C#
23
Senior SQL Server Database Administrator Resume Examples & Samples
- Lead efforts to guide team to best practices for database usage, high availability and business continuity
- Analyze existing database applications to migrate into or improve the functioning on the platform
- Provide guidance to other database administrators to expand the role and capabilities of the database environment
- Prepare periodic reports regarding unit's activities and goal attainment
- Maintain a state-of-the-art knowledge of existing best practices in database administration
- 7 years of database related experience
- Prior experience with the following is preferred: SQL Clustering, Strong Transact-SQL & MS Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) knowledge, Replication, Performance Tuning, Backup and recovery methods, Log shipping, Database Mirroring, Availability Groups, Database capacity planning, and Users and Role creation and monitoring
- Experience in third party tools like Quest Software SQL Lite Speed, Quest Software Spotlight, Quest Fog light and Quest Fog light Performance Analysis
- Additional Skills/Knowledge
- Less than 20%
24
SQL Server Database Administrator Resume Examples & Samples
- 5+ years of experience in Database Administration in MS SQL Server (2005 and 2008)
- 5+ years of experience in support MS SQL server on MS Windows Cluster Server
- Knowledge of MS SQL 2008 Mirroring
- Experience in troubleshooting SQL Server related CPU, memory, I/O, disk space and other resource contention
- Experience in backup/restore, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring and Replication
- Expert in implementing operational automation
25
SQL Server Database Administrator Resume Examples & Samples
- Will provide problem resolution for server and database-related functions with an emphasis in troubleshooting and supporting Enterprise-scale SQL Servers and integrations
- Creates and manages server/database related documentations
- Will create and manage corporate data model diagrams and data dictionary information current
- Processes workflows for database and data model activities, such as migrating schema changes and enterprise-wide standards throughout the environment
- Manages corporate data policies, such as backup/recovery, security and database maintenance routines and schedules
- Responsible for performance monitoring and tuning of development, test and production environments including identification and tuning of poor-performing application code and/or database configuration
- Identifies and automates regular database and application maintenance tasks
- Must be able to provide support 7x24 Hours
- Must be open and willing to share on-call duties
- Expert in SQL Server 2005, 2008, 2012, 2014 administration
- Proven ability in managing SSIS, Analysis Server and Reporting Server, BIDS
- MS SQL Server 2012/2014 Always on, Clustering, Replication and Distribution Servers
- Must have the ability to work both independently and as part of team depending on assignment
- Demonstrated ability in code promotions from DEV to TEST and then to Prod
- Strong knowledge writing TSQL, stored procedures, functions and triggers, data transformations using BIDS
- Ability to learn new technologies and implement
- Must be good team player who is willing to share knowledge and ideas
- Must be able to work independently with the ability to juggle priorities and manage time to effectively meet deadlines. Strong project management skills necessary
- Proven ability and experience of managing SQL Server 2005, 2008 R2, 2012, 2014 RDBMS scaling from small to VLDB’s in terra bytes
- Expertise in DBA Activities like Monitoring of Database, Performance Monitoring, Backup & Recovery, Database Creation, Database Security, User Management, Patch management, schema and Data Migration
- Expertise installing, upgrading and managing SQL Server, Analysis services, Reporting Services and SSIS
- Hands-on experience in monitoring and tuning a database to provide a high availability service
- Strong knowledge normalized and dimensional database experience
- Strong knowledge in entity-relationship models and DWH design techniques
- Strong knowledge, self-sufficiency and initiative working on database projects
- Seven plus years of progressive, hands on experience on database administration on SQL Server 2005, SQL Server 2008, SQL Server 2012, and SQL Server 2014 in mission critical environments
- Experience on MySQL administration will be a major PLUS
- Experience on ProClarity/Pyramid and Performance Point Server and SharePoint Server will be a plus
- Experience in Essbase Administration
26
Senior SQL Server Database Administrator Resume Examples & Samples
- Demonstrated performance monitoring and tuning ability, including an aptitude to lead the diagnosis and resolution of performance problems within a large-scale, complex infrastructure
- Familiarity with lean/agile development is considered a plus, as this will be an increasingly common approach
- Ability to define and gain adoption of best practice techniques
27
Senior SQL Server Database Administrator Resume Examples & Samples
- Assigns technical tasks and responsibilities to appropriate team members
- Implements database changes and identifies issues proactively to prevent outages with a goal of 100% uptime
- Responsible for the creation of development, staging & production database instances and the migration of those application objects from one environment to another
- Responsible for all the performance tuning of the staging and production database instances
- Creates clear documentation of operating procedures, database object layout, work flow diagrams and specifications for developed databases
- Leads training for technical support and applications staff
- Designs, implements, documents and monitors backup/recovery procedures
- Oversees vendor supplied patches/upgrades
- Fulfills department requirements in terms of providing work coverage and administrative notification during periods of personnel illness, vacation or other absence
- Performance history of providing technical expertise with high levels of integrity and results
- Experience as lead role and liaison with business and development teams
- An expert level understanding of Relational Database Management System (RDBMS) fundamentals
- Ability to use SQL programming skills to perform data troubleshooting and data manipulation tasks is required
- Experience with disaster recovery planning and implementation is required
- Strong experience with data profiling, meta-data analysis, data modeling, and relational schema design is required
- Expertise in crossing platforms (e.g. – MySQL to Oracle), code migration, database change management and data management through the various stages of the development life cycle is preferred
- Experience using third-party database monitoring tools is required
- Demonstrable skills in database clustering, partitioning and replication
- Strong communication skills; including ability to express complex technical concepts effectively, both verbally and in writing is required
- Ability to work well with people from many different disciplines with varying degrees of technical experience
- Expertise supporting the data repository needs of the IBM product stack
28
SQL Server Database Administrator Resume Examples & Samples
- Administer Microsoft SQL Server environments and dependent infrastructure, including deployment, security, clustering, backup, recovery, and disaster recovery planning
- Perform proactive SQL Server performance tuning and optimization
- Proactively trend SQL Server performance marks, bringing trending concerns and optimization recommendations before management
- Maintain a pulse of emerging SQL Server features and security risks, administering upgrades and patches as deemed appropriate
- Maintain documented SQL Server recovery procedures, exercising such within a controlled test environment to prove viability
- Actively collaborate with application development to
- 4+ years administering Microsoft SQL Server environments up to and including v2014 Standard and Enterprise
- 3+ years administering performance tuning and optimization of SQL Server environments
- Working knowledge of Microsoft SQL Server SSRS, SSAS, SSIS, and AlwaysOn Availability Groups
- Knowledge of Microsoft OS, clustering, enterprise storage, and network fabric (Ethernet and Fiber)
- Four-year or advanced college degree in Computer Science, Information Technology, or other related field
29
Junior SQL Server Database Administrator Resume Examples & Samples
- 3+ years of Database Administration experience
- Knowledge of SQL, TSQL and database design
- Experience using Microsoft SQL Server and 2008/2012
- Knowledge of SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)
- Application installation, data conversion and testing experience
- Proven experience with troubleshooting principles, methodologies and issue resolution techniques
30
Junior SQL Server Database Administrator Resume Examples & Samples
- Install and configure SQL Server 2012 and higher versions. Configurations built and supported should include scenarios that include leveraging SQL Always On, windows fail over clustering, and transaction replication
- Document complex installation, configuration, and optimization procedures so they can be automated
- Create, implement, and maintain SQL DB Health Checks, and have a demonstrated ability to automate SQL health reporting/event notification, and corrective actions
- Identify code defects and enhancements and develop a detailed root cause analysis that can be leveraged by the product management and development teams to improve application availability and decrease the total cost of ownership
- Perform all database management responsibilities in Microsoft Azure for production and non-production workloads
- At least 1 year experience working as a Microsoft SQL DBA leveraging versions 2008r2 or later
- Familiar with basic Azure IaaS capabilities, and some experience designing and building MS SQL databases within Azure or AWS is a plus
- Background designing, building, and managing a search and indexing solution such as Elastic Search, Apache SOLR, etc. is a plus
31
Ms SQL Server Database Administrator Resume Examples & Samples
- Responsible for installing SQL on standalones and clusters, upgrading, patching and keeping SQL servers up to date with the latest Service packs
- Implementing database replication and migrations from one server to another for generating reports and synchronizing the development and production environments
- Setting up HA and DR solutions using log shipping, mirroring, failover cluster and HADR (Alwayson)
- Handle refreshes for test and dev environments
- Troubleshooting SQL server connectivity problems and various errors as part of day-to-day maintenance of servers
- Help with tuning complex queries and stored procedures
- Participate in development and implementation of disaster recovery plans
- Help create, enforce and manage the policies and procedures
32
SQL Server Database Administrator Resume Examples & Samples
- 5 years of experience with IT
- Experience with MS SQL Server 2012 scripting, including designing a database collaboratively to ensure that new iterations follow fundamental concepts
- Knowledge of Team Foundation Server
- Ability to work collaboratively across the O&M and new development teams, prioritize work, meet deadlines, and produce high quality work packages
- Ability to speak and interact professionally in a client environment
- Experience with JIRA a plus
- Knowledge of Agile concepts preferred
- Ability to update system documentation, as required
33
SQL Server Database Administrator Resume Examples & Samples
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
- Provide 24x7 support for critical production systems
- Perform scheduled maintenance and support release deployment activities after hours
- Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members
- Participate in Monthly patching
- Participate in Disaster Recovery events
- Experience with implementing and managing MS SQL Server 2005/2008/R2/+ databases in Windows 2003/2010 x32 and x64 Server OS environment
- Experience with SQL Server Data Transformation Services (DTS), SQL Server Integration Services (SSIS) and Transact-SQL programming
- Experience with clustered database servers
- Experience running SQL on virtual machines
- Experience with Mirroring, Log Shipping and Availability Groups
34
SQL Server Database Administrator Resume Examples & Samples
- 6 years of experience working with computers
- 2 years of experience in maintaining an operational database environment including capacity analysis, performance tuning, and backup and restoration planning
- Good technical writing, presentation, and documentation skills
- Must have excellent team skills and collaboration skills
- Attention to detail and follow‐through
- Current Microsoft DBA certification
- Current Security + or equivalent certification
- Current favorable NACLC
35
SQL Server Database Administrator Resume Examples & Samples
- At least 5 years with SQL 2005, 2008, 2012,2014, 2016(desirable)
- Project and/or advanced database administrator experience
- Always-on Availability Groups, Data Mirroring and other replication technologies
- Installation and configuration including security modelling
- Exposure to SSIS, SSAS and SSRS 2008/2008R2/2014/2016
- Excellent understanding of TSQL and T-SQL scripting
- Automation and scripting, PowerShell desirable
- Ability to act in a mentoring and leadership role
- Exposure to Azure advantageous
- Consultancy experience is welcome
- Any Microsoft certification is a plus
- Must be able to undertake SC clearance
- This role can be based in Nottingham or Hatfield�
- There is an on call requirement in this role
36
Microsoft SQL Server Database Administrator Resume Examples & Samples
- Minimum of 6 years of experience in database administration (Microsoft SQL Server)
- Bachelor’s degree in CIS or higher level education preferred
- Maintains several database environments; applies updates, maintenance packs, patches, & fixes for all environments
37
SQL Server Database Administrator Resume Examples & Samples
- Accountable for the database architectural design of existing and new systems, database administration, performance monitoring tuning, troubleshooting problems and expansion
- Continuous capacity planning and monitoring database growth
- Develop, maintain, and administer complex ETL using SQL Server (DTS and SSIS)
- Design, maintain and ensure High Availability Solutions including replication, clustering etc
- Perform capacity planning work on production, UA, QA, DEV and DR environments
- Research and recommend improvements to the overall system performance
- Communicate and coordinate with other internal IT Teams to successfully resolve support and maintenance issues
- Participate and support 24 x 7 production environment and mission-critical applications with the Database Technology Team on a rotational schedule
- Bachelor’s degree in Computer Science, Information Systems, or related field, or equivalent industry experience. (Master’s degree a plus)
- 6 years of experience developing, maintaining and administering MS SQL Server databases required
- Experience configuring SQL Server replication required
- 2+ years developing, maintaining and administering Oracle 9g/10g/11g/12c databases preferred
- Experience with IBM CDC and PDA/Netezza preferred
- Experience working with IBM InfoSphere Products (DataStage, QualityStage, Metedata Workbench, etc) preferred
- Ability to manage multiple priorities as well as flexibility to adapt to change with new systems and methods while working in a team environment
38
SQL Server Database Administrator Resume Examples & Samples
- Auditing policies and security
- Installation and upgrades
- Creating user accounts and granting access to users
- Developing SQL scripts, stored procedures, triggers, views, etc
- Developing and maintaining data migration processes
- Assist in other database related tasks as needed
- 1-2 years’ experience of SQL Server database administration
- SQL language and scripting
- Knowledge of OLAP and OLTP environments
- Basic knowledge of networking and server systems
39
Senior SQL Server Database Administrator Resume Examples & Samples
- 6+ years of experience as a SQL Server Database Administrator
- Strong Experience with SQL Server 2008, 2008 R2, and 2012 databases, Integration Services, and Reporting Services in software development and production environments
- Technical knowledge and experience with database environments, tools, utilities, configurations, backup and recovery, job scheduling, release management, change management and compliance
- Experience with implementation and maintenance of High Availability implementations – Availability Groups, Log Shipping, Clustering
- Experience with SQL Server Patch implementation
- Solid experience with SQL Server monitoring, reporting and alerting
- Solid experience with SQL server performance tuning
- Extensive knowledge of disaster record processes and procedures and be able to write, maintain and implement a disaster recovery plan
- Exceptional SQL (Transact-SQL) skills
- Experience with PowerShell scripting
- Awareness of database design patterns and working experience of object-relational mapping
- Demonstrated ability to prioritize multiple concurrent tasks to best meet overall goals
- Experience with Data recovery methods
- Knowledge of SSIS packages and SSRS reports
- Experience in writing stored procedures
40
SQL Server Database Administrator Resume Examples & Samples
- 3 - 5 years MS SQL Server Administration experience
- Two or more years' experience working with of BI reporting tools
- Knowledge of data warehousing and ETL processing
- Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
- Flexible, team player, "get-it-done" personality
- Ability to work in a rapidly changing environment
41
SQL Server Database Administrator Resume Examples & Samples
- Database Tuning
- High Availability Architecture
- Replication
- SQL Server certification a plus
- Experience with other database systems (Oracle, Sybase, IBM DB2) a plus
42
Senior SQL Server Database Administrator Resume Examples & Samples
- Serve as the highest level technical expert in the latest database technologies and architecture
- Develop policies, security baselines, and configuration standards for database usage
- Information Systems, Computer Science or Computer Engineering degree or equivalent
- Strong service orientated, collaborative attitude with both peers and internal customers
- Constant process improvement thinking to reduce delivery time and increase customer satisfaction
- 10+ years of database design, engineering & operations/support experience
- Ability to work independently and to resolve complex issues
- Ability to work with diverse internal and external groups including solution and third party vendors in a constructive and collaborative manner
- Demonstrated ability to follow project management best practices in support of large, complex, enterprise projects
- Ability to estimate required work effort
- Highly developed problem solving skills within their area of database technology leading to reduced impact to customers
- Ability to negotiate and build consensus with various stakeholder groups
- Ability to makes complex ideas or situations clear, simple, and/or understandable
- Knowledge of IT architecture, infrastructure standards, database platforms and programming languages and tools
- Demonstrates a deep understanding of emerging technologies and trends that could impact the field and the business
- Willingness to learn the business and new technology
- In depth and Hands on technical experience in SQL Server 2008, SQL Server 12, SQL Server 14
- Experience with SQL Server High Availability technologies e.g. Always On, Database Mirroring, Log Shipping
- Experience in engineering and sustaining SQL Server instances in a windows clustered environment
- Experience in data encryption at rest and in-transit using native SQL server technology
- Experience in SSRS, SSIS and DTS
- Experience with scripting & automation
- Additional Experience in Oracle database technologies a plus
- Excellent documentation and communication skills
- Strong organization and interpersonal skills
- Team-oriented work ethic that includes willingness to help others
- Able to work independently and share results of assigned projects with team members
- Ally Financial Inc. (NYSE: ALLY) is a leading digital financial services company and a top 25 U.S. financial holding company offering financial products for consumers, businesses, automotive dealers and corporate clients. Ally's legacy dates back to 1919, and the company was redesigned in 2009 with a distinctive brand, innovative approach and relentless focus on its customers. Ally has an award-winning online bank (member FDIC), one of the largest full service auto finance operations in the country, a complementary auto-focused insurance business, a growing digital wealth management and online brokerage platform, and a trusted corporate finance business offering capital for equity sponsors and middle-market companies
43
SQL Server Database Administrator Resume Examples & Samples
- 2252
- Five or more years experience with SQL Server Enterprise Edition and all facets of database administration
- Five or more years experience with SQL Server High Availability features: failover clustering, log shipping, database mirroring
- Five or more years experience with Windows Server 2008 R2 and Microsoft Cluster Services
- Installation and configuration experience with SQL Server, SQL Server Service Packs and Cumulative Updates
- Experience with PowerShell 2.0 (or higher)
- Strong Performance Tuning Skills
- Strong interpersonal skills and willing to be a team player
- Participate in 7x24 on-call support rotation and expected to work during mission critical situations
- Required Certifications: 1. CompTIA Security+ 2. Microsoft SQL Server 2008
- Working knowledge of DoD Security Technical Implementation Guides (STIGs), Security Readiness Review (SRR) scripts, and Information Assurance Vulnerability Management (IAVM)
- Experience with SQL Server 2012
- Experience with SQL Server Analysis Services (SSAS)
44
SQL Server Database Administrator Resume Examples & Samples
- Install, configure, and deploy Ellucian ERP applications in Amazon Web Services
- Planning, analysis, coordination, support and maintenance of the Ellucian ERP systems, Ellucian Portal, and other related client integrations and applications in support of transition from on-premise to AWS
- Install, configure, maintain and upgrade Ellucian software and any required technologies in support of the applications during transition
- Work with Architecture team on improving and evolving implementation and migration standards, automation, and scripting
- Work on documenting client environments and processes
- Performing technical troubleshooting covering data migrations, interoperability, middleware, performance and product related issues
45
SQL Server Database Administrator Resume Examples & Samples
- Provide thought leadership on database architectural design of existing and new systems, database administration, performance monitoring tuning, troubleshooting problems and expansion
- Research improvements to improve overall system performance
- Communicate and coordinate with other Hub IT teams to successfully resolve support and maintenance issues
- 6 years of experience developing, maintaining and administering MS SQL Server databases
- Experience configuring SQL Server replication and mirroring
- Experience with IBM CDC preferred
- Experience developing, maintaining and administering Oracle 9g/10g/11g/12c databases a plus
- Experience IBM PDA/Netezza administration a plus
- Experience working with IBM InfoSphere Products (DataStage, QualityStage, Metedata Workbench, etc) a plus
46
SQL Server Database Administrator Resume Examples & Samples
- Install and configure SQL Server 2016 and higher versions. Configurations built and supported should include scenarios that include leveraging SQL AlwaysOn and Windows failover clustering
- Document installation, configuration, and optimization procedures so they can be automated
- Provide support 24/7/365 for any troubleshooting or corrective actions related to incidents impacting application availability within the production environments
- Take proactive measures to monitor, trend, and tune SQL databases, such as running maintenance jobs (backups, DBCCs, apply indexes/re-indexing, etc.), to meet or exceed baseline stability and performance SLAs
- When performance issues arise, determine the most effective way to increase performance including scaling up or out, server configuration changes, index/query changes, etc
- Ensure databases are being backed up and can be recovered in a manner that meets all BCDR objectives for RPO and RTO
- At least 2 years’ experience working as a Microsoft SQL DBA leveraging versions 2012 or later
- Bachelor’s degree in Computer Science or Information Systems
- Familiar with basic Azure IaaS capabilities
- Experience automating SQL Server deployment and configuration through PowerShell, Chef, etc
47
SQL Server Database Administrator Resume Examples & Samples
- 3 years of experience as a SQL Server Database Administrator
- Experience with SQL Server Management Studio (SSMS)
- Experience with general Database Administration activities (backups, maintenance plans, performance tuning)
- Proven experience in any of the following
- Maintains database environments; applies updates, maintenance packs, patches, & fixes for all environments
- Performs application upgrades
- Assists in the maintenance and management of database reporting infrastructure
- Works closely with developers, support and QA teams to maintain all DB environments
- Performs database administration activities including; installation, configuration, monitoring, space management, database backup and recovery and disaster recovery
- Performs database server upgrades
48
Ms SQL Server Database Administrator Resume Examples & Samples
- Manage the installation, maintenance and development of the corporate server software and hardware, ensuring license compliance and operational software is at least the lowest currently supported version
- Manage infrastructure performance and capacity and data security and make recommendations for improvements
- Monitor corporate servers and ensure efficient optimization of system performance
- Diagnose and resolve infrastructure problems, ensuring that account is taken of agreed levels of service and the needs for quality, security, availability and safety, utilising appropriate specialised techniques, tools, methods or standards
- Provide detailed advice and guidance to customers in the use of systems, products and services, to meet business requirements
- Contribute to the development of the ICT technical strategies, policies and procedures
- Implement infrastructure systems, either leading as project manager, or assisting as part of a team
- Provide advice to customers on the impact of requests for change and ensure that the appropriate impact analyses are carried out before changes are authorised
- Provide advice and guidance to management in the planning phases of information systems, to ensure that infrastructure requirements are reflected in the overall specification
- Plan for backup and recovery of system and database information, ensuring backups are carried out as per plans, planning and managing exercises to prove recovery procedures
- Implement recovery procedures when necessary. Work with the Configuration Management Officer to ensure Disaster Recovery and Business Continuity documentation is in place
- Assist in the monitoring and review of the performance and quality of service provided by the infrastructure
- Keep abreast of developments with regards MS SQL server and other database software and the underlying hardware infrastructure
- Provide a high quality, customer focussed service that is responsive to customer needs
- Comply with all Engie and client policies and procedures
- Ensure the health, safety and welfare of employees and the public by complying with the appropriate health and safety policies
- Undertake relevant training to the job
- Represent your line manager as and when required
- Carry out project work or secondment to other teams as appropriate
- Carry out any other duties as appropriate
- Ability to develop practical solutions to user and system requirements
- Able to manage and prioritise tasks and work schedules
- Positive customer service skills and friendly, flexible manner
- Ability to advise, guide and communicate technical issues to non technical staff
- Communicate effectively both verbally and in writing
- Customer care skills
- Experience of working within an ICT support environment
- A detailed knowledge of Microsoft SQL server (2005, 2008 and upwards) including design and installation, performance tuning and optimisation
- Tasks will include
- Monitoring system health and performance
- Identifying and resolving performance problems
- Refine and automate regular processes, track issues, and document changes
- MS Windows system administration
- NetApp
- CISCO UCS / Flexpod
49
Ms SQL Server Database Administrator Resume Examples & Samples
- Configure, monitor and maintain database servers
- Design backup processes to the databases
- Implementing performance tuning on the databases
- Support the development of strategy, structure and integrations for cooperation with architects in other EF departments
- Planning, designing and creating SSAS cubes for Business Intelligence
- Build business intelligence reports in SSRS and PowerBI
- As part of a central team you will be travelling to EF offices around the world
- Sc. or M.Sc. in Computer Science or similar
- Solid experience and knowledge in MS SQL Server and Microsoft BI stack (SSIS, SSAS and SSRS)
- Able to communicate your DBA perspective on any area with ease
- Preferably hands-on experience from: Installing server software and updates, monitor and maintain health and security, designing backup processes for servers
- Attention to detail and a high level of comfort with a fast-paced environment
- Strong problem solving ability with the desire to take ownership of issues and follow through until resolution
50
SQL Server Database Administrator Resume Examples & Samples
- Installations
- Database backup and restore
- Managing data files and transaction log
- Managing SQL server security subsystem
- Knowledge of SQL Server agent and jobs
- Experience with following technologies will be considering as an advantage
- Administering Microsoft Windows Server 2003/2008/2012 operating systems
- Upgrades, Migrations, Patching
- HA/DR solutions: MS Cluster, Database Mirroring, Log shipping, SQL replication
- Hardware knowledge with regards of the database architecture and design
- IO Subsystem (RAID levels, IO best practices), Memory and CPU configurations, Network libraries, etc
51
SQL Server Database Administrator Resume Examples & Samples
- 3 Years experience with Microsoft SQL Server and related tools
- 3 Years Data Modeling, ETL Design and Development experience
- 3 years experience supporting application database development lifecycle, and application development teams
52
SQL Server Database Administrator Resume Examples & Samples
- Create, maintain, and administer SQL Server databases
- Ensure the databases are highly secure, available, and recoverable
- Proactively monitor and tune the databases for maximum performance
- Install, configure, and patch database software and complete database migrations and upgrades
- Support web application development, with a focus on helping the team interact with the database in the most efficient and productive way possible
- Troubleshoot and solve database and application coding problems; and
- Deploy the database components for new versions of our web applications to test and production environments
- Up to 2 years of experience in SQL Server database administration
- Knowledge of relational database management concepts and theories
- Experience with the Structured Query Language (SQL)
- Familiarity with Transact-SQL (T-SQL) and SQL Server DTS/SQL Server SSIS packages
- Exposure to multiple database management systems (Oracle, Cassandra, MongoDB) is a plus
- Demonstrated desire and ability to learn technologies quickly
53
SQL Server Database Administrator Resume Examples & Samples
- 24/7 monitoring and support of highly available SQL environments. Manage and participate in ongoing SQL code and schema development
- Review code, manage standards and best practices
- Collaborate with engineering, project and operation teams by conducting the database administration task such as but not limited to SQL code review, maintenance, installation, configuration, upgrade and migration
- Conduct backup and recovery, database security, storage and capacity planning, performance monitoring and tuning tasks
- Conduct trouble shooting and data restores as needed
- Collaborate with other DBAs to establish and enhance best practices in the area of back-up, data-recovery, database security, ETL, and storage
- 5 plus years of SQL Server 2012 or higher experience
- SQL Server replication technologies such as mirroring
- Strong technical abilities
- Quick study of new technology via on the job training
- Intellect to resolve complex problems logically and methodically
- Ability to be on call 24 x 7 x 365 in a team rotation
- SQL scripting experience a plus
- Order Management/Digital industry experience a plus
- Working with application teams in support of new and existing solutions
- Expertise in performance monitoring and tuning
54
SQL Server Database Administrator Resume Examples & Samples
- Sets and administers standards for organization's relational database structure/architecture
- Responsible for the overall application database model, ERD, physical model/implementation, stored procedure library, and all data queries & ETL processes
- Assists software developers with the creation and maintenance of robust, scalable database code, and evaluates new and existing code for performance and scalability
- Ensures that plans for database technologies integrate effectively with other aspects of the technical infrastructure
- Researches database technology, determines business requirements, proposes changes, and develops migration and implementation plans
- Performs database design reviews, applying best practices and standards
- Minimum 5 years SQL Server or PostgreSQL database technologies or other relational database management system
- Experience with reporting and analytical tools such as SQL Server Reporting Services, SQL Server Analysis Services
- Minimum 3 years of database modelling experience, designing schemas for OLTP & OLAP databases
- A thorough understanding of database structures and query optimization, data replication techniques, ETL and BI technologies and tools
- Must have the ability to architect, design, install, and configure large, complex databases with replication and high-availability on several MS-SQL versions
- Excellent SQL skills development and tuning skills, with the ability to generate complex SQL queries from an entity- relationship diagram
55
SQL Server Database Administrator Resume Examples & Samples
- Ensures service level agreements are met for internal and external clients
- Provides status reports that detail issues for escalation to management
- Creates and maintains documentation for database policies, procedures, and processes
- Monitors database performance, availability, and capacity
- Knowledge of database management systems
- Ability to work independently and in a team environment with minimal supervision
- Must be self-motivated, a team player, and have a strong track record in customer satisfaction
- Strong problem-solving skills
- Knowledge of backup and recovery operations for database management systems
- Ability to adapt to the use of new software tools as they are acquired or adopted within IT
56
SQL Server Database Administrator Resume Examples & Samples
- 10 or more years of experience in operations/technology project management activities
- Superior knowledge of policies, plans, procedures, products and regulatory requirements for assigned business unit
- Ability to conduct an analysis of a business need, including scheduling meetings, planning agendas and conferring with business line leaders
- Comprehensive understanding of project management and testing methodology and procedures
- Ability to develop test schedules, review testing plans, track test issues and report on test results
- Ability to manage multiple tasks/projects and deadlines simultaneously with limited supervision
- Ability to work as a team leader
- Excellent verbal and written presentation and communication skills
57
Senior SQL Server Database Administrator Resume Examples & Samples
- Clients are internal to IT, but the technology platform involves all of CTY’s students, families and employees
- Schema design, architecting
- SQL reporting/BI Tools (SSRS)
- Development and maintenance of datawarehouse
- Must be able to function independently with little oversight (strong technical knowledge)
- SQL Database
- CIS
- Development of datawarehouse, web services, BI reporting tools, data analytics
- Knowledge in the assigned application as well as the platform on which it runs
- Extensive experience with database development tools, ETL and integration technologies
- Experience with Agile, test-driven development, and continuous integration process
- Experience developing interfaces to SQL-based databases
- Experience working in controlled development, testing and production environments
- Experience in Data Modeling, Data Warehousing, SQL, ETL processing
- Familiarity with development toolkits & source repositories, SQL interpreters, IDEs, etc
- Excellent problem-solving and quantitative skills
- Must be able to work on multiple priorities effectively and prioritize conflicting demands in a customer-service oriented team
- Demonstrated ability to work as part of a team
- Experience with additional programming languages (C#/.Net, Java, etc.)
58
Lead SQL Server Database Administrator Resume Examples & Samples
- Maintain database support documentation
- Install and upgrade software and hardware as required to support applications
- Manage system storage and capacity planning
- Provide end user database support
- Monitor database system performance and suggest optimizations as needed
- Manage and audit user access to DEV/TEST and PROD databases
- Assist in support for resolving system malfunctions
- Purchase of new equipment as required
- Integrate new equipment, database software, and system software as it is purchased
- Provide low-level support to engineering team
- Support development staff by tuning SQL queries for maximum performance
- 3+ years’ experience administering and maintaining replicated Microsoft SQL Server databases in a distributed production environment(reporting experience a plus)
- 2+ years of production DBA experience including development, test and production database environments
- General understanding of database theory, and database design
- Experience with Microsoft environment and tools, such as Enterprise Manager, Query Analyzer, and Profiler
- Advanced knowledge of SQL language. Ability to write and deploy effective triggers, stored procedures and user defined functions
- Ability to perform SQL query optimization. Must know query optimization tools, query plan analysis, techniques for finding inefficient queries. Experience with DTS Packages, jobs, query planning and optimization tools
- General understanding of storage technologies (Disk storage, SAN, NAS, SSD, RAID/Striping) and networking (Ethernet, switching, IP, and routing)
- Proven ability to work with large (20 GB+ in size) databases: includes knowledge of partitioned data storage, techniques for optimal loading of large data sets, and how large data volume affects replication in SQL Server environment
- Thorough understanding of best practices for database maintenance, including index and file management, backups, failure recovery, database defragmentation, documentation. Ability to analyze disk space requirements and hardware utilization, automate error notification
- Experience with database auditing techniques
59
SQL Server Database Administrator Resume Examples & Samples
- 6+ years Database Design, Database Maintenance, Database Security, Database Management, Requirements Analysis, Open source DB knowledge, Oracle, SQL Server, SSRS
- Experience designing massively scalable cloud SQL database architectures
- Develop cost effective infrastructure and licensing models for MS SQL infrastructures
60
SQL Server Database Administrator Resume Examples & Samples
- Installs and configures databases and database-related software utilities to meet department needs
- Develops scripts (e.g. SQL, Unix Shell, Perl) to monitor and support database environments
- Develops and tests backup and recovery processes to ensure high availability and recoverability of databases
- Collects and analyzes data for capacity planning / performance monitoring
- Independently performs functions to administer system access (e.g. setting up accounts, maintaining privileges and roles, maintaining passwords,). Works with Enterprise Data and Information Security and Change Management to ensure internal controls compliance
- Reviews and contributes to system design documents (SDD) to meet the objectives of the project
- Defines DBA tasks and provides time estimates to aid in project scheduling. May coordinate tasks with other IT departments. Monitors progress against task estimates to provide status
- Assists with the database infrastructure design to meet project objectives. May also be called upon to translate logical data elements into the physical data design
- Supports database changes during user acceptance testing and post implementation to ensure integrity of the application
- Participates in Business Continuity Plan (BCP) projects and tests to ensure high availability of our critical production databases
- Develops and maintains knowledge in area of expertise, as well as a general understanding of all databases and operating systems, to provide daytime and after hours support for production databases
- Recognizes process and/or standard inefficiencies and makes suggestions for improvement
61
SQL Server Database Administrator Resume Examples & Samples
- BS Degree in CS, IS or related field
- 5 plus years demonstrated experience with SQL Server RDBMS on Windows operating systems
- Expertise with Server performance tuning and SQL development including database design, triggers and stored procedures
- Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information. Must be a U.S. Citizen
- Knowledge of RDBMS Management Tools, SQL Server Management Studio, RMAN
- Knowledge, training and experience with database design and management technologies
- Thorough knowledge of T-SQL and other database development and reporting tools
- Experience with Quality Management, Change Management and SDLC methods and philosophies
62
SQL Server Database Administrator Resume Examples & Samples
- Proactively optimize performance of databases through ongoing administration including monitoring, performance and index tuning, and updating/verifying current backup / recovery procedures, troubleshoot network bottlenecks, disk queue issues, table configurations, load monitoring, integrity checks
- 3+ years of SQL Server Database Administrator experience
- Experience with T-SQL and Stored Procedure development and troubleshooting
- Must be able to work on-call rotation every 5 weeks for 1 week
- Bachelor's Degree (or higher) in Computer Science or related field
- Disaster Recovery Planning experience
- SQL performance tuning experience
- Ability to work on multiple tasks / production issues
63
SQL Server Database Administrator Resume Examples & Samples
- Monitoring the Databases
- Monitoring / configuring Database replication Ensuring Database security polices are enforced
- Performing upgrades and applying patches
- Monitoring Database performance
- Database Builds
- Provide a test environment for application support /development
64
Senior SQL Server Database Administrator Resume Examples & Samples
- Take proactive measures to monitor, trend, and tune SQL databases, such as running maintenance jobs (backups, DBCCs, apply indexes/re-indexing, etc.), to meet or exceed baseline stability and performance SLAs on large databases (1 TB+) and large volumes of databases (100+)
- Configure SQL Server monitoring utilities to minimize false alarms, and have a demonstrated ability to monitor/trend SQL environments to determine and implement enhanced monitoring thresholds to prevent incidents and reduce mean time to recovery (MTTR)
- At least 4 years’ experience working as a Microsoft SQL DBA leveraging versions 2008r2 or later
- Experience working in a 24/7/365 operation
- Familiar with basic Azure IaaS capabilities, and some experience designing and building MS SQL databases within Azure or AWS
- Microsoft certifications such as MCSE, MCSD, etc
- Experience operating in an ISO certified and/or highly regulated (SSAE, PCI, HIPPA, etc.) hosting operation
- Familiar with Dev/Ops concepts, and ideally experience working with a Dev/Ops team focused on implementing and enhancing continuous delivery capabilities
- Experience automating SQL Server deployment and configuration through PowerShell, Chef, Puppet, etc
- Background designing, building, and managing a search and indexing solution such as Elastic Search, Apache SOLR, etc
- Previous Relativity system administration experience preferred
65
Senior SQL Server Database Administrator Resume Examples & Samples
- BS or equivalent and five years related experience or MS and three years related experience
- ITIL Foundations certification is a plus
- Familiarity with JIRA and Confluence tools
66
SQL Server Database Administrator Resume Examples & Samples
- Provides level 2 support for any computer or network problems that should arise within MMS
- Works with Help Desk and Network Operations staff as appropriate to determine and resolve problems received from clients
- Works closely with various system owners and provides ongoing support
- Installs new/rebuild existing servers and configure hardware, peripherals, services, settings, directories, storage, etc. in accordance with standards and project/operational requirements
- Works with vendor support contacts to resolve technical problems with desktop computing equipment and software applications
- Performs daily system monitoring, verifying the integrity and availability of all hardware, server resources, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups
- Performs daily backup operations, ensuring all required file systems and system data are successfully backed up to the appropriate media, recovery tapes or disks are created, and media is recycled and sent off site as necessary
- Applies OS patches and upgrades on a regular basis, and upgrades administrative tools and utilities. Configures /adds new services as necessary
- 4-6 years experience supporting a LAN in a medium to large size environment. 2 years experience supporting Windows XP or Windows Vista. Working knowledge of MS Office, Symantec Antivirus, Internet Explorer, VPN, and remote access
67
SQL Server Database Administrator Weekend Shift Resume Examples & Samples
- Coordinates and participates in activities associated with production SQL Servers
- Provides assistance in resolving problems with production SQL Server databases and tracking SQL Server problems with internal Microsoft customers
- Use MS-SQL Server Management Studio (SSMS) to automated processes to implement database changes
- Create, maintain, backup/restore, tune databases for development, test, and production
- Position may require on call / after hour support
- Bachelors degree and 10 years of experience. Four additional years of experience may be substituted for degree
- Minimum 5+ years recent experience supporting SQL Server Production databases in an enterprise environment
- Proven background and strong experience of database structures, theories, principles, and practices
- Experience with Database Administration for MSSQL Server (2008 and 2012, 2014)
- Knowledge of MS Analysis Server
- Ability to implement MS SQL Server solutions to build database systems that are high quality, scalable and high performance
- Must be familiar with backup/recovery strategies, distributed databases, data migration, security and SQL error handling
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server and Oracle
- Experience working with multiple instances of SQL are needed including 2008 R2/2012, 2014
- Knowledge and past exposure to SPLUNK
- SQL Server Certifications – MCSE 2008, 2012, 2014
- Proven, past experience with SPLUK in a large environment
- Application and Database Development
- Local to the Raleigh, NC area. This position does not have relocation assistance
68
Senior SQL Server Database Administrator Resume Examples & Samples
- 4) Good written and oral communications
- Has 8+ years of experience in database administration and support in MS SQL Server environments
- Strong experience in Database Administration in SQL Server (2008,2008R2,2012, 2014)
- Strong experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc
- Strong experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
- Strong knowledge of backups, restores, recovery models, database maintenance tasks
- Solid hands-on experience in SQL HA solutions like SQL Clustering, ALWAYS ON, Database mirroring and Replication technologies
- Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SSCM, PerfMon, DMVs, SSRS, SSAS)
- SQL Development – ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
- Solid acquaintance with windows server, Clustering, security delegation, SPNs, storage components
- Deploy and support SSIS and DTS packages
- Strong experience database upgrades from one SQL version to another SQL version
- Troubleshoots and restores complex issues through the use of technical abilities and tools
- Provide 24 x 7 system database administration support for all of production and remote site systems
- Ensures stability and reliability of infrastructure components through proactive maintenance and incident resolution
- Improves and automates tasks associated with building, configuring, patching, and upgrading core infrastructure platforms, hardware, and software
- Operation and maintenance of core infrastructure platforms and cross-platform integration support
- Implements new infrastructure components in a systematic manner adhering to established standards
- Continual service improvement of infrastructure platforms
- Good communication and writing skills. Able to handle change, incident and outage calls
69
Senior SQL Server Database Administrator Resume Examples & Samples
- Bachelor's degree OR equivalent combination of education/experience combined required (one year of education equals one year of experience)
- Strong working knowledge of SQL Server database administration required, to include installation/configuration/upgrade/migration of databases, user security, auditing, backup/recovery, capacity planning, monitoring, troubleshooting, and performance tuning
- Microsoft Transact-SQL ad-hoc query writing required
- Basic knowledge of ETL processes required
70
Senior SQL Server Database Administrator Resume Examples & Samples
- Understand CCC's business, business systems, and impact of infrastructure on business operations
- Install, maintain, upgrade, troubleshoot, test, and support database technologies on SQL Server
- Ensure that databases systems are implemented to meet CCC's internal and external standards and service level requirements
- Ensure databases are replicated and backed up to meet CCC's operational and disaster recovery requirements
- Perform database hygiene and maintenance to ensure optimum performance
- Provide problem-solving expertise and coordination as required across all technologies implemented at CCC
- Tune databases for optimal performance
- Document database designs and related processes
- Fulfill availability and service level objectives associated with the systems
- Participate in 24x7 DBA on-call support rotation
- Lead and participate in technical incident calls to restore service related to application and infrastructure problems in production environments under time-bound situations
- Perform others duties as assigned
- Minimum 5-7 years’ experience in 2012 and higher, SQL Server database administration
- Minimum 5-7 years information systems experience in a large enterprise systems environment supporting mission-critical systems and applications
- A high degree of demonstrated technical excellence across multiple database technologies and computing platform technical specialties
- Excellent problem solving skills across multiple disciplines
- DBA experience with Windows Clustering is required
- Experienced across one or more database technologies, e.g. SQL Server, MySQL, Oracle
- Expert level skills in database installation, maintenance, and upgrades
- Strong skills in database tuning, performance management, and database reorganization
- Solid skills in backup and recovery of databases
- Secure skills in data base recovery in a disaster recovery environment
- Expert SQL and scripting skills
- Data modeling and design experience
- Application design and development experience
- Experience with SSIS / SSRS desired
- 1+ years Always On/High Availability DBA experience is a plus
- Basic project management and team coordination skills
- Takes ownership of problems and/or issues and ensures timely resolution
- Proactively identifies opportunities for improvement of the computing environment