SQL DBA Resume Samples
4.7
(102 votes) for
SQL DBA Resume Samples
The Guide To Resume Tailoring
Guide the recruiter to the conclusion that you are the best candidate for the sql dba 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.
NH
N Heaney
Newell
Heaney
22380 Bruce Avenue
San Francisco
CA
+1 (555) 118 1688
22380 Bruce Avenue
San Francisco
CA
Phone
p
+1 (555) 118 1688
Experience
Experience
Boston, MA
SQL DBA
Boston, MA
Durgan-Lakin
Boston, MA
SQL DBA
- Create and establish working partnerships with various technology, business groups, Application Development and Engineering teams across the enterprise
- Establish, document and maintain standard frameworks and procedures for the development and management of IT Infrastructure
- When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes
- Works with supporting network, server and disk storage teams to facilitate managed, balanced systems
- Assess and perform systems utilization and headroom reports to assist in troubleshooting and performance tuning
- Assist the software development team in managing performance issues in all custom code released to the production environment
- Identify performance problems and modify databases to improve performance
Philadelphia, PA
Ms SQL Dba
Philadelphia, PA
Powlowski, Medhurst and Boyer
Philadelphia, PA
Ms SQL Dba
- May make hardware or software purchasing recommendations regarding web development
- Assist with development of standards and policies around data /access security (end-user access vs dev access)
- Manage and execute daily operational jobs including backups, index/statistics updates and defrags
- May develop a range of products including device drivers, patches, operating system modifications, graphics modules, etc
- Handling tickets/tasks and troubleshoot and Provide resolutions
- Finding DMV queries to answer questions about server-level performance
- When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
present
Houston, TX
Senior SQL DBA
Houston, TX
Daniel, Hermann and Kris
present
Houston, TX
Senior SQL DBA
present
- Develop and document standards, policies, procedures and key performance metrics that support the continued improvement of IT services
- Work closely with project managers, application developers, and system administrators on new and ongoing IT projects
- Assist system DBA team by performing backup, recovery and archival tasks on databases management systems
- Assist with Windows Server configuration and management as it relates to MS SQL Server installation and performance
- Provide support and guidance to Application Developers in creation of stored procedures and other database objects to ensure quality and high performance
- Provide support and technical expertise to development, QA and other teams
- Assist developers with all the database activities
Education
Education
Bachelor’s Degree in Computer Science
Bachelor’s Degree in Computer Science
Johnson & Wales University
Bachelor’s Degree in Computer Science
Skills
Skills
- Strong analytical and problem solving skills with ability to clearly articulate solution alternatives
- Expert knowledge and strong experience in Database Administration in SQL Server 2012 and SQL Server 2008 R2 and some exposure to SQL Server 2014
- Perform quality checks on reports and exports to ensure exceptional quality
- Knowledge of high availability solutions such as Mirroring, Replication, Clustering, AlwaysOn
- 3) The ability to automate with Powershell. Ability to execute T-SQL scripts
- Ability to maintain and monitor availability, security, and integrity of databases
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server
- Detail oriented and highly organized
- Strong MS Outlook, Word, Excel knowledge
- Expert knowledge and strong proven experience in MSSQL Database Administration
15 SQL DBA resume templates
Read our complete resume writing guides
1
SQL DBA Resume Examples & Samples
- Experience with Oracle 11g (or higher) or Tandem NonStop SQL
- Experience with supporting and developing SSIS packages
- Experience with Oracle Golden Gate or Data Integrator (ODI)
- Experience with IBM Optim
2
Senior SQL DBA Resume Examples & Samples
- Troubleshoot database performance issues
- Participate in database requirements gathering for new database projects
- Participate in the design and implementation of strategies for database load and stress testing
- Participate in after hours support on a rotational basis
- Five or more years of experience as SQL Server DBA in a production environment, including
- Experience in database logical/physical design, tuning, and query optimization
- Experience with change management procedures
3
SQL DBA Resume Examples & Samples
- Bachelor’s degree in Computer Science or a related field, or a combination of relevant education and experience
- Ten years of experience in an enterprise environment
- Experience patching, installing, and monitoring SQL Server in clustered environment
4
My SQL Dba Resume Examples & Samples
- Solid understanding of MySQL internal architecture, demonstrated experience with MySQL database design, implementation, performance tuning, and capacity planning
- Experience with enterprise backup and recovery strategies
- Hands on experience with designing and implementing database replication strategies
- Possess creative ability, credibility, self-confidence and independence
- Good team player with strong analytical, communication and troubleshooting skills
5
Am-microsoft SQL Dba-associate Resume Examples & Samples
- 5 + years of Information Technology experience are a requirement with three or more years MS-SQL SE/EE on Windows platform experience
- Working knowledge of Windows O/S systems administration tasks
- Familiarity with Microsoft SSIS, SSAS, and SSRS database support systems and possess version upgrade experience (SQL 2005/2008/2012 pending)
- Proficient production support skills with the ability to understand the impact of a problem on overall DB performance
- Mid-level DB performance tuning, replication, monitoring and best practices processes
- The successful DBA will possess strong analytical ability, judgment and problem analysis techniques
- Successful experience as a member of a project group
- Data modeling, data entity analysis, and application database design skills may be required
6
SQL DBA Resume Examples & Samples
- Ensure all database servers are backed up, restores tested, and backup/restore meets recovery time objectives
- Install and configure new Microsoft SQL Servers; choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies
- Understanding of DMVs to assist with server level performance and configuration
- Setup and maintain Microsoft SQL Server databases as requested, based on established corporate standard database schemas
- Analyze, resolve and document findings in support of reported database issues
- Ensure Microsoft SQL Server meets security best practices, assist with security audit collection for SOX and PCI
- Support developers in coding scripts, stored procedures and triggers
- Participate in the development and production release processes
- Develop, analyze, interpret and/or maintain database design, architecture, and systems documentation
- On-call support rotation for 24/7 production datacenter environment as required
- Candidate must have experience with troubleshooting Microsoft SQL Server 2005 through 2012 issues including performance (blocking, query optimization), query failures (deadlocks, exceptions), SQL Job Agent failures, and mirroring/replication failures
- Experience in performance tuning, query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
- Knowledge of backups, restores, recovery models, database de-frag operations, Dynamic Management Views (DMV), DBCC commands, Clustering, Database mirroring, Replication, and Always-On availability
- Must know TSQL and have experience in automating tasks through scripting
- Experience writing stored procedures, functions, and triggers
- Self-motivated with ability to prioritize and execute tasks in a high-pressure environment
- Excellent written and verbal communications skills with experience in creating database design and deployment diagrams and documents
- Ability to work independently with little supervision and drive projects to completion
- Prefer a Bachelor Degree in Computer Science, Business Information Systems or related degree
7
SQL DBA Resume Examples & Samples
- Efficient SQL scripting skills
- Strong DB management skills incorporating backup and recovery best practices in a high-availability environment
- Up-to-date understanding of PII Security standards and impacts to security modeling
- The successful DBA will possess strong analytical ability, judgment and problem analysis
- Demonstrated initiative, good judgment, and the ability to work in a team
- Ability to independently provide project cost and time estimates for database related tasks
8
GTI Gso-ms SQL DBA Resume Examples & Samples
- Represent the GSO operations teams in all Service and Service Component Optimization Reviews to provide the operational perspective as well as understanding the impact of service issues and strategic decisions to the business. Provide and/or confirm operational statistics, e.g. SLA achievement, as appropriate
- Ensure outcomes from the Service and Service Component Optimization Reviews and related interactions are appropriately communicated across the management team
- Ensure appropriate operational capabilities are included in the definition of Database services
- Recognize and facilitate the escalation of operationally high impact services operation profiles to the respective teams
- Assist the service teams in evolving services to better enable efficient infrastructure operations and align service investments
- Facilitate continuous improvement of service operation capability through a combination of metrics, reporting, influence across GTI GSO
- Minimum of 7+ years experience administering various multi-Terabyte, 24x7 uptime Oracle databases as a Systems/Infra DBA
- Strong experience working with Oracle versions 10gR2, 11gR1/2, 12c in a UNIX environment
- Experience with features such as Oracle Real Application Clusters (RAC), ASM, Active Data Guard and Oracle Enterprise Manager (OEM)
- Programming experience in PL/SQL and UNIX Shell Scripting and/or Perl (preferably) added advantage
- An extensive knowledge in Oracle OEM is a plus
- Extensive IT service management experience
- ITIL Foundation Certification (V2 or V3)
- Broad technology exposure including networks, distributed servers, mainframe servers, SAN/NAS storage, virtualization, messaging, databases, and all major operating systems
- Understanding of complex technology planning, implementation, and operations issues
- Excellent management skills required, including problem solving skills, ability to motivate others, negotiation skills, conflict resolution skills, and financial management
- Ability to work well in a pressured, dynamic environment
- Ability to escalate critical and/or complex issues as required and in a timely fashion
- Ability to solve operational issues with operational, tactical and strategic solutions
- Excellent skills in time management and personal task prioritization
- Strong planning skills, including the ability to plan multiple teams' workloads and priorities, as well as the ability to deliver to agreed schedules
- Excellent Financial, Service Level management and written and oral presentation skills
9
SQL DBA Administrator Resume Examples & Samples
- 365) to IBM clients worldwide. Key services offered include: Command Center Services (includes remote monitoring of servers located worldwide from India, Security operations and network operations), Server Systems Management, IT Security Services, IT Service Desk, Service Management & Project Management/ Transition Services
- This role will require you to be accountable for individual or team results
- Drawing from relevant experience, this role will require you to be viewed as a technical expert; give technical direction; demonstrate working knowledge of key functional processes; share information and expertise with individuals and teams
- Prioritize work within well established procedures and objectives
- Perform and apply new technical procedures; demonstrate ability to negotiate; work individually or as a team member
- Good experience in SQL Server RDBMS architecture concepts, Usage of System catalogs on Query Analyzer
- Space management including File groups, Managing Transaction log files, User management, Backup and recovery methods using Enterprise Manager and Query Analyzer
- Logical backup and recovery using export/import from one instance to another, SQL network configuration ( using Server / Client Network utilities), Database performance tuning, Trouble shooting database issues, Basic SQL and T/SQL knowledge
- Working knowledge of Windows (Windows 2000, Windows 2003)
- Working Knowledge of SQL Server Cluster
- Desirable, Knowledge of SQL Server 2005, Use of problem and change management tools Soft Skills
- Must have proven team working skills balanced with ability to work alone and a positive attitude, Customer focus
- At least 4 years experience in SQL DBA
10
Global Services Operations SQL DBA Resume Examples & Samples
- Lead data requirements, architecture review, and modeling sessions
- Providing first-class database support and administration
- Experience with Polyserve SQL server clusters with multiple nodes on each cluster mirroring and other methods of disaster recovery
- Experience with SSIS packages, SSRS and SSAS
11
SQL Dba Eis Resume Examples & Samples
- Provide production support to various Microsoft SQL database environments across the bank
- Develop maintenance regimes
- Expert in tasks automation
- 6+ years' experience
- Solid MS SQL experience, Sybase is a plus
- In-depth knowledge in building infrastructure ("setting up shop") for large databases
- In-depth knowledge in different disaster-recovery and warm-backup schemes, procedures, and implementations
- Scripting language (PowerShell, ksh, Perl)
12
SQL DBA Resume Examples & Samples
- Development of Enterprise Reporting Solutions by reaching out to various levels of the business to gather requirements, understand the data available, and provide reports that help the business make critical decisions
- Responsible for configuring and maintaining SQL Server Reporting Services
- Responsible for creating and maintaining reports using SSRS
- Responsible for creating and maintaining SSIS packages for ETL processes
- Responsible for performance tuning reports and SSIS packages
- Responsible for monitoring alert logs, dump files and other logs for errors
- Promote SSRS, SSIS and stored procedures from to stage and production environments
- Understand and apply BI design considerations to existing and new data marts in support of enterprise reporting and analytics
- Bachelor’s degree in Computer Science, Information Technology, Business Administration, Engineering or a related field
- 3-5+ years’ experience with SSRS, SSIS, OLAP
- 3-5+ years’ experience in a Microsoft SQL Server environment
- 3-5+ years’ experience with SQL Server 2005, 3+ years’ experience with SQL Server 2008
- Experience in physical data modeling
- Expert knowledge of Transact SQL
- The following skill levels are a plus
13
SQL DBA / Developer Resume Examples & Samples
- Administering the production SQL Server estate
- Installations and upgrades of SQL Server
- Planning for storage requirements, present and future
- Maintenance of system/db security
- Planning for backup/recovery of the database
- Backup and restoring of databases
- Offering technical guidance for database design and performance tuning
- Design and develop data systems making specific determinations about system performance
- Documentation of database design, procedures, best practices for the development team
- Interface with the product application development w.r.t. data requirements
- Work with key stakeholders as necessary to support BI reporting
- Liaise with the Information Services team to ensure consistent application of database best practises
- Contribute to all aspects of general business improvement
- Maintain the company's reputation for high-quality service support and delivery
- Be part of the out of hours support for the operations team once suitably skilled
- Expert knowledge of Database design, indexing, tuning, capacity planning, database best practices
- Expert knowledge of RDBMS
- Expert knowledge of Distributed architectures
- Expert knowledge of storage technologies, memory management, networking
- Expert knowledge of Replication, High Availability & Mirroring - setup and trouble shooting
- Strong Experience of SQL
- Strong Experience of SQL Server 2008 R2 and 2012, 2014
- SSIS and SSRS implementation and management
- General understanding of financial services, especially mutual funds desirable
14
SQL DBA Resume Examples & Samples
- 5 yrs. SQL Server experience in a large enterprise SQL 2008 R2/2012/2014
- Knowledge and basic understanding of the Oracle Database
- Hands-on experience designing and supporting high availability SQL solutions (SQL Clustering, Mirroring, Log Shipping, Always-On, etc)
- ETL experience (SSIS)
- Code review and performance tuning of SQL queries and stored procedures
- 5 yrs. Windows Server enterprise level experience
- Active Directory domain
- Client / Server network applications experience
- SQL replication a plus
- SSRS and Business Intelligence
- Previous experience with retail industry a plus
- Previous experience working with database monitoring tools and database monitoring standards preferred
15
Senior SQL DBA Resume Examples & Samples
- Owning, tracking and resolving database related incidents and request, fulfilling requests and resolving incidents within SLAs
- Reviewing service related reports (database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs
- Responding to database related alerts and escalations and working with development team to come up with strategic solutions to recurring problems
- Support internal customers, such as Development, QA, Ad Operations, International and BI teams and be involved on data related projects
- Minimum 5 years experience with Database Administration for SQL Server (2012 or above)
- Experience in troubleshooting and resolving database problems
- Experience with SQL 2012 Always On High Availability (HA) and Disaster Recovery (DR) options
- Experience working with Window Server, including Active Directory and proper disk configuration for SQL Server
- Involvement with SQL Server Community, Membership in PASS, Active in Forums/Newsgroup
- Uphold and evangelize Allrecipes core culture values and the Allrecipes brand values in every day responsibilities
- Be a problem-solver, not just a problem alerter. Problem alerters are a dime a dozen. It is easy to sit around and point out the flaws of any system, product or organization. Allrecipes needs problem solvers. Problem solvers are the real innovators in this world
- Be humble
16
My SQL Dba Resume Examples & Samples
- MySQL community and Enterprise Version 5x administration and support
- Monitoring MySQL databases using MySQL Enterprise Management or Oracle MySQL plug-in in Cloud Control
- Experience with Master/Slave replication setup, monitoring and tuning, MySQL Cluster (Multi-Master) setup, monitoring and turning and MySQL setup and monitoring in cloud such as AWS
- Customize MySQL installations for optimal and multi-instance configuration
- Plan, coordinate and administer matters related to MYSQL databases including definition, structure, documentation, upgrades, long-range requirements, operational guidelines and protection
- Review and make recommendations for tuning existing MYSQL environments
- Responsible for MYSQL administration, installation, and configuration servers in Linux platform, including load balancing, clustering and automatic failovers
- MYSQL Primary/Slave/Multi-Master tiers, Clustering, Local/WAN Replication, monitoring, performance tuning and optimization (required)
- Establish and maintain security integrity controls
- Required Monitoring experience with tools like MYSQL Monitor, Nagios, Myphpadmin
- Translate logical to physical design, develop comprehensive DB architectures, implementation and upgrade plans and assist in definition of database standards, policies, and procedures
- Create and manage large scale, highly available production databases under clustered environments/replicated environments
- Responsible for solving SQL performance related issues and optimizing poorly performing queries and stored procedures
- Strong Scripting-Ruby, Perl, Bash, Puppet, Salt, Python
- Responsible 24x7 production operations (incident management, service requests, change management and availability management) and On-Call pager rotation
- Bachelors in Computer Science or equivalent
- Minimum 5 years of experience with MYSQL database administration in a production /development environment with DevOps service development methodology. 3 years is a must in production environment
- Migration / Upgrade of the MySQL databases
- Experience with third-party tools such as Percona's XtraBackup, XtraDB Cluster is a plus
- MySQL relevant Certifications is an added plus
17
SQL DBA & Developer Resume Examples & Samples
- Database implementation and performance tuning
- Capacity and Performance planning, monitoring and reporting
- Determine any shortcomings with the Database system and recommending enhancements
- Advise developers on best practice and optimal approach in the use of Transact SQL
- 5+ years SQL Server experience
- Familiar with installation and maintenance of large-scale databases in Development, Test and Production environments
- Extensive experience of Transact SQL
18
SQL DBA Resume Examples & Samples
- Maintain, develop, test and document programs, scripts (DTS for example) to build an analytical database environment
- Follow accepted procedures to design and implement telemarketing projects from concept to completion. This includes involvement in reviewing proposals, collecting business requirements, writing project plans, and working with other department staff/managers to develop necessary applications
- Build, develop, test and document program scripts to streamline the extraction and analysis in the telemarketing database
- Use approved programming languages and methodology to design and build the applications to track time, and communicate to supervisor all pertinent information regarding projects status
- Stay current with analytical database design theory and techniques
- Responsible for adhering to safety procedures, ensuring a safe work environment and reporting injuries to determine cause and take necessary preventative action
- SQL Server developer experience using version 2008 or later
- T-SQL skills (stored procedure, function and trigger development)
- SQL Server data movement techniques including SSIS/DTS
- .NET scripting experience
- Bachelor's degree (B.A.) from four-year college or university plus 2 years practical experience; or four years related experience and/or training; or equivalent combination of education and experience
- Experience using Windows PowerShell to automate tasks
- Understanding of database performance tuning and optimization
- Experience writing reports, business correspondence and procedure documentation
- Ability to effectively collect business requirements, present information and respond to questions from groups of managers, clients, customers and the general public
- Ability to collaborate with others effectively. Must be able to work on tedious research data, sustain accuracy of database(s) and make corrections in a timely manner
- Must be able to read, write and speak English fluently
19
SQL DBA Administrator Resume Examples & Samples
- This role will require you to be accountable for individual or team results. Drawing from relevant experience, this role will require you to be viewed as a technical expert; give technical direction; demonstrate working knowledge of key functional processes; share information and expertise with individuals and teams
- Good experience in SQL Server RDBMS architecture concepts, Usage of System catalogs on Query Analyzer, Space management including File groups
- Managing Transaction log files, User management, Backup and recovery methods using Enterprise Manager and Query Analyzer
- Logical backup and recovery using export/import from one instance to another, SQL network configuration ( using Server / Client Network utilities), Database performance tuning
- Trouble shooting database issues, Basic SQL and T/SQL knowledge, Working knowledge of Windows (Windows 2000, Windows 2003)
- Desirable, Knowledge of SQL Server 2005, Use of problem and change management tools
- Soft Skills, Must have proven team working skills balanced with ability to work alone and a positive attitude, Customer focus
20
Senior SQL Dba-relativity Services Resume Examples & Samples
- Outstanding customer service skills
- 3-5 years of prior DBA experience supporting the Relativity platform in an e-Discovery environment
- Deep technical understanding of the Relativity architecture, SQL environment, and underlying hardware and network technologies on which these systems run
- Ability to diagnose and troubleshoot Relativity systems performance issues, regardless of root cause
- Strong experience in Database Administration and Development in SQL Server ( 2005/2008/2008R2/2012 )
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc
- Ability to work flexible hours to meet client inquiries and meetings as needed in a demanding, fast-paced, start-up environment
- Excellent organizational skills, follow-through and attention to detail
- Solid understanding of e-Discovery principles and requirements
- Effective management and delegation skills
21
SQL DBA Resume Examples & Samples
- Database design and provisioning
- Write database documentation, including data standards and procedures
- Build and support the existing and future IT technology function across the organisation
- Establish, document and maintain standard frameworks and procedures for the development and management of IT Infrastructure
- Evaluate, demonstrate & implement solutions to improve stability, availability, and management
- Automate tasks that can be provided to non-technical stakeholders for process improvement
- Manage the process for centrally maintaining the data dictionary (metadata)
- Contribute to the design, and actively participate in the management of a documented Business Continuity Plan in relation to high availability of databases
- Develop, manage and test database backup and recovery plans
- Work with IT Transformation Leader to ensure that database servers are adequately resourced, provisioned and architected
- Work closely with ICT support to provide 2nd and 3rd level support for the IT Server and database environment
- Monitor performance and manage parameters to provide fast query responses to back-end systems and front-end users
- Provide and maintain access permissions and privileges to support and operational users in accordance with security policies and monitor database access and security
- Report monthly on database changes, improvements, capacity and performance
- 8+ years' experience with a strong focus on database architecture, development, administration and support in MS SQL Server environments
- Strong experience in DB Admin in SQL Server (2005 and 2008) and Data Warehouse (MDW)
- 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 shrink operations, DBCC commands, Clustering, Database mirroring, Replication
- Documentation skills for processes and procedures
- Flexible and Adaptable
22
SQL DBA Resume Examples & Samples
- Expert knowledge and strong proven experience in MSSQL Database Administration
- Skill to organize and follow complex and/or detailed technical procedures
- Ability to solicit relevant information from incident and service request in order to sufficiently describe problems to internal partners and effectively communicate solutions and status
23
SQL DBA Resume Examples & Samples
- Responsible for T-SQL development – includes database design and writing stored procedures as part of day-to-day work
- Work to ensure that the associated hardware resources allocated to the databases and to ensure high resilience and performance tuning
- Responsible for troubleshooting and problem solving of T-SQL development
24
SQL DBA Resume Examples & Samples
- Build, maintain and support the company database estate to include core database installation, configuration and upgrade, as well as implementing and maintaining advanced high availability, security and performance tuning
- Provide database expertise to new development projects, participating as a pro-active team member throughout all lifecycle stages from initiation through implementation and post-implementation support
- Provide comprehensive and clear documentation for all new database builds, redevelopments, enhancements, as well as for standard operational procedures
- Respond to support incidents and requests in a timely and efficient manner
- Participate in on-going development of our client's policies, procedures and standards for database builds, administration, backups, security and auditing
- Actively participate in discussions and workshops with other I.T. Team members, sharing knowledge and experience, so as to continue providing a high quality of service while striving for continuous improvement
- Provide leadership and strategic direction by fostering collaboration and best practices for database management across the organization
25
SQL DBA Resume Examples & Samples
- Troubleshooting database performance issues and query tuning
- Relevant Experience should be more than 2 Years
- Should have worked in Database Refresh Scenarios and Orphaned Users
- Should have experience in troubleshooting database performance issues and query tuning
- Experience in ITIL would an added advantage
- Should have understanding about the database auditsERBP
26
Oracle / SQL DBA Resume Examples & Samples
- DBA administration tasks on all databases including high availability 24x7
- Backup & Restore Procedures and testing
- Database Configuration
- Database, Application Server Monitoring
- Housekeeping Tasks & Space Management
- Database & Application Server (e-business) Upgrades
- Perform application/database tuning and performance monitoring
- Work as part of a team and provide 24x7 supports when required
- Experience using Microsoft Clustering technologies and Virtual or Cloud platforms
- Oracle e-business suite administration
- Cloning, and version/change control
- Version/Change Control
- 3+ years hands-on experience as an Oracle DBA on Unix/Linux based systems (incl. physical Design for critical systems). OCP qualified preferable
- 3+ Years Microsoft SQL Server Experience on Microsoft clusters
- Thorough knowledge of Oracle RDBMS 11g and 12c environments, including RAC, Data guard, RMAN etc
- Strong Knowledge of Database Backup and recovery using RMAN
- Strong knowledge of Oracle Database monitoring and tuning using stats pack and AWR
- Oracle e-business experience preferable
27
SQL DBA Resume Examples & Samples
- Installation, configuration and upgrading of Microsoft SQL Server 2008 and above
- Setting up New SQL servers, Databases and creating logins, users, schema for particular database
- Creation of Databases, Tables, views etc
- Experience with Backups, Restores and Recovery Models
- Establishing Database maintenance and Monitoring SQL jobs
- Design database Backup and Restoration Strategy. (Database Backups and SQL Server Agent)
- Implementing maintenance plan and scheduled SQL Job to perform rebuild indexes and check database integrity
- Provide security administration and maintenance such as create and maintain users , assigning privilege and permission on various database object like schema, stored procedure ,table,views,indexes etc
- Monitoring SQL services and Database connectivity
- Shrinking activity if log file increased (only for database log file)
- Memory settings, monitoring CPU usage and Disk I/O activity etc
- Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server Error Logs)
28
SQL DBA Resume Examples & Samples
- High Availability Cluster setup
- VMWare Site Recovery Manager
- Designing and improving Backup Strategies; Database restoration and roll back
- SQL Server performance enhancement; tuning and optimisation
- Database mirroring environments
- Virtualisation exposure (VMWare)
- Database scripting
29
Advanced Technical Specialist SQL DBA Resume Examples & Samples
- Act as an escalation point and manage incidents and problems related to application environments
- Ability to work well within a multi-disciplinary team structure, but also independently
- Demonstrable knowledge of Windows 2008/2012 server O/S
- Experience with data warehousing and operational data stores
- Function in a supervisory capacity for small, application/project scoped teams of varying levels of skills and experience, and geographically distributed in different countries
- 8-10 years of relevant work experience (Level 3 Support)
30
SQL DBA Resume Examples & Samples
- Perform database administration functions including; Security access, performance tuning, capacity planning, and database replication/backups for recoverability
- Perform installation, maintenance and upgrade to the new version of MSSQL databases; provide technical support for solving database/software failures
- Participate in projects, manage deadlines; provide status reports
- Experience troubleshooting performance problems, and performing application releases
- Experience with supporting multiple projects/tasks simultaneously
- MS Certifications a plus
- MS Analysis Services experience a plus
- Database monitoring and notification and sharing a 24/7 on-call rotation with other team members
31
SQL DBA / Developer Resume Examples & Samples
- Microsoft Certification highly regarded
- Strong commercial experience with Microsoft SQL Server Database Engine, SSIS, SSRS
- Solid knowledge of T-SQL
- Experience with SSMS, SSDT, offline database development
- Installing and configuring database systems, patches and upgrades
- Database administration of SQL Servers including Performance Tuning, Backup/Recovery and Security
- Support of development, test, and production database environments
- Detail focused
32
SQL DBA Resume Examples & Samples
- Plans, designs and implements networked systems, including configurations, and supports/troubleshoots network problems
- Designs, analyzes, plans, and modifies network components supporting customer communication implementation activities
- Prepares the analysis of the capacity needs for switching, routing transmission and signaling
33
Emeia Technical Lead SQL DBA Resume Examples & Samples
- Manage the daily operations of a SQL DBA team consisting of 6-15 staff
- Providing technical leadership
- Mentoring, coaching and assisting database staff
- Performing performance evaluations
- Development of Performance and Development plans for the team
- Participate in technical governance forums in areas of expertise
- Execution of application and/or platform changes, and service requests in supported environments
- Adhere to E&Y and ITIL guidelines for Incident, Problem, and Change Management
- Strong understanding of ITIL principles desirable
- Ability to develop and communicate technical concepts
- Demonstrated problem investigation and resolution skills
- Understanding of Project management concepts
- Involved in interviewing and hiring decisions for prospective staff
34
SQL DBA Administration Resume Examples & Samples
- Minimum 5 years of experience in a technical IT field
- 5+ Years of DBA experience
- SME for all database related processes including backup, recovery, database integration, mirroring, replication, optimization, migration, Database security, Auditing
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server
- Experience in implementing operational automation using scripts such as Powershell
- Experience in building SQL clustering, SQL always on, in-memory database, CDC
- Experience in SSIS,SSRS, SSAS
- Knowledge of Industry standard ETL and BI tools and exposure to data warehousing architectures
35
SQL DBA Resume Examples & Samples
- 5 years experience working as a DBA
- 2 years experience with Microsoft SQL Server 2008 R2
- Should be able to create and monitor databases
- Good database querying skills writing SQL
- Create Backup / recovery of databases
- Ability to write procedures in SQL Server
- Knowledge of Disk space and memory management in SQL server
- Data Modeling skills preferred
- Experience to change users and user privileges
- Knowledge of Database security
- Should be willing to be on call during weekends /nights
- Experience performing upgrades between versions, especially 2008 to 2010/2012
- Experience working with Extract, Transform, and Load ETL tools such as IBM DataStage
- Experience working with Business Intelligence BI tools such as IBM
- Experience working with Business Intelligence BI tools such as IBM Cognos
36
SQL / DBA / Ssrs Administrated Resume Examples & Samples
- Bachelor’s degree in related field (i.e. Computer Science) or an equivalent combination of education and highly relevant experience required
- (Preferred) MCTS, MCITP, and MVP certifications
- Experience with Database Administration for MS SQL Server
- Proficient with troubleshooting and resolving database issues
- Expertise with database indexes, index management, and statistics
37
SQL DBA Resume Examples & Samples
- Owning, tracking and resolving of database related incidents and requests
- Fulfilling of requests and resolving incidents within SLAs, and reviewing service related reports (e.g: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs
- Responding to database related alerts and escalations and working with the database team to come up with strategic solutions to recurring problems
- Experience with MSSQL Server
- Experience of other Database technologies eg Oracle etc. is a distinct advantage
- Experience in Unix OS is desirable
38
Senior SQL DBA Engineer Resume Examples & Samples
- Develop and maintain standards, procedures, and methodologies to ensure effective operation, access, control backup and recovery of all database systems. (15%)
- Oversee the migration of database structures from development and QA environments into the production environment. (15%)
- Install, configure, and administer database management clustered systems, utilities, and tools in MS SQL environments. (10%)
- Manage all environments and report capacity and performance results to senior management. (10%)
- Provide expert level technical expertise and perform tasks for all related infrastructure projects, including business continuity and disaster recovery. (10%)
- Provide expert level support for production, QA, and development database (24x7). (10%)
- Provide leadership, mentoring and training to other department team members. (10%)
- Lead technical evaluations, POCs and/or technical recommendations within their discipline. (10%)
- Enforce, manage and create policies and procedures. (5%)
- Work closely with business and IS associates and outside vendors to effectively plan, deploy and update database environment additions and changes. (5%)
- Expert level proficiency with SQL server databases
- Expert level knowledge of relational database design, testing and implementation
- Solid understanding of storage area networks and network attached storage environments
- Excellent project management and documentation skills with great attention to detail
- Advanced level knowledge of the Data Models
- Must possess a strong work ethic and the ability to effectively multi-task in a fast paced support environment
- Ability to support and troubleshoot complex service impacting issues with little to no supervision
- Expert level knowledge to assist in engineering solutions that cross technical domains
- Advanced communication and professional skills and the ablility to establish relationships across business units
- Ability to mentor, train, and assist in developing associates
- Excellent organizational skills with the ability to handle multiple tasks
- Advanced scripting, stored procedure, and TSQL skills
- Basic level proficiency with Oracle databases
- Ability to lead technical evaluations, POCs and/or technical recommendations within discipline
- Ability to read and interpret documents such as safety rules, operating and maintenance instructions, and procedure manuals
- Ability to effectively present information and respond to questions from peers or management
- Ability to effectively lead major project efforts as a discipline resource
- Ability and willingness to continue building technical knowledge and skills
- Understanding of WAN/LAN concepts
- Advanced experience supporting core Scottrade Trading Systems and key internal Scottrade systems preferred
- Bachelor’s degree in information technology or equivalent combination of education and experience required
- 6+ years experience in Microsoft Operating Systems and SQL clustered environments required
- 6+ years experience in a SQL server database administration support role required
- 5+ years experience supporting geographically dispersed production environments preferred
- 4+ years experience supporting high availability and disaster recovery (DR) strategies preferred
39
SQL Dba-kendall, FL Resume Examples & Samples
- MS SQL Server upgrades, Service Pack, Hot Fix installs and implementing new features
- Work with Domain Administrators on storage strategies for backup and recovery of complex database environments for Disaster Recovery
- Uphold Enterprise policy guidelines and recommend new/improved guidelines
- Partner with project teams and interact with customers to find solutions for projects and operational issues for existing and proposed database environments
- MS SQL Server Replication set up, maintenance and troubleshooting in Domain and non-Domain environments
- Ensure a stable and secure database environment as per established SLA’s
- Act as business liaison serving as primary point of contact between application business segments and database administrators
- Responsible for all functions associated with the design, implementation and maintenance of the MS SQL Server databases including security, backup, logging, reporting and recovery
- Perform daily, weekly and monthly data maintenance tasks
- Maintain connectivity to MS SQL Servers for end users, developers, reporting and batch processing
- Provide on-call support for after business hours issues
- Documenting current and new procedures/features
- 4+ years of relational database experience, Data Modeling (Physical/Logical) experience in a complex, enterprise environment
- 4 + years of experience working with Application and/or System Database Administrators and development teams
- Possess a solid understanding of the relationships of architecture components within technology infrastructure
- Knowledge of customer service standards and procedures
- Possess a solid understanding of the relationships of architecture components within the company’s technology infrastructure
- Expertise with the following technologies: SQL Server 2005, 2008, 2012 SQL Clustering, Replication, SSIS, SSAS, SSRS
- Understanding of application of technology utilized to support multiple and complex business areas
- Intermediate proficiency with MS Visio
- Healthcare Industry experience desirable
- Experience with Data Warehouses and/or Data Marts desirable
- SQL certification
- Experience using case tools, such as ERWIN, SAN Storage, OLTP processing environment, and supporting RAID level configuration
40
My SQL Dba Resume Examples & Samples
- High Availability or Disaster Recovery Logs – Check your high availability and/or disaster recovery process logs. Depending on the solution (Log Shipping, Clustering, Replication, Database Mirroring, CDP, etc.) that you are using dictates what needs to be checked
- We can design a native scripts using T-SQL to monitor Replication, Mirroring, Log shipping
- Monitor logshipping and mirroring using the customized stored procs
- In most of the environments we see third party tools in monitoring Clusters
41
Senior SQL DBA Resume Examples & Samples
- Ensure all database servers are backed up
- Experience with installing, configuring and supporting SSRS, SSIS and SQL Broker Services
- Complete understanding of High Availability using SQL Cluster, Active-Active, Active-Passive and DR technologies using log shipping and Availability Group
- Extensive working knowledge and experience managing maintenance plans and jobs for backup and recovery, database maintenance jobs, ability to write T-SQL scripts to automate integration and repetitive tasks
- Familiarity with managing SaaS environment
- Be part of on-call rotation supporting 24x7 production environment
- Bachelor’s or Master’s degree in computer science or related field with a minimum of 8 years as SQL Server Administrator
- MS SQL Server Certification preferred
- Excellent communication, presentation, and people relationship skills
- “Can-do” attitude with pro-actively taking measures to prevent problem conditions
- Strong drive for meeting deliverables and understanding strategic priorities to meet the business needs of the organization
42
SQL DBA Resume Examples & Samples
- Establish best practices and SOPs
- Generate clear and concise documentation
- Provide on-going communication of status of projects and implementation
- Dimensional modeling using data modeling tools like Erwin
- Lead and participate in database design review sessions
- Partner with the Service Management team to establish sound handoffs and detailed documentation standards before new builds are accepted into the production environment. Partner with the Service Management team to establish sound handoffs and detailed documentation standards before new builds are accepted into the production environment
- B. S. degree in Information Technology, Computer Science or other technical disciplines
- Minimum 8 years administering SQL Server 2000
- Minimum 4 years administering SQL Server 2005
- Minimum 3 year production experience administering SQL Server 2008 R1/R2
- Minimum of 6 years instance level troubleshooting and performance tuning
- Minimum of 6 years managing VLDBs
- Minimum of 4 years general administration (optimization/installation/configure)
- Minimum of 4 years administering Windows 2003 R2
- Minimum of 2 year administering Windows 2008 R2
- Minimum of 5 years managing SQL Server clusters (active/passive, active/active)
- Minimum of 3 years experience in administering SSRS (SQL Server Reporting Services)
- B.S. degree in Information Technology, Computer Information Systems, Computer Engineering or other technical discipline
- Ability to convert UML models into ERWin physical models
- Experience with Windows and Linux/UNIX environment
- Ability to learn Oracle, MySQL, SYBASE and Teradata is a plus
43
Ms SQL Dba Resume Examples & Samples
- Installing/maintaining/upgrading SQL Server instances/databases of SQL Server 2008, 2008R2, 2012, 2014 stand-alone/cluster servers
- Hands on experience and Expert level knowledge in AlwaysOn/SQL Clustering installations, configurations and administration
- High-end support and must have experience in Citrix database environment
- Experience with Patching MS SQL Servers in stand-alone/clusters and DR environment
- Monitoring MS SQL Server health, Performance tuning, Physical Server Level (CPU, RAM/IO), Database level (Database settings and options), high availability and reliability of the database application environment
- Maintain and troubleshoot multiple types of high availability/DR techniques such as clustering, database mirroring, Log shipping, hot standby servers, etc., fail over and DR testing
- Investigation of the root cause and coordination for any outages, must have solid communications skills and be comfortable leading meetings as needed
- Work hand-in-hand with Application owners, customers and software vendors to resolve issues in a timely manner
- Handling tickets/tasks and troubleshoot and Provide resolutions
- Experience of working within an ITIL framework and following standards and guidelines per ITIL process, SR, Incident and CR, CAB meetings etc
- Experience in Managing Security of SQL Server by creating Database Users, Roles and assigning proper permissions according to business requirements
44
MS SQL DBA Administrator Resume Examples & Samples
- Plan and organize database activities regarding reliability, performance monitoring and tuning, security, backup and disaster recovery
- Participate in long term planning for software and hardware upgrades
- Work with Project Managers to allocate DBA resources
- Work with analysts to understand business needs
- Participate in cross-team and cross-project implementations
- Translate logical data models into physical database designs
- Develop physical databases
- Assist System Engineer in the design of highly available and redundant storage area networks
- Establish information flows
- Develop and maintain enterprise data documentation and metadata models
- Develop and provide database requirements to system administrators
- Design, monitor and maintain data replication primary and secondary databases
- Develop, test, maintain, and exercise procedures for backup, restoration and disaster recovery for high availability, high volume mission critical databases
- Design, code, edit, install and verify stored procedures and functions for accessing, maintaining, and populating databases
- Recommend and implement Database solutions to support data integrity efforts
- Design and implement required security controls are designed around data and databases
- Participate in projects that require testing and produces metrics and samples for further analysis
- Ensure optimal database performance and availability
- Monitor utilization for capacity planning
- Troubleshoot and resolve applications (ex., SQL) performance issues
- Forecast utilization patterns and recommends modifications or upgrades
- Propose and implement enhancements to improve system performance and reliability
- Conduct application transaction volume and traffic analysis, and interprets the impact on database performance
- Maintain development, production, and multiple testing environments
- Oversee the upgrades of databases, adding new structures or elements
- Provide, evaluate and develop data access tools and techniques
- Direct the scheduling of DBMS software installs
- Build scripts automating the daily operations of database management
- Monitor transactions between application systems and the database for the purpose of identifying and improving inefficiencies
- Maintain and monitor database security, integrity and access controls
- Control privileges and permissions to database users
- Provide audit trails to detect potential security violations
- Make recommendations to improve security
- Participate in security investigations as needed
- Assure that appropriate information security is applied in all tasks
- Provide production support/database access 24 hrs x 7 days a week and ensures high availability
- Conduct Level 2 and 3 support
- Troubleshoot databases accessibility, availability or operability problems
- Determine the appropriate course of actions for problems, identifies and mitigates risks, and implements solutions
- Escalate/communicate issues when necessary
- Assist in establishing and supporting enterprise policies, processes, and standards. Ensure standards are adhered to
- Monitor performance against service agreement levels
- Participate in the developing SLAs
- Ensure that operating level agreements are met with internal/external customers
- Provide performance feedback to managers
- Evaluate future technologies and makes recommendations for software and hardware upgrades and technology solutions
- Bachelor’s degree in programming/systems or computer science, information systems, specialized training, certification,
- Typically requires 5 or more years of database administration experience working with various database management
45
My SQL Dba Resume Examples & Samples
- Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix etc
- Design database Backup and Restoration Strategy
- Setup High-Availability as part Disaster Recovery Strategy for the Databases
- Troubleshoot various problems that arise in a day-to-day work and fix the issues
- Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning
46
Software Engineer SQL DBA Resume Examples & Samples
- Oracle and SQL DBA to perform database server hardware evaluations
- Installations of database software, database upgrades, plan new databases,
- Develop disaster recovery plans for databases, and tune databases for optimal performance
- Ensuring software solutions meet performance, manageability and reliability requirements in a cost effective and maintainable manner
- Developing product/solution architecture collaboratively with System and Solution Architects to meet business specifications
- Converting business requirements to functional requirements to support the development of components, products and applications
- Maintenance & support of existing software tools - involving problem characterization, debug, change management, upgrades
- Interfacing with Third Party vendors and ISG R&D Teams to support Third Party application installations and integr
47
SQL DBA With Call Recording Exp-plymouth, MN Resume Examples & Samples
- Provide support and maintenance of UnitedHealth Group's contact center infrastructure and applications with an emphasis on the Contact Center Application NICE call recording platform
- Incident and problem management, planning and execution of maintenance activities, patches/fixes, infrastructure builds, and serving as an application SME to related projects
- Overseeing the organizational storage of data, creating and modifying databases, managing database security, troubleshooting problems and incident tickets
- Applications Support Management
- Undergraduate degree or combination of education and experience
- 2+ years of experience with application or infrastructure support
- 2+ years of experience working with Call Center Technologies
- 2+ years of experience SQL Server querying
- 2+ years of experience SQL Server programming
- 2+ years of experience with SSRS
- NICE Call Recording Application Experience
- Proven ability to learn quickly
- Strong technical, analytical, and problem solving skills
48
SQL DBA Administrator Resume Examples & Samples
- Minimum of 5 years of experience in a technical IT field
- May require experience in designated systems or software
- May require software certifications
- Experience with Database Administration for MS SQL Server (eg: SQL 2008R2, SQL2012, SQL2014)
- Experience in Performance Tuning and Optimization (PTO), using monitoring tools such as Foglight and troubleshooting tools
- Experience in Database Encryption
- Experience in Database audit procedure
- Experience with logical and physical data modeling
- Ability to multi-task between different activities and teams
- Provide 24x7 support for critical production systems on an on-call rotation basis
49
SQL DBA Resume Examples & Samples
- Experience implementing and troubleshooting Microsoft SQL Server 2012, SQL Server 2014 and related technologies
- Experience troubleshooting SQL Server, including performance problems, query tuning and optimization, and Windows Server performance problems
- Experience implementing or deploying SQL Server Integration Services (SSIS), Reporting Services (SSRS), or Analysis Services (SSAS)
- Providing on-site and remote technical support solutions for customer service delivery and availability, while ensuring satisfaction with Microsoft SQL server
- The successful candidate will be capable of providing technical support
- Acts as the primary onsite technical contact, providing customer visibility, advanced technical support and problem resolution for corporate customers, including issues escalated to the highest levels of management
- Technical familiarity with Microsoft Database and other database technologies (secondary)
- Excellent interpersonal, verbal and written communications, analytical and presentation skills
- Ability to deliver presentations, discuss SQL Server and complimentary products at a solutions level
- Ability to manage customer escalations and work under pressure
- Ability to perform self-directed learning in a rapidly changing environment
- Capabilities to operate in a flexible team environment with minimal supervision
50
Senior SQL DBA / Developer Resume Examples & Samples
- The Pricing SQL DBA / Developer supports the BIUs and markets, in order to increase financial margins and capture the full potential of their products and solutions
- This individual is part of a pricing team that maintains a complex application and database geared to providing the correct analytics for pricing
- The current application is supported via a SQL Database and Qlikview reporting on the presentation layer
- Supports maintaining the application and data / works in partnership with the business team to expand the application and reporting to make good business decisions around pricing the portfolio
- Superior knowledge of standard database tools, especially SQL Query writing, including relational and multidimensional database skills using SQL, Oracle, Sybase, MS Access
- Must have at least 5-7 years’ experience in building and managing databases
- Knowledge of reporting and query tools (Especially Qlikview) and practices
- Business acumen and Business Analyst skills to help define and implement the requirements
- Good interpersonal, written, and oral communication skills and Technical documentation skills; soft skills as the position requires to work with business closely
- 5 + years Microsoft SQL Server experience
- 6-10 years IT operation with strong understanding of database structures, theories, principles, and practices
- Experience working with BI tools (especially Qlikview) a plus
- Master’s degree preferred or equivalent business experience
- This position requires the successful completion of a background investigation and/or drug screen
51
SQL DBA Resume Examples & Samples
- Owning, tracking and resolving data platform (databases, reporting and ETL systems) related incidents and requests
- Fulfilling requests and resolving incidents within predefined SLAs
- Reviewing service related reports (eg: database backups, maintenance, monitoring) on a daily basis to ensure service issues are identified/resolved within established SLAs
- Responding to database related alerts and escalations and working with database engineering to come up with strategic solutions to recurring problems
- Leading multiple projects from a Data Platform perspective, and mentoring of junior staff members
- Led large implementations of MS SQL, and experienced in integrating various application platforms with the data platform
- Solid understanding of relational database modeling
- Willing to learn and be trained on Informatica and/or Tableau configuration and administration
- Expertise in troubleshooting and resolving database problems
- Expertise in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
- Implemented High Availability (HA) and Disaster Recovery (DR) solutions for MSSQL Server environments
- Expert knowledge of indexes, index management, and statistics
- Ability to be part of a 24x7 on-call rotation for after hour and weekend production support
- Minimum travel involved
- Certification is a plus; MCTS, MCITP, MVP
52
Senior SQL DBA Resume Examples & Samples
- A minimum of 4 year’s SQL database experience in versions 2005, 2008, and 2012
- Experience in supporting SQL management tools
- Microsoft certified
- A minimum of 5 years’ experience in SQL scripting
- Working knowledge of both virtual and physical windows operating systems
- Degree qualified in an IT discipline and also have ITIL certification (preferred)
- Previous experience in Financial Services or working for a corporate (advantageous)
- Excellent verbal and written communication skills, capable of effectively interacting with individuals in a broad range of situations
- Ability to work under pressure, deliver to deadlines and manage conflicting demands and priorities
53
SQL DBA Resume Examples & Samples
- SQL DBA experience
- Enterprise experience
- Patching experience
54
SQL DBA Resume Examples & Samples
- Associate's degree and a minimum of 4 years work experience as a Microsoft SQL Server DBA in an enterprise data center environment OR
- High School Diploma or GED and a minimum of 6 years work experience as a Microsoft SQL Server DBA in an enterprise data center environment
- Experience with Idera tool suites
- Certifications such as A+ ,MCP, MCSE, ITIL
- Executing and monitoring database backups and restores
- Performing performance tuning/query optimization
55
SQL DBA Resume Examples & Samples
- Access and Excel - will be creating access queries and tables
- SQL - will use this to reconfigure the database as needed
- Analyze business trend and prepare routine financial analysis reports. Assist unit leadership to develop custom on-line financial, management, variance analysis and performance matrix reports
- Assist in developing tactical and strategic service, program to support the business units' goals (financial, quality, customer service, operational and efficiency, etc.)
- Support various financial applications including maintenance of organization structures, accounts, logic, reports, categories and authentication
- Project manage all aspects of the implementation of new functionality into existing financial applications, ensuring there is a documented history of key decisions and rationale as well as necessary audit trail
- Project manage all aspects of new financial ad business applications implementation efforts, including documenting, testing, assisting department in best practices and ensuring deadlines are met
- Provide day-to-day end user support to all Finance teams, including education, information availability, functionality questions, and troubleshooting
- Develop Ad-hoc financial and business analysis reports by data mining, data validation and data transference
- Manage Point-of-Sales interface for the Business Center
- Identify and maximize opportunity to use information and technology to improve business process, like, digitize ledgers and documents, set up workflow and approval process for the EMS system; set-up and monitor work flow for GEMS card approval process
- Review, analyze and create detailed documentation of business systems and access profiles including workflow, program functions and steps required to develop or modify various databases
- Examine business activity, existing business models and the flows of data in the business and to help decide whether new IT solutions will improve process, efficiency and productivity. Create logical and innovative solutions to complex business problems. Analyze data for mapping, extraction
- Insure all capital assets with the Risk Management office. Maintain large insurance database. Perform annual inventory, run depreciation tables and renew the equipment annually. In case or theft, damage or loss of equipment, handle all claims and cost recovery
- Work with users in defining their requirements; develop or review user specifications, ensuring that specifications provide for adequate processing and reporting controls and are consistent with financial reporting practices and accounting principles
- Provide accounting support to all account managers; by ensuring completeness of all ledgers and reports; maintain database to record this information. Assist Account Managers in resolving any problem that may arise with their ledgers, such as posting error, pending transactions, account name and attribute change, etc. Prepare account status reports
- Manage ledger and report retention, distribution and on-line or web-based reports
- Handle month-end closing by ensuring that all corrections are done before the month close. Responsible for weekly GBI loads (on-line SSL based) and ACCTS loads.. Handles missing document retrieval. Assist directors in full-scale fiscal closing
- Responsible for opening and closing FAS accounts by analyzing funding sources, purpose of the accounts, assigning mapping and fund grouping codes, FAS attribute; by initiating closing transfers and handling trailing charges. Update FAS and maintain integrity of the FAS and to facilitate financial reporting. Prepare Manual of Accounts and maintain database
- Develop and maintain users profile by authenticating through Active Directory
- Assist the Director of Budget to maintain and update Plant Fund Accounts and to track capital projects of the Chicago Booth
- Responsible for recharge operations for the Business Center. This include various billing of about $600,000 annually, Issue copy codes and maintain databases. Work with the Faculty Services and outside vendors to resolve any billing issues. Prepare performance and cost analysis of copy machines and printers
- Manage the Accounting database by troubleshooting, programming, coding and technical support
- Manage Uniflow process, troubleshoot problems with the system, and manage relationship with Canon. Bill users for printing based on system feeds from the software. Maintain and load student printing budget
- Maintain and update MBA scholarship Access database every year to reflect new data
- Maintain Workflow one users profile and sync them with the Accounting database
- Automate various reporting by using VBA scripting
- Other duties/projects as assigned
- Bachelor's degree required (degree in Information Technology, Computer Science, Applied Math, Business is preferred)
- A Master's degree in related field will be helpful
- Minimum of 3-4 years of experience in technology, business process management, Business Analysis, QA Analysis, Financial Reporting will be preferred
- Expensive MYSQL, Visual Basic, VBA scripting, database administration experience will be helpful. Experience in developing database table designs and building database model diagrams using Access and SQL will be required
- Strong analytical skills in database administration troubleshooting, tuning,, rollback and recovery operations will be preferred
- Strong quantitative and analytical skills required
- Strong understanding of relational database concepts and tools; Access programming, query and reporting experience required
- Ability to extract requirements from business users, write detail specifications and test plans, coordinate with project developers, assist with application testing, train users, and follow through implementation. Strong documentation and data mapping experience preferred
- Ability to understand and apply IT concepts within the framework of business application and business processes required
- Knowledge of financial processes with the ability to identify opportunities for continuous improvement preferred
- Advanced PC skills with MS Office (Excel, Access, PowerPoint, Outlook, Project, Word, and Visio) required
- Experience with portal, mainframe, hosted software and enterprise systems preferred
- Experience with Enterprise class reporting tools (Business Objects, Cognos,etc) preferred
- Professional demeanor including tact, discretion and a customer service-oriented approach to the job required
- Ability to exercise good judgment and work under pressure during seasonal high volume is required
56
SQL DBA Resume Examples & Samples
- Creating and maintaining data warehouses
- Business intelligence - specifically working with SSIS and SSRS
- Experience with table partitioning a plus
- Ability to work in a dynamic and high-energy team environment
- Excellent problem-solving and organizational skills
- Proven record of increasing responsibilities
- Ability to work independently and with a team
57
SQL DBA Resume Examples & Samples
- Managing large database environments consisting of SQL, Oracle, and MySQL
- Supporting Windows/Linux Servers
- Scripting/Automation
- Ensure integrity, high availability and optimum performance of database systems by providing technical support and maintenance
- Manages external vendor relationships successfully
- Continuously monitor and improve database and system performance
- Assist in capacity planning, space management and data maintenance activities for database system
- Implement and oversee database security strategy
- Perform troubleshooting and maintenance of multiple databases
- Monitor databases regularly to check for issues such as, locking issues and failed queries
- Perform database enhancement and modifications in conjunction with change management team
- Bachelors Degree in computer technology or comparable work experience
- Minimum of 3 years of hands on experience as a Database Administrator
- 3-5 years experience with the following
58
Senior SQL DBA Resume Examples & Samples
- 4+ years MS SQL DBA experience on various platforms
- 4+ years of SQL programming and performance tuning
- 4+ years of DB Backup/Recovery
- 2+ years High Availability (Clustering, Replication, Streams or equivalent)
- Oracle RAC experience preferred
- Oracle Advanced Security experience preferred
- Oracle and/or MS SQL certification preferred
59
SQL DBA Resume Examples & Samples
- Database installation and configuration
- Query optimization and performance tuning
- Writing and maintaining Oracle/SQL queries
- Developing and maintaining stored procedures and database triggers
- Develop database maintenance plan
- Manage Oracle backups and Microsoft SQL backups
- Develop application and database monitoring techniques
- Plan and executive advanced database migrations - Oracle and SQL
- 5% Maintain standards across all client environments including monthly maintenance plans and activities
- 20% Provide 3rd level technical support for Oracle & SQL issues that are escalated from Business Application teams
- 20% Coordinate project needs for IT Projects including Oracle & SQL upgrades, new application development, deploying infrastructure architectures, and support of onboarding new applications
- 10% Manage high availability Oracle and Microsoft SQL environments, including clustering and replication
- 5% Consult on software deployment and management of the technical infrastructures
- 10% Mentor other team members with Database Management skills
60
SQL DBA Resume Examples & Samples
- Minimum of 5 years of experience as Microsoft SQL Server
- Responsible for production moves of all SQL code from development and testing environments. Act as a change manager offering DBA expertise for the development team and recommend/define best practices for SQL development and database
- Proactive diagnosis and correction of poor SQL code before migration to production
- Expert knowledge and strong experience in Database Administration in SQL Server 2012 and SQL Server 2008 R2 and some exposure to SQL Server 2014
- 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, database monitoring and tuning etc
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues, etc… Technical knowledge of Consolidation and Virtualization technologies, SAN architectures and cluster server architectures
61
SQL DBA Resume Examples & Samples
- Experience Installing, Managing, Troubleshooting SQL Server 2008, 2012, 2014 in an enterprise environment
- Experience with Data Warehouse and Implementing SSIS & SSRS
- Automation experience (Helping the team automate existing projects)
62
SQL DBA Resume Examples & Samples
- Microsoft SQL Server 2008/2014 server side development including (SSIS, SSRS, SSMS)
- T-SQL (Transact SQL) Stored Procedures and Triggers
- Manage and configure Microsoft clustered, always on, and often high availability environments
- Manage Interfaces
- Perform quality checks on reports and exports to ensure exceptional quality
- Monitor job and transfer queues to ensure they are functioning as expected
- Develop new SSIS/SSRS packages to meet business needs
- Maintain a documented system of policies and procedures
- Manage outsourced functions
63
SQL DBA Resume Examples & Samples
- 3+ years Linux, web development, and/or sysadmin/cloud operations experience, with Java or similar web development language
- Experience maintaining Linux server environments
- Experience with Mac OS X support and configuration preferred
- Experience preferred in one or more of the following technologies
64
SQL DBA / Technologist Resume Examples & Samples
- Diagnose server reliability and performance issues
- Assist in monitoring, alerting, performance tuning and diagnosing issues for key production databases and environments
- Ensure that new database code meets company standards for readability, reliability, and performance
- Using Profiler traces and other tools to find the most frequently run queries and other performance issues
- Reviews, deploys, and tests scripts/code
- Respond to database related alerts and escalations and work to come up with strategic solutions to recurring problems
- 5 to 10 year experience in SQL Server Database Administration and or Database Development
- Experience with SQL Server 2016/2014/2012/2008r2/2008/2005
- Extensive knowledge on SQL, database structures, principals, optimization
- Extensive experience in data and database migrations
- Experience in performance tuning database, queries, and ETL processes
- Experience in SSRS, SSIS, SSAS
- Troubleshooting SSIS packages
- Experience knowledge of troubleshooting and resolving database integrity issues, blocking and deadlocking issues, replication issues, performance issues, connectivity issues, and security issues
- Extensive knowledge of SQL Server tools (Profiler, SSMS, SSCM, DM views, system stored procedures)
- Expert knowledge of indexes, index management and statistics
- Experience with On-call troubleshooting
- Ability to handle several projects and multiple priorities at once in a fast paced environment
- Bachelor's degree from four-year college or university
65
Senior SQL DBA Resume Examples & Samples
- Maintain all aspects of the MSSQL 2008 – 2012 database 24x7 environments
- Work closely with project managers, application developers, and system administrators on new and ongoing IT projects
- Design databases and database applications to support products, ensuring system scalability, security, performance and reliability
- Mentor junior database administrators
- Possess the ability to work both as independently and as a team member
- 3 plus years administering MSSQL database 2008 and 2012
- Experience configuring and maintain database backups using Netbackup
- Expertise in monitoring and troubleshooting database and application environments for performance, reliability, availability, capacity, and recoverability
- Expertise in patching MSSQL versions 2008 and 2012
- Knowledge of database and SQL performance tuning in MSSQL
- Experience with database security concepts and best practices
- Extensive experience in extracting and analyzing and optimizing SQL queries
- Experience in writing and tuning highly-performant SQL and PLSQL code
- Configuring and troubleshooting database network connection
- Experience with production support, resolving database performance issues, database capacity issues, replication, and other distributed data issues
- Possesses strong analytical and organizational skills
- Demonstrated ability to produce and provide detailed, understandable documentation, including infrastructure, schema, and data flow diagrams
- Ability to engage in knowledge transfer with developers, administrators, and other interested parties
- Ability to collaborate with the data team to ensure policies, definitions, and rules reflect cooperate standards
- Experience with change management processes
- Ability to provide after-hours and emergency support in an on-call rotation
66
SQL Dba-it Database Administrator Resume Examples & Samples
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. Installation of service packs and hotfixes
- Refine and automate regular processes, track issues, and document changes, refreshing lower environments
- Assist developers with complex query tuning and schema refinement and designs
- Maintain documentation of backup and recovery procedures of the physical data storage and logical data design for assigned databases
- Highly skilled in physical database design and the development of database applications, including the ability to read logical models and create the physical database structure
- Ability to work as a member of a team
67
SQL DBA Resume Examples & Samples
- SQL- Script, Automation, Coding, .NET if need be
- SQL- Admin, Tuning, analysis, 50P% (SQL 2012-2014)
- SSIS, SSRS, BI stack (tableau, BI experience)
- Oracle PL/SQL- admin, tuning, scripting (Oracle 11)
- Installs, configures, normalizes, maintains and manages security and releases for database platforms. Manages and monitors data backup processes as well as real-time replication processes from production systems to the disaster recovery systems
- As needed gathers forensic data related to database errors, outages and performance events and makes formal, written recommendations for fixes and performance upgrades
- Flexible to perform other duties and projects as assigned
- Specific Job Knowledge and Skills Required: Strong analytical skills
- Technology Skills Required: Advanced capability working with Microsoft Office Word, Excel, Access, PowerPoint, and Outlook, and Oracle and/or Microsoft SQL. Trained or working knowledge in two or more of the following database environments and tools
- Microsoft SQL Server 2005/2008/2012/2014
- Oracle 10/11g
- ODBC
- MS Transact-SQL
- Windows scripting
- Database design including permissions, triggers, stored procedures, indexing
- Database log shipping or replication
- Database data integration and data transformations solutions
- Work environment and physical demands are typical of similar jobs in comparable companies. Ability to lift up to 40 pounds
- Must be available to work during non-business hours which may include nights, weekends and holidays
- Ability to travel when required
68
Senior SQL DBA Resume Examples & Samples
- Bachelors’ Degree in Computer Science or equivalent work experience acceptable
- At least 5-7 years of experience working with Microsoft SQL Server and proven experience in SQL Server 2008 and 2012
- Deep exposure to SQL Server design, implementation, trouble shooting and resolving database related issues, and statistics and index management
- Performance Tuning and optimization using various SQL Server based solutions within complex environments
- Demonstrated experience in managing the large scale databases and implementing of High Availability solutions
- Experience in implementing operational automation using scripts, SSIS, and other SQL automation tools
- Strong communication and collaboration skills with demonstrated examples of working with both IT and business resources
- Exposure and understanding of Oracle environments at a high level
- At least 5 years of Microsoft SQL Server experience
- Hands on experience within Microsoft SQL Server 2012
69
Senior SQL DBA Resume Examples & Samples
- 7-10 years contiguous recent MS SQL Server DBA experience
- Worked in a medium or large size enterprise as an operational DBA
- Will be a part of an On-Call rotation with some after hours and weekend work required
- Experience installing, configuring, managing, monitoring and troubleshooting SQL Server 2008, 2012, 2014
- Experience with SQL index tuning of VLDBs
- Proven experience with Backups, Restores and participated in Disaster Recovery Drills
- Knowledge of scripting languages including T-SQL, VB Script required and PowerShell a plus
- Knowledge of High Availability technologies (Always on, mirroring, Log Shipping, Database Partitioning, Replication, Clustering)
- Demonstrated experience in developing and implementing SSIS, SSRS and SSAS is a plus
- Has strong communication, customer service and written skills
- Proficient in technical documentation and the creation of knowledgebase articles
- Demonstrated initiative and the ability to implement change effectively and use of a corporate work ticketing system (e.g. BMC Remedy)
- Must be able to work in and support team environments as well as work independently
- Attention to detail with ability to multitask in a fast paced, fluid environment
- Contribute to plans and policies for the production management of critical, large, enterprise databases
- Ability to consult and communicate effectively with internal customers, vendors and enterprise infrastructure teammates
70
SQL DBA Resume Examples & Samples
- Experience with Cassandra/Spark and/or other Big Data experience
- Ensure all database servers are backed up in a way that meets the business Recovery Point Objectives (RPO)
- As new systems are brought in-house, be prepared to work with PAAS SQL in Azure
- Deploy database change scripts as a part of application upgrades
- When performance issues arise, determine the most effective way to increase performance, server configuration changes, or index/query changes
- Experience working in development teams, assisting and identifying data/query related issues
71
SQL DBA Resume Examples & Samples
- Support SQL Server and Oracle DBs. This person will be the primary resource for SQL
- SQL Server 2012, SSRS, SSIS, SQL Backup technologies
- Handle service requests, ticket requests, problem resolution
- Responsible for the care and feeding of the SQL environment: optimization, performance tuning, table creation, data management, software installation, configuration, disaster recovery
- Provide strategy around operational procedures and performance monitoring
72
SQL DBA Resume Examples & Samples
- Design, research, and build SQL Server 2008, 2012, 2014 clusters
- Build, install, configure SQL Server AlwaysOn
- Configuration of log shipping, database mirroring, and SQL clustering
73
Senior SQL DBA Resume Examples & Samples
- Bachelor's degree or equivalent combination of training and experience
- Demonstrated experience working in environments with more than 20 SQL servers to manage and maintain
- Keyboard proficiency and the maneuverability through graphical Windows screens
- Demonstrated experience managing, testing, and maintaining SQL server backups
- Results oriented professional with excellent communication skills who utilizes diplomacy, discretion and strong customer service skills
- Must be able work independently and in a team setting while multitasking, paying close attention to details and meeting all deadlines
- Enjoy learning and working in a collaborative environment where you are able to make end-customers happy every day
- Must be goal oriented and able to communicate technical issues to non-technical customers
- Experience developing Extract, Transform, Load (ETL) processes using SQL Server preferred
- Integration Services (SSIS), stored procedures and job scheduler, preferred
- Experience with Reporting Services, Analysis Services and other tools, preferred
- Experience managing and maintaining Windows Server 2008 R2 and above, preferred
- Experience managing, testing, and maintaining SQL server disaster Recovery environments, preferred
- Experience managing and maintaining other Enterprise class databases or operating systems, desirable
74
SQL DBA Resume Examples & Samples
- 50% SQL Server 2008 Enterprise (or later) Database Administration in a cluster environment including day to day support and maintenance
- 25% Experience utilizing high availability/disaster recovery features
- 25% Proven experience working with SSIS and SSRS reporting tools
75
Oracle / SQL Dba-secureworks India Resume Examples & Samples
- Utilize strong database administration experience and technical expertise for 24x7 monitoring and management of a large number of Oracle & SQL Server instances with large data sets as well as unique networking set-ups
- Perform Oracle & SQL Server activities in an efficient manner including collaborating with other teams for, planning and testing with other departments, reporting problems and recommending remediation measures
- Responsible for responding to support escalations which involve troubleshooting complex technical problems and resolving data/configuration issues within defined service level objectives
- Provide strategic and thought leadership among peers on complex projects
- Collaboration with peers in understanding new database technologies, assessing impact to security services operations, and proposing solutions to existing business problems
- Collaboration in the software development lifecycle (SDLC) to develop detailed enhancement/bug definitions, write functional requirements, translate the requirements into solution designs, and navigate the functional requirements through to Production deployments
- Proactively look for ways to create operational efficiencies as it pertains to the tools and technology used by Dell SecureWorks to support their customer base
- Participate in, or directly work on any additional projects, assignments, or initiatives assigned by management
- Create/maintain documentation for operational procedures
- Document and perform system upgrades, application updates, and define monitoring requirements based on customer needs
- Participation in 24x7 on-call rotation required
- 5+ years of Oracle database administration experience. In particular, 11g and 12C
- 3+ years of SQL Server database administration experience. In particular, 2012 and 2014
- Experience with Oracle Recovery Manager,Oracle Dataguard & Goldengate experience
- Implement replication/backup/recovery of databases and database movement between environments
- Experience in Linux/ Unix shell scripting, shell command, crontab and vi editor
- Database objects creation, DB object migration and data conversion
- Proven experience in supporting 24x7 high volume production OLTP databases
- Experience in database design and modelling, addressing areas such as data integrity, data retention and data analysis
- Strong experience with various Oracle and open-source monitoring tools in addition to writing custom database-monitoring scripts
- Excellent database performance tuning and capacity planning skills
- Strong experience securing SQL Server/Oracle databases and implementing additional security best practices
- Experience with various features of Oracle; like replication, partitioning, clustering etc
- Strong SQL tuning skills
- Experience migrating/upgrading Oracle databases and applying required patches
- Experience converting business requirements into technical database specifications utilizing latest Oracle & SQL Server features
- Extensive experience in Installation, Configuration, Patches, Upgrades and administration for SQL Server 2005, 2008 in Clustered (Failover) and standalone environments
- Hands on experience in Migration of SQL Server 2005, 2008R2/2008 to SQL Server 2012 and SQL Server 2014 (side by side and in-place) which included production and non-production environments
- Implement database backup & recovery, data models, database designs, data access and table maintenance codes
- Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling
- Extensive experience in implementation of High Availability/Disaster Recovery concepts (AlwaysOn Database Availability and Instance Availability) for SQL Server 2012/2014 versions
- Must be aware of Performance analysis tools such as, SQL Server Profiler, Major Perfmon counters and SQL Server DMVs
- Experience with SSIS/SSRS and SSAS
- Experience in MySQL, Cassandra, or Mongo is a plus
76
SQL DBA Resume Examples & Samples
- ) 50% SQL Server 2008R2-2014 administration experience in a cluster environment including day to day support and maintenance
- ) 25% Experience utilizing high availability/disaster recovery features
- ) 25% Experience setting up and administering SSRS, SSIS and comfortable working with SQL Sentry monitoring tool
- ) Must be able to work full time without sponsorship by the client. They will not offer sponsorship for any candidate
77
Oracle / SQL DBA Resume Examples & Samples
- Designs and implements database solutions based on software and system requirement specifications
- Designs and implements server hardware and operating system solutions based on software and system requirement specifications
- Independently manages all aspects related to database and system within assigned projects
- Creates system specifications for various areas within assigned projects
- Creates database and system documentation
- Actively escalates issues to IT Project Manager and DBA Lead
- Participates in team meetings on an as needed basis
- Supports system ramp-up and go-live
- Troubleshoots system issues in 1st, 2nd or 3rd level depending on project requirements
- Supports IT CSS engineers, on-site Software Support Engineers and IT Software Developers
- Effectively communicates with customers if required
- Travels internationally for training, project assignments and commissioning
- Works on-call in 1st, 2nd or 3rd level
- Shift work on an as needed basis for system support and/or commissioning
- 4-year degree in Computer Science or Engineering or equivalent combination of education and experience in similar work
- 3 years of experience with the administration of SQL databases, preferably Oracle
- 3 years of experience with the design and implementation of complex multi-node server environments
- *THIS IS A FULL TIME OPPORTUNITY AND THE CLIENT WILL NOT OFFER SPONSORSHIP.***
78
SQL DBA Resume Examples & Samples
- Bachelor degree
- Experience with MSSQL
- Must have strong experience in Query Optimization and Performance Tuning using SQL Profiler and other troubleshooting tools such as Solarwinds Data Performance Analyzer
- Knowledge of high availability solutions such as Mirroring, Replication, Clustering, AlwaysOn
- Permissions/user management experience highly desired
- Ability to demonstrate creative thinking, advanced problem solving and troubleshooting
- Strong teamwork, interpersonal skills, Integrity and personal responsibility
- Be eager to learn new technologies, take personal responsibility and ownership for technical projects
- Experience with MongoDB, RavenDB, CouchDB, Cassandra or Hadoop is a plus
79
SQL DBA Resume Examples & Samples
- ) 7-10 years of experience working as a SQL DBA (including: performance tuning, ticket requests, etc.)
- ) 5+ years of experience building and maintaining a Data Warehouse
- ) 5+ years of experience with report development (package, scripting, etc.)
80
Ms SQL Dba Resume Examples & Samples
- Knowledge of Failover clustering, SAN replication, and other high availability technologies
- Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
- Tuning T-SQL queries to improve performance
- Troubleshooting hardware using tools like Netbackup, HP System Insight Manager, and BDA, IPSoft
81
Ms SQL Dba Resume Examples & Samples
- Good knowledge of ITIL processes with special attention to – incident, change, problem management, Database growth & capacity management for shared environment
- Installation and Setup of Oracle software
- Database upgrades , Rolling upgrades migration, Cross Platform Migration
- Configuring parameters and Performance tuning
- Basic knowledge and Administration of Exadata DBs systems
- Configuration and Management of back-up & recovery procedures
- Resource Management: - Physical storage, Logical database structure, Memory resource management
- Performance tuning of complex database issues
- Re organization of large databases
- Execution and Troubleshooting RMAN backups and recovery, restore and cloning
- Standby database management using Data guard / Manual
- L3 Configuration, Management Troubleshooting of RAC (10g / 11g)
- L3 Configuration, Management and Troubleshooting of ASM
- OEM installation & configuration. Designing standard DB monitoring templates
- Database performance monitoring as per the set baselines
- Proactive tuning of database to achieve desire performance metric SLA’s
- POC’s of new DB features & versions. Demonstrate the benefits to customer & include them in service catalog
- Database security implementation
- Knowledge on Active data guard, Snapshot standby
- Administration of MSSQL server 2000,2005, 2008, 2012
- Experience on always on database administration
- Working closely with customer to develop Database as service (DBaaS) roadmap. Managing the Database product roadmaps & lifecycle
82
Senior SQL DBA Resume Examples & Samples
- Provide IT Support to the Information Technology Division at Naval Surface Warfare Center, Crane (NSWC Crane) located in Crane, Indiana
- Excellent interpersonal skills to communciate with customers and other team members
- Ability to work independently and in a team environment
- Must have previous SQL DBA experience
- Must be able to obtain and maintain a secret security clearance. Prior to first day of employment must hve successfully completed security paperwork and have approved fingerprint cards
- Must be 8570 IAT II certified prior to first day of employment and must provide documented proof of certifications
- Previous experience with Postgre SQL highly desired
83
SQL DBA Resume Examples & Samples
- Serves as the expert in object-oriented and component-based development, patterns and design for reuse; applies test driven design and works towards automating and standardizing practices
- Sets and achieves build schedules; builds and maintain a suite of native apps
- Eliminates impediments and performs design and code reviews
- Builds intermediate to highly complex, high quality software components by analyzing, creating, designing and coding, troubleshooting and unit testing for new products
- Creates and executes installation scripts
- Designs new features and enhancements for existing products
- Delivers high quality software components with minimal defects; identifies and resolves errors and related software problems
- Creates and documents component specifications and detailed designs by working with Architects to implement specific system architecture; analyzes customer and internal requirements and specifications, and translates into the software design
- Identifies and resolves potential risks and issues; works in teams to implement mitigation plans and processes
- Builds and delivers phase exit review items; works with team members to follow CCIT processes and practices for project delivery
- Works with and adapts iHeartMedia’s Continuous Integration environment to ensure a smooth and high quality release cycle in a fast-paced Agile environment
- Ability to architect and create an Automation Framework using Selenium, Appium, and/or open source technologies
- Can build advanced automated functional and load test suites to exercise iHeartRadio’s Application
- Demonstrated in-depth understanding of the software delivery life cycle
- Strong ability to perform and utilize testing techniques to troubleshoot hardware and software configuration issues; good debugging skills
- Ability to write and execute test cases for the overall iHeartRadio platform, which includes mobile, Internet-enabled devices and web browser, with an emphasis on functionality and features of the product
- Demonstrated ability to conduct testing, including end-to-end and user acceptance testing phases, using best practices in software testing agile methodologies
- Ability to design software using OOA/D, UML, design patterns, data modeling, and ERDs
- Adept at profiling and tuning applications for CPU/memory use
- Can increase the maintainability of codebase by writing future-proof code with an emphasis on extensibility and reusability
- Detail oriented with excellent verbal and written skills; ability to communicate at detailed technical level as well as to distill advanced concepts into fundamental principles for teammates
- Can deliver creative technical solutions that are scalable
- Understanding of web and mobile standards
- Strong skills in multi-tasking day-to-day activities and effectively identifying issues in a variety of hardware and software environments
- Able to work individually and within a team
- 2-4+ years’ test experience in web, Internet or mobile technologies with a thorough knowledge of Agile principles and QA methodologies
- 4+ years of experience with Objective-C and iOS SDK
84
SQL DBA Resume Examples & Samples
- Responsible for ensuring availability, capacity and performance of the databases that support JM systems
- Ensure that the associated hardware capacity allocated to database provision is sufficient, has a high level of resilience design and that it is operating at the optimal performance level
- Responsible for providing trend analysis to the Management team to enable them to make informed decisions regarding resource management
- Responsible for the management of the databases, including change requests and troubleshooting incidents
- Ensure that documentation is maintained and kept up to date in line with JM standards and policies
- Ensure there are appropriate disaster recovery and backup procedures in place and these are tested regularly
- Significant experience of in-depth SQL database administration
- Experience of working in a multi-server, multi-site environment
- Practical experience of monitoring and tuning databases to provide a high availability service
- Working with databases in both physical and virtual environments
- MCSA SQL or MCSE Data Platform (preferred) qualification
- Experience of Oracle and DB2 database technology
- Experience working within the manufacturing or chemicals sector
- 27th December (23:59 UK time)
85
SQL DBA Resume Examples & Samples
- Bachelor's degree in Computer Science, IT, or a related technical field (additional years of experience may be substituted for the BS degree)
- 5+ years of experience as a SQL DBA
- Demonstrated knowledge of MS SQL Server 2008/2012, Oracle, and MySQL
- Ability to develop database scripting and queries
86
SQL DBA Resume Examples & Samples
- Must have 5 - 7 years SQL Server DBA working experience with SQL Server
- Must be knowledgeable and experienced on the different versions of SQL Server (2005, 2008). Knowledge of SQL Server 2012 and possible benefits to the existing environments
- Must have skills and experience in Database data management - backups, ETL, and archive using either native SQL Server backup tools
- Experienced using internal diagnostic and maintenance tools such as DBCC and internal SP functions as well as SQLDiag, SQL Profiler and third party diagnostics tools
- Demonstrate Knowledge of Partitioning Architecture
- Experienced in collaborating with data warehousing developers
- Knowledge of BI toolsets including SSIS, SSAS, SSRS and MS Sharepoint
87
SQL DBA Resume Examples & Samples
- 8+ years DBA experience SQL Server 2012 , Oracle 11 and 12 system, MySQL, or other relational database knowledge
- 3 + years BI reporting experience
- ETL, data warehousing experience
- Shell Scripting Experience
- A good knowledge data integrity, backup and recovery scenarios
- Knowledge of developing logical and physical database models
- Self-starter, ability to handle multiple projects and deadlines
- Bachelor's degree in a Computer Science or related discipline, or direct experience
- SQL server administration experience. You also have the basics of running Microsoft SQL Server - users, permission, backups, recovery, monitoring, and that sort of thing
- Insurance Knowledge
- Oracle DBA Experience
- IBM Certified Database Administrator
- Oracle Database 11g Administrator Certified Professional
- Oracle MySQL 5.6 Database Administrator Certified Professional
- MCSE Data Platform Solutions Expert
- Database Clusters administration
88
SQL DBA Resume Examples & Samples
- Support of the Product Delivery process, including both quality and production releases of critical externally facing products as well as staging and preparing testing and quality assurance environments
- Maintaining appropriate and required compliance and regulatory requirements, involving key process controls and documentation
- Providing Tier 2 and Tier 3 Operational support of critical 24x7 externally facing products
- Ability to work collaboratively in a highly diverse and fast paced team
- Provide architectural and process guidance to both members of this team as well as the product engineering team in order to insure security, performance and availability of all supported products
- On-call and evening/overnight and weekend work is required for support off hour releases and production operations
- 7+ years of work experience is required
- Thorough understanding of data networking and security processes including firewalls, load balancers, and routing
- Experience working with and supporting ASP.NET and SQL Server based externally facing products
- Working knowledge of Linux and MongoDB based externally facing products
- Administrative knowledge and proficiency with MongoDB and MS SQL Server based design and support
- Experience with systems management processes including systems monitoring using both integrated and "best of breed" monitoring approaches including App Dynamics and New Relic
- Demonstrated ability to work with rapidly changing development priorities while insuring performance and availability of production systems
- Strong systems analysis, performance tuning, and troubleshooting skills
- Ability to work in a "matrix" environment including the use of external partners for service delivery
- Manage all Database Administration needs, including and not limited to: backups, restores, snapshots, replication, patching and upgrade best practices within maintenance jobs and schedules
- Effectively research, develop, test and implement new Database Tuning and maintenance procedures · Implement and Maintain all Database Security policies, procedure and regulations · Serve as primary DBA for operational and strategic planning and projects · Coordinate production releases and changes including technical and scheduling conflict reviews
- Review new application supporting databases including Neo4J and Redis components to ensure compliance with company standards
89
SQL DBA Resume Examples & Samples
- Responds to database-oriented Engineering helpdesk requests
- Maintains system performance by performing system monitoring and analysis, and performance tuning
- Ready to work in shift, if required
- Other duties may be assigned, as required
- Qualifications & Skills
- 4 years of MSSQL database administration experience (SQL 2008 preferred)
- Expertise in Microsoft SQL Server 2012 and 2008, SCOM 2012, Integration Services, Analysis Services, T-SQL, Golden Gate, Hyper-V, Windows and blade hardware platforms
- Extensive technical knowledge across multiple technology areas including: Java platform, .Net framework, performance tuning, storage, networking, client libraries
- Experience with data modeling, database design, and Microsoft patching methodologies
- Some knowledge on how to support very large databases with heavy online and batch activities
- BS in Computer Science or equivalent education / professional experience
- Ability to create and follow written procedures
- Experience /Knowledge of “Always On”
- Ability to independently learn new technologies through research and vendor provided documentation
- Ability to work independently and proactively with a minimum of supervision
- Experience with designing and troubleshooting DTS packages
- Certification: MCSE- Data Platform/ MCTS/ MCITP/ MVP
- Understanding/experience in an Agile (scrum), and/or iterative development methodology
- Application development in large, complex organizations
- Volt is an Equal Opportunity Employer
90
SQL DBA Administrator Resume Examples & Samples
- Database Performance Tuning,
- Database Security,
- Promoting Process Improvement,
- Problem Solving,
- Presenting Technical Information,
- Quality Focus,
- Database Management,
- Data Maintenance,
- Operating Systems,
- Attention to Detail,
91
SQL DBA Resume Examples & Samples
- Project management within an Agile software development
- Writing complex and optimized queries
- Integrate data from multiple systems into single application
- Work with users to provide programming solutions
- Bachelor’s degree in Information Technology or related
- Five plus years of experience
- Strong knowledge of object oriented development practices with an emphasis in the .NET technology stack
- Extensive knowledge of relational databases from schema design to writing complex, optimized queries and familiarity with NoSQL databases is a plus
- Understanding and expertise in design patterns, version control systems, N-tier application architecture, LINQ, SQL Server Integration Services, ASP.NET, MVC
- Working knowledge of: MySQL, PostgreSQL, and/or MSSQL and NOSQL
- Advanced knowledge of operating systems
92
SQL DBA Resume Examples & Samples
- 7-10 years of SQL DBA (SQL 2008r2) experience - ideally they would be DBAs focused on databases as a service
- Experience with setting up best practices for a DBA team - documenting these practices so that things aren't repeated
- The ability to assess challenges that are existing at Client within the DBA team and help put a plan in place to combat those challenges
- Planned backups and disaster recovery best practices
- Managing large installations of databases
- ISE - Storage
- Creating best practices for the standard operating system and roll those out to the team
- Help with strategy, design and transition within the DBAs because those are the areas in which they are lacking
- Assess the challenges and our client and help put a plan in place to combat the challenges
93
Microsoft SQL DBA Resume Examples & Samples
- Lead the migration of databases between data centers and support the modernization and virtualization of systems and applications with dependencies on databases
- Monitor databases and perform tuning enhancements to optimize their performance. Develop and maintain utilities to automate problem determination, system backups, change implementation, and monitoring activities
- Participate as a team-member in data management strategies. Integrate data architecture with appropriate components of the extended enterprise and the data warehouse
- Participate in data-sourcing, import and data validation activities. Provide technical consultation to Task Lead for supporting customer requirements
- 5+ years of MS SQL 2012 - 2016 DBA experience
- IAT II certification requirements (Security+ CE, CASP, CISSP, CASM, CEH, etc)
- DoD Secret clearance
- Experience creating and maintaining large datasets
- MS SQL Server 2012, 2014, 2016 Certification or Microsoft Windows Server Certification
- Oracle migration to SQL experience
94
SQL DBA Resume Examples & Samples
- Maintains responsibility for analysis of SQL code and development where changes are necessary. Tunes queries / stored procedures, indexes, and other database elements
- Reviews and enhances existing SQL code to improve performance and ensure application meets industry-standard specifications
- Plan and design database changes necessary for data conversion, tool configuration, data refresh or migration or other initiatives related to large application development project
- 3-5 years of SQL development experience with strong command of SQL, stored procedures, triggers, etc
- Experience with data and batch loading processes
- Proficiency with optimization techniques
- Thorough understanding of software development life cycle
- Knowledge of Oracle and/or Sybase databases; IDMS experience is also helpful
95
SQL DBA Resume Examples & Samples
- SQL Server database administration including backup/recovery, high availability (failover clustering, availability groups), disaster recovery (log shipping, database mirroring), security and optimisation
- Experience with SQL Server 2000, 2005, 2008 R2 and 2012
- Experience supporting ETL processes using SQL Server Integration Services and Analysis Services
- Ability to write and troubleshoot SQL scripts and skilled in PowerShell scripting
- Design, develop, maintain and manage the technical delivery of database developments
- To provide primary support for all production and development environments and upgrade to new versions as required
96
no SQL DBA Resume Examples & Samples
- Research, evaluate and recommend NoSQL solutions and best use cases for them
- Work with development teams to architect and implement NoSQL solutions
- Work with Database Operation team to conduct system performance evaluations
- Proficient with installing, configuring, administering, using and benchmarking NoSQL solutions
- Minimum 4 years of developing NoSQL solutions
97
SQL DBA Resume Examples & Samples
- 8-10 yrs experience
- Strong technical lead experience. Leading a team of DBAs
- Multi-platform experience
- Experience in an enterprise level global environment
98
Oracle / SQL DBA / Senior Systems Specialist Resume Examples & Samples
- Proactively manage, maintain and monitor Oracle and SQLServer systems
- Diagnose the database system health regularly and troubleshoot any issues
- Able to respond to different stakeholder's support requests
- Persistently seek innovative ways to improve DBA Team’s efficiency and quality
- Provide technical expertise to the development teams by assisting developers with implementations and ongoing maintenance of the Database environments
- Applicant must be fully responsible for managing all Oracle and SQL Server related Backups and Recovery scenarios and perform backup validation and restore tests
- Support all production, development & test environments
- Capacity monitoring and forecast the growth of critical databases
- Be available to work outside normal office hours, weekend and public holidays. Applicants will be expected to be on call after few months and respond according to agreed SLA’s
- Oracle 10g, 11g & 12c RDBMS running on AIX & Windows Platforms
- Extensive knowledge of the Oracle and SQL Server toolsets
- Good SQL & PL/SQL and T-SQL knowledge
- Performance Tuning expertise on both Oracle and SQL Server databases
- Thorough understanding of High Availability and DR including working experience of Oracle Data guard and SQL Server availability group
- Experience of working within a controlled ITIL environment with good understanding of control processes & procedures
- Motivated team player with excellent organisational skills, triage and task prioritisation
- Oracle and Microsoft Certifications
- ITIL Foundation or at minimum awareness
- Server Hardware predominantly HP and IBM P-Series
99
SQL DBA Resume Examples & Samples
- Installation and deployment of databases via SQL Server
- Managing database security
- Proficient in Transact SQL, DTS,
- Ability to understand database structures, theories, principles, and practices
100
SQL DBA / Developer, Sunderland Resume Examples & Samples
- SSIS
- Visual Studio .NET would be desirable
- Microsoft Dynamics NAV would be desirable
- Monitor our ERP and other systems to ensure that they run optimally
- Write and amend SQL queries, optimizing for speed and reliability
- Undertake customisation and development projects from proposal to deployment
- Provide advice on the best way to achieve requirements for both end users and reporting
- Ensure processes are documented correctly
- Analysis and interpretation of scoping documents, identifying potential concerns and recommending possible solutions
- Assist in resolving faults / issues occurring in the operation of software, especially those requiring greater expertise
- Good problem recognition and resolution skills
- Must have ability to work in a fast-paced environment and multi-task as required to meet schedules
- Good communication skills, both written and oral
- Good time management skills with the ability to work with minimal supervision
- Detail-oriented with commitment to high standards or work
- Ability to manage a varied workload, often to tight deadlines
- Be customer-focused in a constantly changing environment
- Great communicator, friendly and good humoured
- A good listener with excellent written and oral communication skills
- Well organised
- A “self-starter” with initiative and follow through
- Calm and helpful manner
101
SQL DBA Resume Examples & Samples
- SQL DBA for the company’s SQL Server applications and development environments
- Proactively identify opportunities to more reliably support production operations, and implement DevOps and monitoring tools for this purpose
- Develop SSIS jobs to integrate data into business applications
- Ensure that nightly SSIS jobs complete successfully. Troubleshoot, if needed
- Implement disaster recovery solutions, and monitor readiness of disaster recover site
- Troubleshoot and solve level 2 technical support issues with key business applications running on SQL Server
- Assure all technical support issues are tracked to completion, and document solutions to common problems in a central repository
- Perform periodic on-call duty
- 5+ years of SQL Server DBA experience in a Windows environment
- Experience with DevOps concepts and tools
- Fluent with SSIS
- Experience with IIS web applications
- Experience with scripting tools such as Powershell or similar tools
- Experience implementing systems and database monitoring tools
- Experience with SSRS reporting is a bonus
- Experience with development and optimization of T-SQL, stored procedures, triggers and functions in a SQL Server environment
- Experience with SQL Server backup, restore, replication, log shipping
- A self-starter with a desire to automate everything
102
SQL / DBA / Ssrs Administrator Resume Examples & Samples
- (Required) Minimum 5 years’ SQL Database Administrator experience
- (Preferred) Minimum 3 years’ experience working with MES, ERP, and enterprise applications
- Strong experience with implementing and supporting SSRS
- Knowledge with Performance Tuning and ability to use native monitoring tools
- Strong experience with backups, restores, and recovery of databases
- Understanding and working knowledge of High Availability (HA) and Disaster Recovery (DR)
- Proficient with Windows Server and Active Directory
- Fluent in English (reading and writing)
103
Senior SQL DBA Resume Examples & Samples
- Demonstrate extensive knowledge of all aspects Microsoft SQL Server including administration, replication, backup/restore procedures and related components such as Reporting Services, Analysis Services and Integration Services
- Recommend and implement solutions for SQL performance monitoring and tuning
- Assist with Windows Server configuration and management as it relates to MS SQL Server installation and performance
- Work outside of normal business hours as required for completing projects, working on deployments and resolving system outages
104
Oracle & SQL DBA Resume Examples & Samples
- Installation, patching, upgrade/migration of database
- Good knowledge in RMAN (Backup & Recovery) & as well as in traditional database backup & recovery
- Data-Guard broker configuration and patching & upgrading database in data-guard environment(s)
- Stand-alone Database Configuration & Monitoring
- Database Security administration (Implements & enforces security for all the supporting database)
- Good knowledge in Shell programming, SQL
- Install, manage & troubleshoot multi node multisite SQL Server clusters
- Load Balancing & Scaling out SQL Server
- Database Archiving / Partitioning (Horizontal / Vertical)
- Performance Tuning – Execution plan, Profiler, Performance Monitor, Extended Events, Data Collector and Resource Governor
- Auditing SQL Server Security
- Good knowledge in Database Cloning using RMAN
- Good knowledge in Performance Tuning on both stand-alone as well as in RAC environment(s)
- Oracle RAC (Real Application Clusters) installation & configuration
- Good Knowledge in Advanced Replication
- Upgrade & patch of RAC database environment(s)
- Good knowledge in wallet configuration and data encryption
- Excellent knowledge in supporting the database in Production environment(s)
- Good knowledge in database re-organizations exercise
- Excellent knowledge in troubleshooting the problems in stand-alone as well as in RAC environment(s)
- Good knowledge in Grid and ASM environment(s)
- Good Communication skills
105
SQL DBA Resume Examples & Samples
- 7 to 9 Years of experience in SQL Server Production and Non Production Database Administration Skills
- Experience working on SQL Server 2008, SQL Server 2012 and Knowledge of SQL Server 2014
- Should have experience working with development and systems teams to perform application and database tuning
- Proficient in Performance Tuning, Query Optimization, Client/Server Connectivity
- Knowledge of Maintaining Resource Consistency and Server Configuration consistency across all environments of SQL
- Experience in SQL Migration Planning and DR planning
- Experience in CDC, Data Masking and Powershell
- Experience in Virtualization and troubleshooting clustering
- Troubleshooting knowledge of Stored Procedures directly with Application Owners for Performance improvement
- Must have experience in Replication, Virtualization, Log shipping, Disaster Recovery , High Availability, Automation Scripting and Clustering
- Experience in planning, designing and implementing Application Releases/Deployments and troubleshooting application job failures
- Working knowledge on SSRS/DTS and SSIS
- Must have Microsoft DBA certification
- Should Possess a good technical background with an ability to effectively interface with cross-functional teams (server administrators, storage administrators, client application developers, etc)
- Good oral and written communication skills - must be comfortable communicating with technical peers and customers
- Personal Commitment to stay with latest technology updates
- Resource should be ready to work in 24/7 support environment
- Resource should have experience in contributing to the development, documentation and implementation of database standards or guidelines
- 2xer
106
SQL DBA Resume Examples & Samples
- 1) Strong experience as a SQL Server Operations DBA with experience setting up and maintaining SQL Server database clusters
- 2) Perform SQL Server performance tuning as well as backup and recovery
- 3) The ability to automate with Powershell. Ability to execute T-SQL scripts
- Performs backup and recovery on Database Management Systems, configures SQL Server database parameters and prototype designs against logical data models, and defines data repository requirements, data dictionaries and warehousing requirements
- Performs configuration, scripting, analysis, installation, monitoring, administration and tuning for database management systems
- Interfaces with user departments remotely and on-site to assist in the implementation of work requests and provide operational support
- Ability to learn and apply new skills in a constantly changing technical environment
- Knowledge of UNIX platforms
- Ability to monitor and tune databases and instances
- Demonstrated experience with successful system and project implementations
107
Senior SQL DBA Resume Examples & Samples
- 3) Experience with Powershell scripting
- Size and provide specifications for new virtual and physical SQL database servers
- Troubleshoot and deploy SSIS packages
- Participate in code reviews with development teams to give guidance on performance and design
- Maintain standards, policies, configuration guidelines and procedures
- Consult with production support DBAs on project needs and deployments
- Performance tuning and query optimization
- Participate in database design process
- Work closely with application teams and identify potential performance problems and offer advice
- Work with Security team to secure all databases and maintain security posture
- Create, edit and maintain SSIS Packages, SSRS reports & SSAS cubes
108
Oracle SQL DBA Consultant Resume Examples & Samples
- Support the lifecycle management of business critical applications to include installing patches, performing upgrades, managing releases, and administration tasks
- Support the development and production environments of business critical applications by ensuring application availability, responding to application emergencies, and supporting deployments
- Support the customer through proactive monitoring, acknowledgement, response, and resolution of incidents and notifications
- Looked to be a team leader and help with managing the deliveries effectively; help L1/L2 DBAs in troubleshooting complex issues
109
Senior Ms-SQL DBA Resume Examples & Samples
- Superior MS SQL skills, including clustering, mirroring and AlwaysOn technologies
- Strong Windows skills
- Data warehouse design and experience
- MS SQL Performance Tuning experience required
- Database security/encryption experience is preferable
- Experience with RedGate SQL Monitor and SQL Litespeed is a plus
- Ability and desire to learn independently as well as in a team
- Ability to manage time well and meet multiple deadlines in a sometimes hectic environment
- Understanding of athenahealth’s Balanced Scorecard and each department’s responsibilities under it
- Willing/excited to work in a fast-paced, and sometimes intense, rapidly expanding company
- Strong computer literacy and/or the comfort, ability and desire to advance technically
110
SQL DBA / Database Administrator Resume Examples & Samples
- 6-9 years of experience SQL clustering and1-2 years Data Warehouse experience
- Experience supporting high availability systems
- Experience with SQL Server 2012r2 and SQL Server 2016
- Experience with Very Large Database (VLDB) and SQL Mirroring
- Must have excellent verbal communication skills, will work with customers
- Ability to quickly learn and apply technical concepts
- Able to follow processes and procedures Ability to learn new skills in a fast paced environment
- Data warehouse and ODS experience is also preferred
111
SQL DBA / Database Administrator Resume Examples & Samples
- Can support large / complex systems
- Can participate in On-Call rotation as required
- Knowledge of Very Large Database (VLDB) concepts and SQL Clustering and SQL Mirroring
- Data warehouse and ODS knowledge is also preferred
- Knowledge of the concepts of supporting high availability systems
- Candidate is expected to work on-site
- Able to follow processes and procedures
- Ability to learn new skills in a fast paced environment
112
Senior SQL DBA Resume Examples & Samples
- If a candidate has experience with AWS or Azure that would be a nice to have. Any upgrade or migration experience is preferred. Perform SQL database administration tasks: - Monitoring and tuning all SQL databases to ensure high availability - Monitoring production databases and data processing jobs - Implementing and administering database replication - Troubleshooting performance issues and fine-tuning queries and stored procedures - Coordinating database checkpoint frequencies, archive logging, resource usage with programmers and system administrators - Creating capacity planning forecast - Establishing and maintaining custom-tailored backup/restore procedures and disaster recovery plans for Production Servers. - Enhancing system availability - Support and/or participate in 7 X 24 hour production support Provide support to Application Development Groups in the following ways: - Providing logical database structures alternatives - Creating a physical database design - Helping with construction, testing and installation - Ensuring application performance, integrity and availability - Proficient with system development techniques and tools SQL Server Software Maintenance: - Installing, configuring, securing SQL Production servers - Upgrading and up-sizing databases from earlier versions to the latest versions - Applying and testing maintenance fixes - Providing technical support to the application developers - Reviewing new databases that come with purchased packages
- SQL Database Admin (SQL 2012/2014) - backup, restore, indexing, maintenance
- Strong SQL Development (Write T-SQL code form scratch)
- Installation, upgrades, configuration
113
Microsoft SQL DBA Resume Examples & Samples
- Responsible for architecture, design and assurance of the SQL Server platform
- Responsible for data schema design and stored procedure code design
- Responsible for production of key database artefacts
- Responsible for designing and assuring key implementation approaches and data migrations
- Responsible for proactively identifying potential problem areas and helping benchmark potential solutions
- Responsible for identifying key monitoring and alerting mechanisms to allow ongoing support
- Responsible for tuning storage structures and queries to support load
114
Senior SQL DBA Resume Examples & Samples
- Experience with T-SQL - writing procedures, creating tables, indexing, specifically more around best practices in this area
- Experience working with other DBAs and mentoring
- The ability to be able to manage various database related projects and general project management skills
115
SQL DBA Resume Examples & Samples
- 7+ years in a progressive information systems environment; 6+ as a database administrator
- Industry certification required in at least one database platform (Informix, MS SQL)
- Familiarity with SQL Server tools, SSMS, SSIS, SSRS and SSAS
- BS / BA
- Healthcare and home health industry experience desired
- Must have strong customer service and communication skills
- Effective ability to work both independently and within a team environment
- Effective training ability for mentoring co-workers and end users
- Ability to prioritize and complete projects within deadlines
- Motivated, self-starter with excellent problem solving abilities
- Demonstrated ability to meet regular time and attendance requirements
- Imports and exports data from disparate systems meeting business end user needs
- Administers and controls the organization’s database resources including multiple servers
- Performs data migrations between servers as growth requires
- Assists in server setup for new SQL Servers, by providing needed drive sizing, and memory requirements
- Creates new application service accounts and new end user accounts as needed, following the Principle of Least Privilege practice ensuring Microsoft Security password requirements are met
- Performs all necessary database maintenance, index fragmentation, etc
- Works with external vendors resolving any missing SQL Database Logs for automated log restore process
- Works with Windows System Engineers ensuring all databases have current validated backups
- Collaborates with system engineers, and applications developers designing databases, schemas and data dictionaries to ensure data integrity, security, optimizing performance and assisting in managing storage requirements
- Recovers corrupted data and eliminates data redundancy
- Operates diagnostic tools and other techniques tuning systems and improving database performance
- Creates physical database tables, typically based on designs developed in collaboration with programmers, analysts and users
- Builds scripts, triggers, stored procedures, ad-hoc queries and other processes automating data movement between systems
- Monitors automated and manually initiated SQL Agent Jobs to ensure proper and timely operation within routine and unscheduled job cycles
- Participates in team projects as deemed necessary
- Monitors unassigned and assigned service desk support tickets resolving end user issues in a timely manner
- Supports all federal reporting projects, providing data extracts as needed
- Attends periodic status meetings; provides timely & accurate active project updates
- Must be available and willing to work any weekend, holiday and after normal business hours as necessary or desirable meeting business needs
116
Senior SQL DBA Resume Examples & Samples
- 8+ Years of experience as a DBA
- Strong written and verbal communication
- SQL Server 2016 database administration tasks
- Advanced T-SQL development experience
- Database performance tuning
- Perform index management and optimization
- SQL Server Replication and Database Mirroring
- SQL Server HA and DR
- Server and database security
- Backups and recovery
- Be able to perform effectively as part of a small team in a rapidly growing, dynamic environment
- ------------------------------------------
- Experience as a SQL DBA (the successful candidate will have a senior level understanding of administering large databases, database internals, troubleshooting)
- Experience administering SQL database version 2014 and exposure to 2016, specifically with SQL Server Replication and Database Mirroring
- Previous experience working in a relatively large environment
117
SQL DBA Resume Examples & Samples
- Provide software installation and upgrades for TMW base product line and add-ons including both server and client components
- Troubleshooting installation issues
- Implement and configure SQL Server following standard practices to maximize DB performance
- Manage projects related to database services
118
Mid Level Oracle / SQL DBA Resume Examples & Samples
- Design, Install, upgrade, administer, monitor, and patch SQL 2008/2012/2014/2016 databases in Cluster and non-cluster environments
- System level DBA functions including: set up replication, administer SQL cluster/Virtual server clusters
- Develop stored procedures and other database objects to implement some business logics in the database
- Develop scripts for database task scheduling, monitoring and maintenance
- Design, Install, configure and administer OEM Grid control 12c
- Integrate/collaborate with application development and support teams on various IT projects
- Take ownership on primary database and lead by example
- 3-5 years experience in design/manage/administer SQL servers on cluster and non-clusters & Oracle databases on RAC and non-RAC – 24 x7 environments
- 1-3 years experience with Oracle Golden Gate and/or Streams or any other real time replication technology
- 3+ years’ work experience: SQL clustering and virtual server clustering, data replication and fail-over
- Proven experience to perform in a fast paced demanding environment
- Microsoft Certified Solutions Associate (MCSA) is preferred
119
Senior Oracle / SQL DBA Resume Examples & Samples
- Monitors and supports Microsoft patches/upgrade as needed and database configuration across environments
- Proactively research and locate the necessary tools and processes to identify troublesome trends as they develop, and track problems to resolution
- Proactively tune the performance of database
- Participate on weekly on-call duties on rotational basis
- Follow the existing processes for SOX/PCI databases
- Take ownership on primary database as senior DBA and lead by example
- Bachelor's degree in Computer Science/Engineering or equivalent work experience
- 5-7 years experience in design/manage/administer SQL servers on cluster and non-clusters & Oracle databases on RAC and non-RAC – 24 x7 environments
- Strong experience/competency with: VLDB, SQL performance analysis and tuning, log shipping and security, replication, SQL clustering, fail-over to remote site, scalability, reliability issues and written stored procedures
- Installation and configuration of Microsoft SQL Server in a clustered configuration
- Strong analytical and T-SQL experience
- Ability to work well in teams with good oral, written, and interpersonal communication skills
120
Lead-SQL DBA Resume Examples & Samples
- Capacity Management
- Backup and Recovery Management
- Daily, Weekly and Monthly maintenance
- Installations / Upgrades / Patching
- Health Checks / Report Analysis
- Ability to organize and plan work independently
121
SQL DBA Resume Examples & Samples
- Troubleshoot and resolve a variety of identified problems (integrity issues, performance issues, blocking and deadlocking issues, replication issues, etc. with a high degree of success and confidence
- Proactively perform database monitoring, performance tuning, and database maintenance and testing
- Proactively develop and implement policies and procedures to improve overall effectiveness and integrity of the company's databases and systems
- Works with supporting network, server and disk storage teams to facilitate managed, balanced systems
- Minimum 5 - 7 years' practical experience within a MS SQL DBA capacity, with strong knowledge of SQL Server 2008/2012 administration, implementation and optimization
- Minimum 5 years' experience in database design, development and implementation, with experience in designing and administering a large SQL environment
- Experience with MS SQL Server (tables, triggers, unions, joins, complex queries and stored procedures)
- Experience in managing clustered SQL environments utilizing mirroring, availability groups, and log shipping
- Fluency with appropriate tools including SQL Management Studio, Query Analyzer, Profiler, Performance Monitor and other SQL Server management tools as well as the entire Microsoft Office suite
122
Oracle / SQL DBA Resume Examples & Samples
- Candidates MUST be either SC Cleared or Eligible to take clearance
- Installation, configuration and performance tuning of Oracle RDBMS versions 7-12 is beneficial
- Installation, configuration and performance tuning of SQL Server 2000, 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014
- Security Clearance
- MS SQL Server/Oracle Certification
- Experience of SQL “Always On” would be beneficial
123
Ms SQL Dba Resume Examples & Samples
- Install and configure MS SQL server for various version(2012,2104,2016)
- Experience with SQL server in a VMware Environment
- Engage system/storage admins and development teams productively
- Develop automation within the environment for SQL server deployment and updates, maintenance, custom software deployments, etc
- Assist with development of standards and policies around data /access security (end-user access vs dev access)
- Review design and deployment of any data objects from development environment to production
- Monitor SQL Server activity, performance, error logs, event logs, space usage and security on a daily basis
- Manage and execute daily operational jobs including backups, index/statistics updates and defrags
- Monitor and maintain transactional replication and Always on configurations
- Bachelor's Degree – a degree in a computer science, engineering, mathematics, or science preferred
- 8+ years related professional experience
124
SQL DBA Developer Resume Examples & Samples
- Analyze business requirements, documentation and technical specifications for projects in conjunction with the project team and customers to translate into a DB design
- Maintain and support production systems, including some off hours and weekend support as required
- Provide support to our internal systems and help resolve user issues and questions related to data stored in the database or performance of the database platform
- Participate in research projects to evaluate tools, techniques, and upgrades that will further enhance and advance the DBMS
- Minimum 1 year of SQL Server database administration experience. Exposure to SQL 2012 and SQL 2016, a plus
- Minimum 2 years of T-SQL development
- SSIS design/development, a plus
- Knowledge and experience in physical and logical database design, a plus
- Experience in a clustered SQL server environment, a plus
125
SQL DBA Resume Examples & Samples
- Day-to-day SQL database administration activities (DBA)
- It includes regular backup (log and DB) and monitoring
- DB Replication setup configuration and support
- Log-shipping setup configuration and monitoring
- SQL 2012 Always On setup and configuration
- Performance monitoring and fine-tuning which includes SQL query fine tuning and core/system level fine-tuning like (OS, Disk IO level analysis)
- SQL and OS patch management
- Windows and SQL Cluster setup and Administration
- SQL DB related maintenance activities (like…index rebuilding, defragmentation)
- Data backup management and do regular backup data consistency check
- Knowledge about disaster recovery environment, SQL agent backup
- Knowledge about IIS administration
- Knowledge about PBM & UMAP tool and SCOM monitoring
- SSI package and SSRS
- Crystal Reports Administration
- College degree in Information Systems, Computer Science, Computer Programming, or other application development and maintenance-related field
- MS SQL Server 2008 R2 & SQL 2012 – Intermediate/Advanced
- Crystal Reports 9.0 & 2013 – Intermediate/Advanced
- Strong MS Outlook, Word, Excel knowledge
- Outstanding customer service experience and resourcefulness
- Demonstrated ability to multi-task
- Network architecture
- Responsible for Knowledge transfer and arriving at SLAs for steady state
126
SQL DBA Resume Examples & Samples
- Database Administration for MSSQL Server, Replication Server and SSRS
- Troubleshooting and resolving database problems
- Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
- Backups, restores and recovery models
- Implementing operations automation using scripts
- Ability to identify capacity and performance needs for database server infrastructure (compute, memory, disk and network)
- Ability to manage IT related initiatives including long-duration projects across multiple groups
- Ability to manage and prioritize multiple related projects, including troubleshooting, operations, and maintenance of the enterprise in a team environment
- Ability to maintain documentation for IT processes, procedures, trouble tickets, network configurations, hardware/software inventory, and audit requests
- Create and maintain technical and procedural standards documentation
- Follow formal change control process when necessary
- Evaluates current database environments, conducts research, recommends and implements innovate systems technology that can enhance the reliability, security, productivity and efficiency of the database infrastructure
- Experience in troubleshooting and resolving database integrity, performance issues, blocking and deadlocking, replication , connectivity, security issues, etc
- Use effective verbal and written communication skills. Read and understand company policies and procedures and other literature and documents applicable to assigned tasks
- Work off-hours when required
- Produce quality work, meeting requirements of company policies, procedures and industry standards
- Be motivated and work productively
- Set exemplary standards of ethics and stewardship of corporate resources
- Support company philosophies, policies, practices and procedures
127
SQL DBA Resume Examples & Samples
- Ability to understand basic installation, setup and configuration, and troubleshooting with emphasis on data structures and file systems
- 1+ years of experience with Operational DBA Administration
- Certifications such as MCSA or MCSE,
- Banking/financial industry experience
128
Ms SQL Dba Resume Examples & Samples
- Installation of SQL Server and post-installation configuration as per the standards
- Responsible for the monitoring and maintenance of production SQL Servers
- Perform periodical Database health Check, maintenance and monitoring
- Deploying and testing replication and disaster recovery solutions, and ensuring database security,
- Replication & mirroring Setup and Monitoring
- Always On setup, configuration and troubleshooting
- Database Performance tuning and troubleshooting
- Hands on experience on SQL Server 2000, 2005, 2008, 2012 and 2014 and Support Knowledge on SQL Server 2016 build and Implementation
- Experience on installation of SQL Server service packs / security hotfixes on SQL 2000/2005/2008R2/2012/2014
- SQL Cluster Installation
- Production Support for 24/7/365 days support Model including weekend support with rotation
- Manage environment inventory and Documentation
- Providing training & guidance to L2/L3 Team members
- Database Capacity planning and analysis
- Customized solutions to client based on application requirement
- Identifying root cause and documenting the same for critical issues
- Participate in Change Control meetings to explain business on the planned changes and their impact
- Design and/or implement solutions that meets and/or exceeds customer’s expectations based on requirements defined by scope document and staying within budgeted estimates
129
Senior SQL DBA Resume Examples & Samples
- Implement and maintain the database design including physical and logical data models
- Advanced SQL, T-SQL programming skills with ability to write, debug and tune procedures, functions and ETL packages
- Tune database queries for optimal performance
- Work collaboratively with application development teams and business to better understand overall application needs and make recommendations accordingly
- Partner with project teams and interact with customers to find solutions for projects and operational issues for existing and proposed databases environments
- Identify, analyze and solve problems related to database, applications or reporting in a thorough, timely manner
- Develop and document standards, policies, procedures and key performance metrics that support the continued improvement of IT services
- Assist developers with all the database activities
- Perform code reviews and SQL code deployments
- Assist QA Teams in Unit and Stress testing operations
- Anticipate and devise possible solutions to application and database-related problems
- Recommend and maintain SQL Server configurations for both production and development environments
- Assist system DBA team by deploying SQL Server upgrades and service packs
- Assist system DBA team by performing backup, recovery and archival tasks on databases management systems
- Participate in On-Call rotation for critical production support
- Perform all routine scheduled SQL Server and database maintenance
- Expertise with the following technologies: SQL 2008/2012, SSIS, SSAS, SSRS
- Experience working with .Net, C# technologies
- Knowledge and experience working with source code version control systems
- Excellent Data Modeling experience
- Strong understanding of coding methods and best practices
- MCDBA or MCSA database development certification a plus
- Familiarity with other database technologies a plus
- Excellent communication skills a must
- Ability to provide 24x7 support and participate in an on-call rotation
- Minimum of 5 years of experience working as a database developer/architect in a SQL Server environment
- Minimum of 3 years of experience working as a database administrator
- Minimum of 3 years of experience working with large, complex databases in a large enterprise environment
130
SQL DBA Resume Examples & Samples
- Install, configure, and maintain all SQL Server instances across development, staging, and production environments
- Ensure database server topology, configuration, and maintenance are designed and executed to meet SLA objectives
- Advise on DB design, tuning options, and best practices
- Troubleshoot SQL Server service outages as they occur, including after hours and weekends
- Baseline system performance and monitor for deviation, recommending and implementing improvements to slow running queries
- When performance issues arise, determine the most effective way to increase performance including hardware changes, server configuration changes, or index/query changes
- Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
- Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters
- Working knowledge in database recovery from backup in disasters. Implementing Point-In-Time Recovery solutions
- Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files
- Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor(DTA)
- Responsible for monitoring and making recommendations for performance improvement in hosted databases
- This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases
- Experience in Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE)
- SQL server reporting experience (SSRS) to develop DBA related reports
131
SQL DBA Resume Examples & Samples
- Migrate DTS packages to SSIS packages
- Data Warehouse, financial Reporting, Ad Hoc Reporting
- Monitors, optimizes and allocates physical data storage for database systems
- Plans and coordinates data migrations between systems
- Develops, implements and maintains change control and testing processes for
132
Oracle / MS SQL DBA / Developer Resume Examples & Samples
- Drives Database Design, Development of ER models
- Have hands-on experience in PL/SQL, stored procedure, trigger, functions and package
- Write, modify, integrate and test code in PL/SQL, and SQL scripts for deployment on Windows Servers
- Troubleshoot and identify technical problems, in applications or processes and provide solutions
- Prepare reports, manuals and other documentation on the status, operation and maintenance of applications
- Develop, maintain and support existing applications by making modifications as required
- Perform tuning using execution plans and other tools
- Create, execute and document the tests necessary to ensure that an application meets performance requirements"
- Other Skills (Mandatory in Bold) Oracle DB architecture and Oracle DB security
- Oracle, SQL Server
- Industry/Domain Experience (Mandatory in Bold) Mortgage, Insurance, Financial Institutions experience a plus
- Soft Skills Deliver Design Documentation, Experience and Familiarity with SDLC and Agile process, Excellent verbal and written communication
- Create, execute and document the tests necessary to ensure that an application meets performance requirements
133
SQL DBA Resume Examples & Samples
- Manage data import/export to/from multiple sources including non-SQL source systems
- Performance tuning including hardware and code optimization
- Document and communicate system information, findings, and recommendations
- Consulting Sales support including proposing technical solutions to clients, contributing technical elements to Service Orders, and creating project time and cost estimates
- BS degree (computer science or equivalent preferred)
- 5+ years of experience working with SQL Server
- Experience with deploying SQL Server in virtualized environments
- Experience with designing and implementing HADR solutions at Database and Server level
- Experience with migrating MS SQL systems, including location and version migrations
- Experience with database performance monitoring tools like Profiler, Spotlight, Idera, RedGate, SQLSentry etc
- Ability to write and improve T-SQL code at an advanced level
- Ability to plan, organize and work on multiple tasks simultaneously
- Strong written and oral client communication skills
- Ability to lead clients through complex, strategic data solutions
- Understanding of XML
- Understanding of Microsoft Infrastructure Project methodology
- Leadership training and/or experience
134
SQL DBA Resume Examples & Samples
- Manage multiple stand alone and clustered MS SQL instances containing system critical databases
- Design and enforce policies and procedures in accordance with Microsoft® SQL best practices
- Manage and monitor SQL databases and their underlying hardware
- Perform hands-on administration tasks including installing and upgrading SQL software
- Test and implement changes prior to production rollout
- Analyze performance of related activities and documented resolutions, identify problem areas, and devise and deliver solutions to enhance quality of service and to prevent future problems
- Assess need for any system reconfigurations (minor or significant) based on request trends and make recommendations
- Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
- On-call troubleshooting for SQL Server service outages
- Analysis Services, Integration Services, or Reporting Services
- Failover clustering, SAN replication, and other high availability technologies
- Train, coach, and mentor Technicians and other junior staff
- College diploma or university degree in the field of computer science, information sciences, or related field and/or 5 years’ equivalent work experience
- Experience installing, monitoring, and managing MS SQL databases
- Experience with multiple SQL versions including 2000, 2005, 2008 R2 and 2012 R2
- In depth knowledge of MS clustering technologies and high availability groups
- Demonstrated progressive experience supporting multi-tiered applications from Web, app and database layers
- Proven track record of developing and providing Service Level Agreements and deliverables
- Exceptional interpersonal skills, with a focus on listening and questioning skills
- Ability to conduct research into a wide range of computing and database issues as required
- Ability to absorb and retain information quickly
- Ability to present ideas in user-friendly language to non-technical staff and end users
135
SQL DBA Resume Examples & Samples
- Optimization and performance tuning
- Building clusters
- Building availability groups
- Strong knowledge of NetApps
136
SQL DBA Resume Examples & Samples
- Pro-actively monitoring and tuning databases, setting up jobs for backups and database maintenance, monitoring alerts and taking action where necessary
- Setting up HA and DR solutions using log shipping, mirroring, failover cluster and HADR (AlwaysOn)
- Responsible for changing data feeds and database schemas in support of changes
- Perform Query optimizations and assist application developers with their database needs
- Excel in a fast paced, rapid development environment
137
SQL DBA Resume Examples & Samples
- Maintains data integrity by establishing standards, monitoring performance
- Monitor all SQL job failures and fix them if present
- Maintains database performance by developing tuning methodologies
- Be responsible for database backup/restore and disaster recovery
- Perform the ad-hoc data fix tasks in production servers
- Review SQL Server release scripts before releasing to the production servers
- Provides information by collecting, analyzing, and summarizing database performance and trends
- Co-work with Release team to release read-only data to production servers
- Provide advises (samples/answers) to developers from aspect of data base
138
SQL DBA Resume Examples & Samples
- Total 4 to 7 years of It experience
- Experience in SQL Server
- Experienced in setting up SQL Server Replication and Log Shipping
- Must know Backups & Restore
- Good understanding of T-SQL scripts (Stored procedure, Function)
- SQL Server installation and upgrade
- 24*7 support Experience
- BE/Btech/MCA
139
Senior SQL DBA Resume Examples & Samples
- Experience with MS SQL 2008, 2012, 2014, 2016
- Good understanding of Security Access in a MS SQL Server and Enterprise Windows AD environment
- Solid Verbal and Written English communication skills
- Experience with MS SQL Server 2008, 2012 upgrade to MS SQL Server 2016 and MS SQL Server 2014
- Experience with Mirroring and AlwaysOn,
- Familiar with Reporting Services, Analysis Services, and Integration Services
- Experience with standard database maintenance plan jobs
- Experience with standard System Administration tasks including server builds, security updates, software installs and system troubleshooting
- Capacity planning (disk space, I/O, CPU, memory, etc.) to ensure we are properly positioned for growth in a Virtual environment
- Good understanding of MS SQL Server licensing in both a physical and/or virtual environment
140
SQL DBA Resume Examples & Samples
- Identify performance issues and offer proactive solutions and performance tuning
- Responsible for operation and support of production database environments
- Develop and maintain documentation and standards
- Adhere to company standards and best practices
- Maintain high availability of databases
- Monitors database servers and alerts
- Configure and monitor data replication
- Maintain security
- Requires 24x7 availability for operational support
- Bachelor's degree in Information Technology, Computer Science or related field or a proven record of success
- 5+ years of DBA experience in SQL Server
- Strong knowledge of SQL Server 2005-2014 administration
- Experience working in large, complex environment with at least 10 production servers
- Ability to write and tune T-SQL queries to improve performance
- Experience with fail-over clustering, replication, and other high availability technologies
- Development and debugging experience SSIS, SSAS, and SSRS
- Working knowledge of database performance monitoring tools and techniques
- Self-motivated individual that can deliver results with minimal direction and oversight
- Ability to troubleshoot and solve difficult problems
- Ability to work flexible/extended hours
- Have a passion for learning and staying updated on emerging trends and technologies
- No Corp-To-Corp. No C2C.**
141
Ms SQL Dba Resume Examples & Samples
- Qualified candidates will possess a Bachelor’s degree or equivalent in computer science, information systems, or related field plus 5 years of experience as a Sybase DBA
- Implement all necessary configurations, privileges, monitoring and maintenance plans to meet enterprise grade production requirements of our SQL Server instances
- Define, maintain and implement database infrastructure level standards (naming, coding, security, SQL, databases objects)
- Design indexing, referential integrity, constraints, data types, database objects (tables, views, indexes, stored procedures, triggers)
- Build and support MS SQL Server databases databases on Windows systems, including installation, creation, upgrades, backup and recovery
- Work with developers to support application requirements and optimize queries
- Strong T-SQL aptitude
- Experience with data warehousing techniques and best-practices
- Extensive exposure to the Microsoft RDBMS/BI ecosystem (Database Engine, Visual Studio SSDT, SSIS, SSAS, SSRS)
- Experience with analyzing data integrity (e.g., collations/encoding, data constraints/reconciliation)
- Strong understanding of performance analysis and performance tuning and query refactoring
- Ability to work independently and manage one's time
- Experience with Sybase, MySQL and/or PostgreSQL perferred
- Experience with database support in IaaS or PaaS preferred
- Exposure to Hadoop, MongoDB, NoSql and Docker technologies will be a plus
142
SQL DBA Resume Examples & Samples
- Design databases and queries to optimize performance and scalability
- Design, develop and upgrade databases, schemas, automation of data quality rules, optimized queries and indexing
- Maintain technical documentation as system modifications are made
143
SQL DBA Resume Examples & Samples
- Installation, Administration and Maintenance of SQL Server Instances
- Setup Test, Dev, Staging and Production Environments
- Database Space/Storage Management Regular Database Health checks and Monitors
- Incident Management & Problem Management, Simple Database Refresh,
- System and User Database Performance Monitoring, Backup – Execution and Monitoring
- User Access Management
- Administer DBMS Environment, Database Object Privileges , Production Data Access
- Problem Resolution , Maintain/Execute DDL/DML Operations, Database Refreshes
- Execute Documented Procedures/Tasks by client network team
- Performance Tuning Recommendations. Upgrades, Migrations, Consolidation
- DB Server Version & Patch Management, Security Hardening, Data Masking, Encryption, Database Security Design
- DBMS Features implementation e.g. Data Replication, high availability like clustering, Compression etc.,
- Database Archival/Purging strategy , DR Setup designing & Testing , SOP creation
144
Microsoft SQL DBA Developer Resume Examples & Samples
- Responsible for administering access and resources on SQL Server Databases
- Responsible for supporting multiple concurrent developments
- Responsible for configuration management and version control across multiple releases
145
Senior SQL DBA Resume Examples & Samples
- Reviews database design and integration of systems and makes recommendations regarding enhancements and/or improvements
- Monitor system for harmful growth rates, I/O contention, errors in sql .net logs while monitoring for errors and other issues
- Refreshing or Cloning environments as needed
- The ability to multi-task and prioritize is paramount
- Serves as prime consultant and external spokesperson for the organization on highly significant matters relating to policies, programs, capabilities, and long-range goals and objectives
- Development experience or knowledge in .NET Framework and Extended Markup Language (XML)
- Experience working in a government contracting environment
- Experience as a Government contractor
146
Senior MS SQL DBA Resume Examples & Samples
- 5-10 years' database administration experience
- Production and troubleshooting on multi-terabyte environment
- 75 Operational/ 20% Development/ 5% Modeling
- Setting up high availability clustering
- Moving into Azure environment
- Testing and verification
- Performance checks
147
Oracle / MSS SQL DBA Resume Examples & Samples
- 10 %
- Oracle 10g, 11g & 12c RDBMS running on Linux and Solaris Platforms
- SQL Server 2005, 2008, 2008 R2, 2012, 2014
- Good SQL& PL/SQL andT-SQLknowledge
- Good knowledge and working experience of RMAN
- Thorough understanding of High Availability and DR including
- Excellent organisational skills, triage and task prioritisation
148
Engineer SQL DBA Resume Examples & Samples
- Be part of the team responsible for supporting and managing SQL databases for Nordstrom ecommerce site
- Enhance and support SQL databases using cloud infrastructure(AWS), Microsoft technology stacks with a focus on SQL development and optimization
- Perform complex data analysis or troubleshooting/performance tuning, and follow up with design, support, and documentation
- Develop data insertion/extraction logic for REST full APIs/services via SQL queries or sprocs
- Work with defect tracking, source code control and software release systems to ensure high-quality software releases over time
- Collaborate with team for continuous improvement in an Agile development environment
- 5+ years of solid experience in SQL Server, including SQL2012 or SQL 2014
- Experience supporting enterprise-wide high availability systems and services with SLAs
149
SQL DBA Resume Examples & Samples
- Responsible for managing and administering database environment
- Provides technical support assistance to internal application and internal support teams
- Performs database design and development/ maintenance
- Completes database software evaluations
- Performs, plans, and/or leads database projects
- General Database Administration of SQL environments
- Primary responsibility will be administration work in SQL Server (2008 & 2012)
- Conducting performance testing, scripting a must have
150
Ms SQL Dba Sme Resume Examples & Samples
- Provides MS SQL SME support to application development teams in development, test and implementation of re-coding of in house applications to facilitate cloud readiness and reference architectures
- Work and collaborate with enterprise and technical architects in the process of solution design
- Troubleshoot issues, see problems through to resolution
- Investigate and research tools and technologies for achieving goals
- Ability and desire to learn new technologies
- MS SQL SERVER 2008/2012
- Mass data migration & application transformation experience
- Very good understanding of DevOps, Microservices and SOA
- BFS background preferred
- Knowledge and understanding of AWS technologies such as Amazon EMR, DataPipeline etc
- Experience with basic system management functions on Windows servers
- Experience with NOSQL platforms, such as MongoDB, Cassandra
151
Oracle / SQL DBA SME Resume Examples & Samples
- Provides technical support to application development teams in development, test and implementation of re-coding of in house applications to facilitate cloud readiness and reference architectures
- Communicate effectively with team members, customers and stakeholders
- ORACLE PL/SQL – SQL
- Understanding of PostgreSQL database
- Knowledge of .Net or Java
- Mass migration & application transformation experience
- Experience with basic system management functions on Linux & Windows servers
- Experience with AWS Services such as AWS RDS, Data migration service
- Experience contributing to an open source project
152
SQL DBA Resume Examples & Samples
- Configuring Databases
- SQL Server support
- Monitoring of Database
153
SQL DBA Resume Examples & Samples
- Ongoing Operational Analytics
- Discover, acquire, and analyze new data sources
- Manage Prod & Test Azure and Agile Labs Infrastructure
- Patching/ Software Install
- Monitor data warehouse and reporting functions
- Software and Systems Testing
- Data quality & Testing
- Monitoring new assets changes and deletions
- Update schema, database, and stored procedures
- Write & Update SSIS Packages
- Write & Update PowerShell scripts to acquire data
- Reporting/ Visualizations
- Develop and Maintain API
- Work with business owners for data quality and remediation efforts
154
SQL DBA Resume Examples & Samples
- 8-10 Years of experience as a SQL Database administrator (DBA)
- 2-3 years of data encryption experience (Transparent data encryption) - Encryption tool used for protecting data
- Understand data corruption and troubleshooting encryption problems
- Provided 24x7 operation support on all the Production, Test and Development databases
- Encrypt thousands of small, large and very large databases using SQL Server native encryption
- Troubleshoot and resolve database availability, connectivity, performance issues, and security issues
- Troubleshoot application related issues, timeouts, deadlocks, and maintain application performance
- Ensure all databases are backed up to meet the business's Recovery Point Objectives (RPO)
- Perform database restores as needed, either in production or to refresh test/UAT environment databases
- 8-10 years of experience in managing all aspects of SQL Server database administration
- Experience with SQL server 2008/2008R2/2012/2014 is must
- Must be familiar with Always On availability group configuration and operataion
- Experience with implementing TDE on databases in always on available groups
- Ability to understand the Company's products and process, regulatory and competitive environments
- Ability to work independently in a continually changing environment; and
- Strong presentation skills, including verbal and written communication skills
155
Junior SQL Dba Resume Examples & Samples
- Ability to obtain and maintain Secret clearance
- Baseline 8570 compliance of Security +ce with ability to earn computing environment cert within 6 months of hire
- 1-3 years of SQL Database Administration experience
- Experience with Oracle and/or PostgreSQL and plus
156
SQL DBA Resume Examples & Samples
- There is not one specific project that will be assigned to day 1. This person will support several ongoing projects and databases until they get the hang of the environment, then they will be given new projects and assignments that fit their strengths within the team
- Perform database management software system upgrades
- Design, implement, and maintain multiple SQL Server databases
- Control user access to databases and ensure connectivity to databases
- Identify performance problems and modify databases to improve performance
- Performance tuning and optimization, identify performance issues
157
Senior Dba-SQL DBA at Resume Examples & Samples
- Database software certifications, roadmap planning and maintenance management
- Handles and participates in various medium to large scale or data/database management activities including one or more of the following
- Application Software support
- Documentation/Regulatory requirements
- Remotely managed servers overseas, including
158
Senior DBA 1-SQL DBA Resume Examples & Samples
- Develop operational policies, procedures, controls and standards
- Develop, implement and maintain automation efficiencies using scripting languages (T-SQL, Powers hell) in a Windows environment
- Develop and maintain implementation guides and maintenance processes and documentation
- Database software certifications, roadmap planning and maintenance management
- Perform database environment capacity planning and availability management
- Collaborate with partners to resolve company database policy compliance and vulnerability violations
- Provide 24x7 on-call support for complex production problems to include experience with escalation and communication of the problem to senior management
- Consult with and advise management on high impact database solutions and database management topics
- Consults with multiple groups in concert with senior level DBA and management oversight on initiatives that could have enterprise impact
- Participates in the planning, analysis, design, implementation, maintenance, and control of the organization's server-class databases
- Consults with and advises management and multiple clients on high impact data or database management issues with direct oversight from the senior DBA’s on the team
- Handles and participates in various medium to large scale or data/database management activities including one or more of the following
- System Monitoring
- Installation Services and Management
- OS administration; User Administration
- Application Software support
- Facilities Management
- Security Services; Back-up Services
- Hardware services/management
- Documentation/Regulatory requirements
- Remotely managed servers overseas, including
159
SQL DBA Resume Examples & Samples
- The Database Administrator will perform all DBA duties including: backups/restores, server monitoring and configuration, security and permissions management, scheduling jobs/tasks, query optimization, index maintenance, performance monitoring, and HA/DR planning and implementation
- The Database Administrator will implement proactive database monitoring and alerts to maintain data integrity and application performance
- The Database Administrator will evaluate new technologies and provide recommendations to improve existing processes
- The Database Administrator will maintain data quality and security by establishing and enforcing organization standards
- The Database Administrator will install and configure new SQL Server environments, including failover clusters
- The Database Administrator will coordinate with IT to test and roll-out Windows and SQL patches/upgrades
- 4+ years of experience in supporting large OLTP data driven applications in a production environment
- Experience with MS SQL Server 2008, 2008 R2, and 2012
- Comfortable dealing with very large databases (500GB+)
- Ability to perform analysis to identify performance improvement areas and tune databases for optimal performance
- Experience with High Availability and Disaster Recovery solutions in SQL Server, including WSFC, AlwaysOn Availability Groups, and Log Shipping
- Ability to analyze problems and provide root cause analysis and recommend preventive and corrective actions
- Understanding of SQL Server Policy Based Management and Extended Events
- Familiarity with ETL processes (SSIS or other) and ability to develop data migration plans
- Experience with third-party SQL monitoring tools (Idera, Redgate, etc.)
- Experience with the following technologies are a plus: Powershell, Azure SQL Database, AWS Redshift, ITIL
- Excellent written and verbal communication skills with the ability to present complex technical information in a clear and concise manner
- Strong organizational skills along with an attention to detail
- Ability to work independently with minimal supervision in fast-paced environments
160
Senior SQL DBA Resume Examples & Samples
- 5 or more years SQL Server Database Administration experience (2008, 2008R2, 2012, 2014)
- Proven experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, and security issues
- Proven experience of backups, restores, recovery models, and database maintenance tasks
- Proven experience in Performance Tuning and Query Optimization
- 10 or more years SQL Server Database Administration experience
- Ability to detect and troubleshoot SQL Server related CPU, Memory, I/O, disk space and other resource contention
- Performance Monitor
- Knowledge on SQL native monitoring tool SCOM
161
Senior SQL DBA at Resume Examples & Samples
- Develop, implement and maintain automation efficiencies using scripting languages (T-SQL, Powers hell) in a Windows environment
- Facilities Management
- Security Services; Back-up Services
162
SQL DBA Resume Examples & Samples
- 3+ years of experience working as a SQL DBA
- Experience working with SSAS/SSIS
- Ability to tune queries and worked with T-SQL
163
SQL DBA Resume Examples & Samples
- Development and support of SQL Server environments
- Develop multiple SQL Server production, test and development environments
- Support multiple environments with data refreshes and replication monitoring
- Create and configure new databases as needed by operations and project teams
- Assist with creating new replication subscriptions and destinations
- Upgrade SQL Server databases with patches and version upgrades
- 5+ years working experience in
- Specialist Microsoft SQL Server Core Database Administration
- SSRS, SSIS, SSAS, SSMS and Transparent Data Encryption TDE
- Strong technical skills and communication skills
164
SQL DBA Resume Examples & Samples
- 2) Must have experience in Data Warehouse implementation
- 3) Must be able to read .NET Code
- 4) Can be hired fulltime if necessary
- 4+ years database design and administration experience
- 2+ years .NET Software development
- 4+ years data warehouse design experience
- 4+ years’ experience or equivalent combination of education and professional experience. 4+ SQL Server development, including strong knowledge of SQL Server 2012/2014, T-SQL, SSIS and database modeling tools
- 4+ years’ experience designing, maintaining, and supporting high available, high volume production systems
- Demonstrated advance database development skills (DTS / SSIS)
- Demonstrated advanced problem solving and analysis skills
- Demonstrated advanced database performance / analysis
- Demonstrated experience in clustered environments
- Demonstrated experience participating in the planning, design and usage of data resources
- Demonstrated experience providing support to development team on infrastructure and DBA Support
- Identifiable organizational and task prioritization skills (detail oriented)
- Proven ability to provide in-depth consulting services in the identification and resolution of database issues
- Candidate must possess self-motivation and strong communication skills (oral and written) to manage customer relations with emphasis on verbal and written communication. Candidate should be able to communicate with upper management using nontechnical terms to discuss technical issues
- Experience as a DBA in SQL Server 2012/2014 both single instance and clustered
- Experience with SQL Server 2012/2014 R2 Analysis Server
- Experience with Microsoft CRM 2016 -Experience with performance monitoring, Database and SQL tuning
- Demonstrated experience cross training and providing support for other applications and RDBMS Platforms
- Ability to work off-hours, when required
- Installation experience with DBMS software
165
SQL DBA Resume Examples & Samples
- Administer DBMS Environment, Database Object Privileges, Production Data Access
- Problem Resolution, Maintain/Execute DDL/DML Operations, Database Refreshes
- Database Archival/Purging strategy, DR Setup designing & Testing , SOP creation
166
Senior MS SQL DBA Resume Examples & Samples
- Migrate databases from legacy datacenter
- Manage Application and User Accounts
- Devise implementation plans for tasking
- Test backup strategies and implement database recovery techniques when required
- Document database actions
- Build database systems of high availability and quality depending on each end user’s specialized role
- Define users and enable data distribution to the right user, in appropriate format and in a timely manner
- Use high-speed transaction recovery techniques and backup data
- A Bachelor’s degree in Computer Information systems or and IT related field and five (5) years of recent database administration with MS SQL Instances and databases experience is required
- Must have the DoD 8570 IAWF required certifications (Security + and OS Certifications)
- Familiarity with SQL Server Management Studio, SQL Server Policy Management, and SQL Server experience is required
- Data recovery and space requirements /capacity planning for physical database and the ability to install client/server software and patches are required
- Trouble shooting database issues and optimize performance experience is required
- Must be able to configure, maintain and troubleshoot database replication (transactional and snapshot)
- Strong experience with SQL Server 2008/2012/2014
- Familiarity with SQL Server Integration Services, Policy Management
- Clear understanding of and ability to implement Linked Servers and Aliases
- Strong communication, interpersonal and human relations skills to interact with clients
- Ability to pay meticulous attention to detail
- Ability to work collaboratively on multi- disciplinary teams
- SQL Database: 5 years
167
SQL DBA Resume Examples & Samples
- Manage and control all daily operational activities related to database management and administration
- Assist the software development team in managing performance issues in all custom code released to the production environment
- Must be able to effectively communicate with both internal and external clients at all levels
- Perform database upgrade and patch activities
- Perform data migration and cloning activities
- Monitor and tune the database and associated applications and systems for optimal performance
- Manage database objects, including tables, clusters, indexes, views, and procedures in both a MS SQL and MySQL environment
- Perform backup/recovery of databases and develop contingency plan for disaster
- Act as primary resource with software vendors for resolving problems
- Monitor and report database capacity and performance metrics
- Assist in the evaluation of software addition and/or upgrade as required to maintain performance standards and databases
- Document Database Setup and administration of Server Environment
- Provides project, production and on-call support during off hours. Will work on-call for DBA rotations in a 7x24 environment, and expected to handle a mix of database management and engineering responsibilities
- Drive continuous improvement while insuring that all application systems and procedures are planned, built, maintained, executed, etc. in accordance with company standards
- Adherence to and compliance with information systems security is everyone’s responsibility. It is the responsibility of every computer user to know and follow Information Systems security policies and procedures. Attend Information Systems security training, when offered. Report information systems security problems
- Effective information systems security is a team effort involving the participation and support of every EVHC employee who deals with information and/or information systems. It is the responsibility of every Information Systems employee to attend Information Systems security training, when offered. Comply with Information Systems security policies, standards and procedures. Use all available protections to safeguard computer systems under their charge from unauthorized access. Report all suspicious requests, incidents, and situations
168
SQL DBA Resume Examples & Samples
- Clustering/Performance tuning
- Backup experience is a must
- Development background; SQL packages, SSIS/SSRSPlease contact Katherine Meffered at kmeffered@apexsystemsinc.com or (480) 368-2480
169
SQL DBA Resume Examples & Samples
- Enterprise level SQL Server Environment-with replication and clustering experience
- Performance Tuning/Trouble shooting
- Database Design
- Stored Procedures- This person needs to be proficient with T-SQL
170
SQL DBA Resume Examples & Samples
- 2) Operations tasks, including replication, clustering, log shipping, mirroring, moving to "Always On"
- 3) Must have experience on the following platforms, Windows 2012, SQL 2012, moving to SQL 2016 and Windows 2016 so 2016 experience is a plus
- 4) Experience virtualizing SQL on VMware
- 1) ITIL Methodology is a plus
- 2) SQL Reporting Services (SSRS) or SQL Analysis Services (SSAS) (Having one of these is also a plus)
- 3) Commvault is also a nice to have
171
Junior SQL Dba Resume Examples & Samples
- Monitors performance of database systems resources and query throughout
- Optimizes SQL Code as necessary
- Monitor and maintains database storage resources
- Monitors and maintains database maintenance plans for backups, index rebuild/reorganize, and database statistics
- SQL Server Installation, Upgrades, Migrations, and Configuration
- Installs database software service packs and cumulative updates as necessary
- Maintains database documentation as required
- Maintains and administers database security access
- Performs database ad-hoc backups and restores
- Troubleshoots and resolves database connectivity issues
- Follows Change Management processes to implement database configuration changes
- Follows Problem Management processes to troubleshoot and resolve recurring issues
- Proactively monitors and response to MSSQL database Alerts
- Performs on-call requirements to ensure 24 x 7 support of database operations
- Acts as a positive role model in all aspects of professional performance
- Observes safety procedures and personnel policies
172
HP Nonstop SQL DBA Resume Examples & Samples
- Full-time position based in Milwaukee
- On-Call rotation for general NonStop systems support
- Emergency call-out as resident SQL specialist
- Prior working experience with HP NonStop systems
173
Entry Level SQL Dba-ts-sci Resume Examples & Samples
- Administers MS SQL 2012 database organizations, standards, controls, procedures, and documentation
- Implements and maintains databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation, and statistical methods. Includes maintenance of database dictionaries, and integration of systems through database design and implementation
- Ensures that documentation is complete and up-to-date. Develops and applies procedures for periodic database backup
- Experience with and knowledge of advanced data mining techniques
- Candidate must be able to create data maps and load data and databases onto servers
- Candidate must be familiar with MS SQL syntax
- Experience with scripting for the purposes of data manipulation and automating redundant tasks
- Aptitude for learning new scripting languages and database syntax and the ability to implement those new skills
- Candidate must be fully proficient in the use of PC’s and all programs included in the Microsoft Office application suite
174
SQL DBA Resume Examples & Samples
- 5+ years experience with MS-SQL administration and development functions is required
- 3+ years experience administering enterprise-level production MS-SQL servers and databases
- Expert knowledge of DBA techniques and day to day job functions is required
- Hands on experience with SQL Server 2008/2012/2014 is required
- Experience with Source Control and code release process
- Experience in working with and troubleshooting SSIS packages
- Experience with data mining, monitoring, and tuning with very large data sets is a plus
- Previous experience with Red Gate database tools is a plus
- Previous work with Agile Scrum environment is a plus
- Ability to utilize various tools to troubleshoot DB Environment
- Ability to efficiently tune, debug, troubleshoot SQL code
- Proficient understanding of code versioning tools such as {{Git / Mercurial / SVN}}
- Be able to collaborate effectively, work closely within a coordinated team environment, and maintain composure while dealing with time sensitive deadlines
- Ability to perform under pressure and juggle multiple projects at the same time