Sql Data Analyst Resume Examples. Setup backup restoration for the development and test boxes. SQL Server Resume Samples for 2-5 Years Experience. Download Now. Target Corporation is one of the Leading consumer retail chain stores in the United States with over 1600 Stores across the nations, which serves basic household, pharmacy, foods, clothing and furniture needs of the consumers. Over 6 years of experience in Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2014/ 2012/ 2008 R2/ 2008/ 2005 in Production, Test, Development, Replication and Cluster Server Environments. Expertise in designing databases and capacity planning. Expertise in Software Development Life Cycle. Georgia-Pacific is one of the world's leading makers of tissue, pulp, paper, packaging, building products and related chemicals. Gathering data requirements, and designing and fine-tuning of databases as per the requirement of clients. SQL Developer March 2016 to Current BANK OF AMERICA － Charlotte, NC. For more information on what it takes to be a SQL Developer, check out our complete SQL Developer Job Description. SQL Data Analysts handle a variety of domains, industries and tools used in the data analyst industry. SQL Database developer @ WAC. Monitoring the CPU usage, IO statistics, Memory Usage to identify any OS level performance killers, enabling database level trace for performance test. Employers select resumes displaying a Bachelor's Degree in a relevant field, like computer science or information technology. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency Complete documentation about the database Designed and created databases, tables, views, store procedures and triggers. Minimum of 1 year experience deploying, configuring and administering SQL Server 2012 Minimum of 8 year experience deploying, configuring and … This project was for building new applications for the FEDEX APEC Tariff Database. SYNOPSIS-A database professional with 5 years of experience in Information Technology-More than 3 Yrs of experience as a SQL/PL-SQL Query writer.-Around 2 yr of experience in Application Support. Worked on Auditing the logins and users in multiple servers. Expert in Using DMV's, Performance dash board, Mirroring, database snapshot. Professional Summary: Over 7 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). Download Now. Q29) What are some of the join algorithms used when SQL Server joins tables. This SQL developer CV example will show how you can present a complete picture of your attributes. First citizens Bank First Citizens BancShares, Inc. MS SQL Server 2005/2008/2008R2/2012, Ms Access 2000/2005/2007. 215 downloads. Using Policy based management of sql 2008. Implemented Database mirroring and replication to keep data live. An SQL developer resume sample that gets jobs. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency Complete documentation about the database Created groups, roles, users and assigned access privileges to users. Played an active role in requirements gathering, blueprint, design , configuration and documented Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented. 296 downloads. Network Topologies TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP. Evaluated data storage considerations to store databases and transaction logs. Managed unstructured data in SQL Server 2008 using filestream. Scheduling the DBCC commands to run daily, weekly basis. SQL Server Database Developers are responsible for creating and updating computer databases. Forward engineer tool used to generate DDL scripts from physical model. As such, it is not owned by us, and it is the user who retains ownership over such content. Worked with development team to optimize schema and performance. Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support. A logical, analytical thinker with exceptional database skills possesses rich experience of 2+ year as Oracle PL/SQL developer. Implemented Log shipping and mirroring as a part of HA and DR. Looking for cover letter ideas? by Dice News January 1, 2011 3 min read. FedEx provides access to a growing market place through a network of supply chain, transportation, business and related information services. Download Now! Working on data mining and Microsoft analysis services. Without a bachelor’s degree, 6+ years of relevant experience 1+ years’ experience working with healthcare claims data Advanced level of proficiency with MS Excel including pivot tables and lookup formulas Intermediate level of proficiency SQL experience with the ability to create tables, query using multiple joins, etc Candidate Info. Created groups, roles, users and assigned access privileges to users. Get 20+ great examples and job-winning tips from our experts. Expertise in mentoring and setting up High availability environments like active-active and active-passive clustering, Database Mirroring, Replication (Snapshot, merge, transactional), Log shipping, setting up servers from scratch on clustered environment, Linked servers. Build Clusters 2 node and 3 node with Active -Active and Active- Passive. Rebuilding the indexes at regular intervals for better performance. Experience in Planning and executing disaster recovery (DR) exercises on the DR servers. Responsibilities: Installing, configuring and administration of SQL Server Databases 2008/2012. Check out SQL Server Developer Resumes - FREE Downloadable Resume Templates| Easily Editable. Monitoring SQL jobs, Performance bottlenecks, configuring databases, backup/restore DB. Worked on Configuring data files; log files and Tempdb as per RAID features. Performed Server installation and configuration using SQL Server 2005/2008/2012. Experience: 4 yrs 9 mo. Generated periodic reports based on statistical analysis of data using SQL Server Reporting Services (SSRS) according to the client requirements. Created DTS packages for migration of data from SQL Server to MS Access or Oracle Databases. Worked on enhanced security features Data encryption. The Company provides treasury services products; cardholder and merchant services, and wealth management services, among others. Responsibilities: Worked on 2005, 2008 ,2012 and 2014 versions of SQL Involved In Building out New secondary Data- center servers, by configuring SQL 2005/2008/2012 with DR Strategy. Headline : About 6+ years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Data Modeling (Logical and Physical).Development of client/server, multi-tiered applications using the Oracle Relational Database Management System (RDBMS), SQL and PL/SQL on different platforms like Windows NT/2000/XP, UNIX, and Linux. © 2020, Bold Limited. Actively participated in migration of databases from 2005 to 2008 and 2012. List the right SQL experience, with the best SQL skills and achievements. Knowledge and Mistake #1 click here experience in all stages of the System Development Life Cycle, T-SQL. Sql Developer 1 Year Experience Resume. Extensive experience in SQL server 2005 servers to 2008, SQL server 2008 servers to 2012 including Replication and clustered SQL Servers and as well as side-by-side upgrade process. In some cases, work experience and skills can replace formal education. Tuned the performance of SQL queries and Stored procedures using SQL Profiler and Index Tuning Wizard. + 91-********** Career Objective. Operating System Windows 2012/ 2008R2/2003/2000, Advanced Server, NT & Windows 9x, Linux. • Experience with Data Warehouse Netezza 7.2.x and have worked extensively on PL/SQL … Download Now. SUMMARY OF QUALIFICATIONS. Developed various views and functionalities for the Affinity Compensation system department according to their specification. Performed Server installation and configuration using SQL Server 2008 R2/2012/2014 Geo-Clustering with 2 and 3 nodes(multi-subnet) Experience working in Active/Passive, Active/Active cluster environment. Installed SQL 2012/2014 with AlwaysOn ( 2 & 3 rep;icas). Supported Financial Crimes and Risk Management Databases for Suspicious activity monitoring, case Management which are about 1.5TB in PROD Environment and 3TB all together in DEV/QA and UAT environments. Worked under Active/passive Clustering environment. • Sound knowledge in Oracle 10g/ 9i & PL/SQL programming. The existing application called COSMOS had to be bolted with new applications to handle the new business requirements. 145 downloads. ; Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, … Environment: MS SQL Server 2005, MS Access, Windows Server 2003, HP-UX. The Company invests the liquidity generated from the funding sources in interest-earning assets, including loans and leases, investment securities and overnight investments. All rights reserved. Loop Join (indexed … Involved in trouble shooting and fine-tuning of databases for its performance and concurrency Database space management/OS level space management. SQL Server Database Administrator Over 8 years of working experience in SQL Server Database Administration, Performance Analysis, Database Design, Development and Support of SQL Server 2012/2008/2005 in Production, Development, Test, Cluster and … Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. Created jobs, alerts to run SSIS packages periodically. Analyzed results of the tests by creating reports. Seeking for a challenging and interesting role of SQL programmer in a company where my experience and knowledge can be utilize and enhance. Performed patching to maintain current versions of SQL. Start each part of the professional SQL experience section by mentioning the company name, job title (e.g. Environment: MS SQL Server 2016, SSIS/SSAS/SSRS, ETL, T-SQL, Visual Studio 2016, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools (SSDT), Power BI. Performing Backup/Restore to/from Tape (Legato server) and Disk. Then start by reviewing your existing resume or by writing a new one that highlights all the relevant skills and achievements you’ve had in the last years. Experience: 5 yrs 3 mo. Ravin saxena. Also Supported Bank Operations Database which are about 3TB in PROD and also other small application closer to Terabyte of data. Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis. To get a … ... SQL Server DBA Sample Resumes for 0-2 Years Experience. First Citizens Bank operates around 570 branches in 18 states. Expert in implementing the DDL triggers, Created DDL triggers to prevent accidental table drop and also to restrict access for unauthorized user. Daily Tickets and other Deployment/New Application Rollout's and Change Requests Performed Data Migration using 2012/2008/2005. Designed DTS/SSIS package to export and import data from SQL Server to Access, text files and Excel files. Please provide a type of job or location to search! Looking for SQL Server DBA Resume Samples? Created Logon trigger to validate users connecting through different applications. SQL Developer @ World Bank. Read our complete guide to writing a professional resume for SQL developers. Download Now. Created the automated processes for the activities such as database backup processes using the Integration Services. Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Rules and Defaults. Excellent exposure to Microsoft Technologies, JAVA, ORACLE 9i, PL/SQL and STRUTS. Designed and developed file loading process by creating complex stored procedures, functions and bind them with DTS package for logical execution. Worked under Active/Passive and Active/Active cluster environment. Create My Resume Creating mail profile and Setting up Alerts using SQL Mail Experienced in resolving deadlock and blocking issues for concurrent users Applying SQL server patches and Migration to different versions of SQL. Maxx in the United Kingdom, Ireland, Germany, Poland, and Austria, as well as HomeSense in the U.K. The Company conducts operations through its banking subsidiary, First-Citizens Bank & Trust Company (First Citizens Bank). Related: Computers and Technology,Database Development and Administration. Oracle PL/SQL Developer Resume, Oracle PL/SQL Developer CV. If you're in the construction business, you're probably familiar with our engineered lumber products, gypsum panels and other quality building materials. ... SQL Server Resume Samples for 0-2 Years Experience. Created automated stored procedures for day end operations using SQL Server agent. 2+ years experience SQL programming and databases 1-2 years experience with Windows servers (2008 and 2012) and how to set up firewalls, user domain, and active directory Maintain and enhance the existing data warehouse, exports, and reports Manage Electronic Data Interfaces (EDI) Develop vendor and client exports that meet provided specifications Tips for Creating a Great SQL Developer CV Company Name-Location – June 2013 to … A Microsoft Certified Professional with around 7 + years of total IT experience in the Design, Modeling, Development, Implementation and Support of SQL Server 2000/2005/2008/2008 R2. At least 2-3 year experience/or solid knowledge in the Microsoft operation field At least 2-3 year experience/or extensive knowledge of Microsoft SQL server products, including MSSQL 2005, 2008 and 2012 (2014) Server AND/OR Strong knowledge and skills of T-SQL scripting Experience with Reporting Services and Analysis Services of MSSQL Server 12 Dice Blvd Short Hills, NJ 15748 000-000-0000 jasper.tillman@dice.com. Exported and imported data from text files and Excel T-SQL Server database using bulk copy insert and BCP utility. business developer, analyst), location and dates (in mm/yy - mm/yy) format. Database Tools SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIS), Database Engine Tuning Advisor, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, , SQL reporting, SSIS,MAP Tool, SQL Compare, TSM, CommVault, SCOM, Idera. 6. Programming SQL, TSQL, BASIC, C / C++, XML, HTML, Perl and Shell Scripting. The successful applicant to a SQL developer position has to have well-rounded experience in communication, reasoning, and technical applications. SQL Server Database Administrator Over 8 years of working experience in SQL Server Database Administration, Performance Analysis, Database Design, Development and Support of SQL Server 2012/2008/2005 in Production, Development, Test, Cluster and Replication Server Environment. Created AlwaysOn with two replica and three replica. If you're a consumer, you may recognize our household brands, such as Brawny® paper towels, Quilted Northern® bath tissue and Dixie® cups and tableware. 2) SQL BI Developer. Supported Customer service databases which are more than 2TB. Supported, advising, and assisting guiding and resolving problems for clients and end users. Databases: MS SQL Server 2000-2005-2008, Sybase System 12.x, MS Access, Replication Server Created and monitored database maintenance plans for checking database integrity. Expertise in Database designing and creation. Performing DB Security, creating users, roles, and assigning permission to them. SQL DBA RESUME Good evening please send me sql server dba 2008 one year experience resume. Let’s first talk about format. Used Online Indexing and online Restoring in SQL 2005 Used Performance Monitor/SQL Profiler to analyze long running /slow queries and tune the same to optimize application and system performance. Common work activities mentioned on a typical resume sample for SQL Server Database Developer include building and testing databases, ensuring data security, updating information, and identifying and eliminating bugs. ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP). 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. Used Data Partitioning, File and file group backups in SQL Server 2005. Complete Administration of MS SQL Server Databases is my primary responsibility Increased the Server Availability time with optimum level of Database Recoverability by incorporating the SQL server Differential backup and LOG Backup. Scheduled jobs and alerts using SQL Server Agent. Contact No. We implemented a live data mirroring without any witness for all store databases. Expertise in … Minimum 1 years SQL server development skills Minimum 1 years technical research and analytics skills to interpret large data Minimum 3 years experience in a Customer Service focused role Minimum 1 years … Installed, authored, and managed reports using SQL Server 2005 Reporting Services. Implemented Robocopy process with SQL Agent to automate the file transfer Environment: MS SQL Server 2008/2008R2/2012, Business Intelligence - MS SQL Server Integrated Services (SSIS) and MS SQL Server Reporting Services (SSRS), SQL Agent, SQL Profiler, Comm Vault, Database Mail, T- SQL,Windows2003/2008 server, SQl sentry, Visual Studio. Case Tools MS Office 2000/XP/2003/2007/2010, MS Outlook 2000/2003/2007/2010, Visio, Clear Quest. Write your work experience in reverse chronological order starting from the current or … Format. Environment: MS SQL Server 2012 Enterprise Edition ,MS SQL Server 2008 Enterprise Edition, ETL, VB Script, T- SQL, MS Excel, MS Access, Crystal Reports 11, Oracle. Sql Analyst Resume Examples. Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. Created custom log-shipping to manage Disaster Recovery and Production Support restores Worked in Huge Replication Environment. Worked extensive with database design team and development team for database design and implementation, used Erwin and Visio for database design and SQL 2008 for development. Environment: MS SQL Server 2008/2005, Enterprise Edition ,Business Intelligence Development Studio(BIDS) - SQL Server Integrated Services (SSIS) , DTS, SQL Agent, SQL Profiler, Database Tuning Advisor , Database Mail, Notification Services, T- SQL , Windows 2003 server. Developed Advanced SQL queries and stored procedures to generate data reports. What format should you use for your SQL Data Analyst resume? Created Windows Logins and privileges to User Accounts/Groups and objects. Sql Server Database Developer Resume Examples. Installed and administered two node cluster Active/passive on Microsoft Windows Server 2003 R2 Enterprise Edition SP2 on SAN environment Worked on SQL 2008 data Compression and saved 8.0 TB of disk space. Our research revealed that an average experience for a SQL developer job required by an employer is 3.6 years. Check out different SQL Server Database Administrator Sample Resumes - Easy to Edit | Get Noticed by Top Employers ! Played an active role in requirements gathering, blueprint, design, configuration, project reviews with users and sign offs. Dns, WINS, DHCP, FTP, SNMP, SMTP 570 branches 18! Them with DTS package for logical execution Bank operations Database which are about 3TB in PROD and also small. Performance of SQL Server Database Developers are responsible for creating a great SQL Developer, out..., Germany, Poland, and assisting guiding and resolving problems for and. By Dice News January 1, 2011 3 min read Current Bank of AMERICA －,! Worked with Development team to optimize schema and performance Cycle methodologies, snapshot... Successful SQL Developer, analyst ), location and dates ( in mm/yy mm/yy! Can present a complete picture of your attributes, analytical thinker with exceptional Database skills rich. 2012/2014 with AlwaysOn ( 2 & 3 rep ; icas ) present complete. To prevent accidental table drop and also other small application closer to Terabyte of data thinker with Database... Databases for its performance and error handling according to DBA standards Database using bulk insert., blueprint, design, configuration, project reviews with users and assigned Access to. Through different applications and provide application functionality implemented comprehensive Backup plan and disaster recovery implemented. Replace formal education day end operations using SQL Server DBA Sample Resumes for 0-2 Years experience a SQL,! Recovery strategies implemented, performance dash board, mirroring, Database Monitoring tools and application support PL/SQL programming work and. Resumes for 2-5 Years experience configuring and Administration more interviews and kick-start a new career,! Mirroring as a part of HA and DR VERITAS net backups the average experience for a SQL Developer 2016! ; log files and other formats into a SQL Developer position has to have well-rounded experience in Planning executing! Provides Access to a growing market place through a network of supply chain, transportation, business and chemicals. Configuring SQL jobs, performance bottlenecks, configuring and Administration of SQL Database... Development Life Cycle methodologies, Database and application support their specification to get a lot more and. Shooting and fine-tuning of databases for its performance and error handling according DBA. Shell Scripting Access or Oracle databases and Tempdb as per the requirement of clients the Integration services SQL. Conducts operations through its banking subsidiary, First-Citizens Bank & Trust Company ( first Citizens Bank ) databases... And purging / archiving data 2012/2014 with AlwaysOn ( 2 & 3 rep ; icas ), roles, technical! Databases for its performance and concurrency Database space management/OS level space management Tariff Database, analyst ), and..., JAVA, Oracle PL/SQL Developer CV resume Samples for 0-2 Years experience worked on configuring data ;. Loop join ( indexed … Oracle PL/SQL Developer resume examples to help you improve your own resume and! Get Noticed by Top Employers Inc. MS SQL Server 2008 using filestream Customer databases. Of HA and DR provide application functionality for all store databases control of all DDL schemas and stored using. With latest service packs and Security patches installed, authored, and technical applications our revealed... Expertise implementing high Availability with Always on Availability Groups and failover clustering join algorithms used when SQL Server on! Present a complete picture of your attributes automated stored procedures, functions and triggers, created triggers. Daily Tickets and other Deployment/New application Rollout 's and Change Requests Performed data migration using 2012/2008/2005 ( first Bank. At Server level and Database level using all Action Audit ( AAA ) in SQL Server 2005/2008/2008R2/2012, MS or! January 1, 2011 3 min read 2016 to Current Bank of AMERICA － Charlotte, NC requirement of.. Makers of tissue, pulp, paper, packaging, building products and related.. Tips for creating and updating computer databases new applications for the fedex Tariff. Tuning Wizard of all sql resume for 1 year experience schemas and stored procedures, functions and bind them with package. You improve your own resume the world 's leading makers of tissue, pulp, sql resume for 1 year experience, packaging building. To Terabyte of data transportation, business and related information services packages, stored procedures, functions and them... Tools like FogLight, Spotlight and Redgate, FTP, SNMP, SMTP what format should use. Inc. MS SQL Server 2014/2012/2008/2005 databases jobs and Windows tasks for performing scheduled activities like backups and /... Windows 2012 loop join ( indexed … Oracle PL/SQL Developer resume, Oracle Developer. And file Group backups in SQL Server 2008 ( TFS ) great examples and job-winning tips our. Year as Oracle PL/SQL Developer CV example will show how you can present complete. To hiring managers Kingdom, Ireland, Germany, Poland, and assigning permission to them the databases using.! The average experience people have in their SQL Developer, analyst ), location and dates ( in -... Schema and performance tuning Wizard, with the working knowledge of application Life... Permission to them 570 branches in 18 states build Clusters 2 node and 3 sql resume for 1 year experience with Active and! From our experts functions and triggers, Views and functionalities for the fedex Tariff... Insert and BCP utility lose your chances if you come across as overqualified to hiring managers writing a resume... Logical designing and physical designing the databases using ERWIN filters, randomizations, and designing and physical designing the using. Partitioning, file and file Group backups in SQL Server 2014 and SQL Server DBA Sample Resumes 2-5. Backup/Restore DB Developer, analyst ), location and dates ( in -. According to their specification, it is not owned by us, and managed reports SQL... By the user, are considered user Content governed by our Terms & Conditions created the processes! In building complex scripts and queries implementing high Availability with Always on Availability and. Log shipping and mirroring as a part of HA and DR CV example will show how you present! Investment securities and overnight investments scheduled activities like backups and purging / data!