Environment : Windows 2000/2003/2008, Linux. Ms SQL Server DBA experienced interview questions and answers - 2. EXPERIENCE SUMMARY - Around 3+ years of experience in PL/SQL Programming (ORACLE 10g/11g) - Working as Software Developer at Bangalore since Septmber-2012 to Till Date. A lot of our hires are self taught people, who are passionate about SQL. Having XXX Years of IT experience as an ORACLE PL/SQL Developer, involved in Requirement Gathering, analysis, Design, Development, Unit Testing , Production Deployment and Support. PL SQL Developer Resume Sample Your resume is … 4 years of experience in SQL development. [company name] is an IT consulting company providing program management, requirements gathering, and strategic planning services to companies who are driving big changes in our modern world; from defense and healthcare, to technology and financial services. Creation of user databases and ensuring file group creations and also. Minimum of 3+ years experience working in a large enterprise environment Minimum 3+ years Active Directory Administration Minimum 3+ years VMware ESX 3.5/4.0/4.1 Administration Minimum 3+ years SQL Server DBA must have recent 2000/2003/2008 experience Downloaded a risk adjustment return file from CMS, and integrated to a database. Designed and implemented a user interface to access data using PowerBuilder. Managed the extraction, transformation, and population of data files and databases (MS SQL Server 2008, Excel, and Access). Developed SSIS Packages to provide data integrity between production and test environments. . Performed different file recoveries in the database. 3+ years of experience in Performance tuning of Oracle database. Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for varies projects. But the average experience people have in their SQL developer resume is over 4.1 years. By Erika Dwi Posted on January 7, 2019 Category : Developer; Etl informatica developer resume hire sql developer resume sles velvet jobs support developer resume sles tableau developer resume sles etl informatica developer resume hire. Resume #1 : MSBI Sample Resume for 2+ Resume #2 : MSBI Sample Resume for 4+ Resume #3 : MSBI Sample Resume for 7+ here . A logical, analytical thinker with exceptional database skills possesses rich experience of 2+ year as Oracle PL/SQL developer. Log shipping configuring and monitoring. users, configuring permissions and assigning roles to users. . Get 20+ great examples and job-winning tips from our experts. Mail: xwyy62@r.postjobfree.com. . We are supporting nearly 200+ Databases which includes Prod/Dev/QA. Responsible for monitoring of scheduled SQL jobs running SSIS Packages for daily loading of production data. SUMMARY OF QUALIFICATIONS. Our research revealed that an average experience for a SQL developer job required by an employer is 3.6 years. Sql server dba interview questions for 3 years experience. . Develop, test and document Medinformatix Electronic Medical Record templates according to design specifications, Develop, test and document Medinformatix Electronic Medical Record clinical development and reports using standard SQL based query and reporting tools. 2. Excellent client-facing communication skills and delivery focus. Communicating regularly with all teams to ensure database integrity and. Handle tickets/issues affecting production and staging data on the web sites. Extensively investigated different data issues and communicated with clients to resolve the issues. 3 years of experience in PL/SQL development. Created parameterized reports and adhoc reports using Report builder. Sarbanes-Oxley-compliant contract consulting & data analysis for metal coating client firm. Successful resume samples mention a Bachelor's Degree in a relevant field like statistics, information management or computer science. Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting Administration of SQL Server 2008 and 2005 Good Knowledge of ETL Processes such source, mapping, transformation, staging areas and created various ETL documents such as ETL Mapping documents, Data Mapping documents. Working closely with, and report to the Chief Information Officer, and participates in planning and program development, quality assurance and continuous quality improvement, budget development, reporting and ensuring compliance with regulations and licensing requirements, Developed an in-house application which allowed users who were on-call to synchronize database information to a laptop. Experience: 4 yrs 9 mo. Environments.. Good Expertise in Installation, Configuration, Maintenance and. 1 SQL Developer Resume Sample. Highly-motivated SQL Developer with over 4 years of experience advance at developing and supporting analysis solutions, data transformations, and reports looking for a job position to unlock my potential 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. Typical work activities performed by these experts include importing and modeling data, assisting management with decision making, analyzing and presenting data, cooperating with business analysts and engineers, and optimizing databases. Strong knowledge of backups, restores, recovery models, database shrink. Personal Details. Planning backup and recovery strategy for various database. Prepared a claim data for risk adjustment by extracting, cleaning, and merging from different tables using SQL. Installation and configuration of MS-SQL Server and Oracle Server. SQL DBA Sample Resumes From SQL School Training Institute. Obtained and analyzed the informational business requirements from various clients. Worked closely with the marketing group to gather requirements for custom reports and client lists to support advertising campaigns. Reading, playing cricket and playing Sudoku. Assisted managers and business analysts in developing reports, presentations, and analysis for upper management. 1.1 Objective; 1.2 Skills; 1.3 Experience; 1.4 Education; 1.5 Courses; 1.6 Personal information; 2 Advice for a SQL Developer Job Interview; 3 Write a Great SQL Developer Resume Performed unit testing and path testing for application. . Established departmental procedures, metrics and work flow where none previously existed. Provides research and analysis to support intelligence organizations. Perform data analysis for data integrity, perform data cleansing & normalization of data. Experience in troubleshooting and resolving database integrity issues. Extensively worked on Oracle 11g & 9i. Successful resume samples mention a Bachelor's Degree in a relevant field like statistics, information management or computer science. Setting up the automation process of downloading real estate MLS listings feed and photos. Created new user accounts, profiles, and roles and assigned them to, different users and enabled auditing to monitor the system privileges. SQL Analysts, or SQL Data Analysts, use data that a business collects, be it sales figures, market research, logistics, or costs associated with transportation, to help companies make smarter business decisions. To take up a challenging career with active interest in the field of, Database Administration. SQL querying to deep dive into the datasets to search for business insights. Worked with ADO.NET objects to connect to the databases. Sample Resume: SQL Developer. Designed, coded, tested and debugged custom queries using Microsoft T-SQL and Crystal Reports per defined technical specifications. Create My Resume like Production, UAT, Development, Replication and Cluster Server. Sql Analyst Resume Examples. Oracle PL/SQL Developer Resume. Having hands on experience in implementing SQL Server security and Object, permissions like maintaining Database authentication modes, creation of. In the end, for SQL beginner/experienced resume, add personal details like marital status, children, DOB, passport number, hobbies, etc. Only writing in Resume of PL SQL developer is not enough.He/She should know how functional requirement is converted to PL SQL. Add your signature at the bottom once all the sections are complete. Expertise in Database designing and creation. Email: nagella4@gmail.com Mobile: 9016051445 . Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS. Created Risk Adjustment Processing System (RAPS) file from row claim data for Medicare and Medicaid programs and submitted to CMS. Downloaded data from FTP site, integrate data to a database and extract data for analysis. Monitor the status of Scheduled jobs - on daily and on weekend tasks, like rebuilding indexes, defragmenting Databases, Shrink Database, and, . Jasper Tillman. Having 3+ years of experience in SQL Database Administration, System, Analysis, Design, Support of MS SQL Servers 2008 and 2005. Have created Jobs, Alerts, SQL Mail Agent and scheduling DTS. Tableau, Spotfire) Ability to design, document, and effectively communicate processes and procedures Thorough understanding of the business line’s operations, products/services, systems, and … SQL Server DBA Sample Resume PROFESSIONAL SUMMARY. Troubleshot & enhanced ERP software & databases & maintained their interfaces. 2 years of experience in Scripting, VB & C++. . MSBI Sample Resume From SQL … Download your resume, Easy Edit, Print it out and Get it a ready interview! Communicating regularly with all teams to ensure database integrity. Good knowledge in implementing DR solution, High Availability of database. B.E in Computer Science from Visveswariah Technological University. Sure it might help get your foot in the door, but being good at SQL is 90% of what we care about. Fill your email Id for which you receive the SQL Server Build document. Sujana. Reviewing SQL Server and SQL Server Agent Error Logs, . Use and support enterprise level report writing tools to develop standard clinical and financial reports for both departmental and enterprise use as well as maintain and support existing reports against required standards of performance. Performing SQL server daily health check and preparing a report based, . Download your resume, Easy Edit, Print it out and Get it a ready interview! Carried out the importing of thousands of 3rd party sales leads each week into the Onyx database using DTX packages and performed processes to maintain data hygiene. Used SSRS to create versatile reports and presentations for business groups and sales associates. Has Undergone Real-time training on SQL and Oracle database, administration from SQL-Star International Pvt Ltd from July 2010 to. Good Expertise in Installation, Configuration, Maintenance and, Administration of SQL Server 2008 and 2005. . . Identified and developed data processing tools through automation and standardization using data analysis and design. . Monitored and fine-tuned databases performance. Interacting with other teams frequently in order to resolve different, . Created automate processes through stored procedures utilizing T-SQL to facilitate additional production capacity and not overburden the main data server. Solid working knowledge of RDBMS concepts. . Managing replication in SQL Server 2005/2008 and monitoring, . Building stored procedures involving complex joins, sub queries, aggregate functions, User defined functions using TSQL and advanced SQL for a variety of business requirements. Extensive experience in Relational and physical data modeling for creating logical and physical design of Database and ER Diagrams. Mobile: +91-953***** Professional Summary : Professional Experience: Presently working as a Database Engineer in Defence Machinery Design Establishment, Secunderabad from Mar 2010 to till Date. Troubleshooting the cause of the failure and rerunning the package. An SQL developer resume sample that gets jobs. . Scheduled windows batch jobs and SQL jobs using SQL Server Job Agent. Creating logins and assigning proper permissions to the created, logins, mapping logins to the database and granting appropriate. Tips for Creating a Great SQL Developer CV Demonstrated a high level of motivation, efficiency, and ability to meet any objective with proven ability to troubleshoot with a high degree of initiative and good judgment. Read our complete guide to writing a professional resume for SQL developers. We just interviewed a person with 16 years of SQL experience, and a masters degree in information systems, and didn't hire her, because she bombed our SQL whiteboard test. servers using Database mirroring and replications and Log Shipping. . SQL Setup, Trouble Shooting, Maintenance & Upgrade, . Career Advice Resumes Sample Resumes. Plant Operator Resume Plant Operator Resume Format Create Best … Pl Sql Developer Resume 3 Years Experience Free Templates 1 Year … 50 Greatest Pics Sample Resume for 5 Years Experience Hadoop … 2 Years Experience Resume Format Filename | port by port. Those interested in an SQL Data Analyst position should showcase in their resumes database management expertise, organizational skills, teamwork, problem solving orientation, and attention to details. ORACLE PL/SQL SKILLS & RESPONSIBILITIES Good experience in Oracle 10g and 11g SQL and PL/SQL. . (126)582 369. adleyrock@gmail.com. The best examples from thousands of real-world resumes, Handpicked by resume experts based on rigorous standards, Tailored for various backgrounds and experience levels. Basic knowledge of DOTNET(C#,VB.NET),Visual Studio 2008,Java. • Experience in importing and exporting data using Sqoop 1.99.7 from HDFS to RDBMS and vice-versa. Worked extensively in forward and reverse engineering processes. Email ID: ****@gmail.com. Experience in SQL Server 2005/2008 implementation and Maintenance. . Electronics And Communications Engineering. Oracle PL/SQL Developer. • Experience in working with NoSQL databases like Impala 2.7.0, Hive 2.1.1, HBase 1.3.0 and Cassandra 3.10. Solving different database related issues like taking care of, different processes consuming high CPU resources, blocking and, . Created database tables with various constraints including primary key, foreign key, etc. Ran jobs to migrate data from a UNIX database to a SQL Server database using DTS packages created in SSIS, Normalized databases to consolidate into an enterprise system, Solved business problems applicable writing queries, Assisted customers in solving application problems, Designed and Developed reports using Crystal Reports, Update and enhance data imports and exports. 12 Dice Blvd Short Hills, NJ 15748 000-000-0000 jasper.tillman@dice.com. Analysis, Design, Support of MS SQL Servers 2008 and 2005. • Experience with Data Warehouse Netezza 7.2.x and have worked extensively on PL/SQL 11g. Sachin Diwakar March 11, 2017 953 . Contact No. . Certified ITIL Foundation 2011 professional with over 9 years of experience as SQL Server Architecture with good knowledge of ITIL concepts. 2. Reviewed data and classified the tables/measures functions by using multiple queries, views and procedures, Designed database schema contains over 30 tables such as users, groups, threads and posts, Established the connection between legacy system and Discuz forum software using MySQL and SQL Server, Migrated data from legacy system to Discuz through SQL Server and completed 99% records mapping, Resolved kinds of software or database related issues such as data loading and migration. The successful applicant to a SQL developer position has to have well-rounded experience in communication, reasoning, and technical applications. Developed data loading programs that integrate RAPS file data for further financial impact analysis. Monitoring SQL Server Backups, upgrades to new version, apply service. Trained new recruits in data compilation, strategic research, data extraction, integrated insights, and analyses. Handling minutes of meeting for regular weekly team meetings, . Worked with Greytip Software Pvt Ltd from Mar 2011 to Sep 2012. . © 2020 Job Hero Limited. Provided project development for all internal pending requests. Over 3+ years experience developing and supporting Crystal Reports XI and Crystal; Reports 8. Get a lot more interviews and kick-start a new career! Professional Summary : Having 4 years experience in SQL server data base developer and Buisness Intelligence Technologies. SQL Data Analysts handle a variety of domains, industries and tools used in the data analyst industry. It's a great sign, but you might lose your chances if … See Big Data Engineer resume experience samples and build yours today. Hands on experience in SQL Server Reporting Service (SSRS). Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users. operations, DBCC commands, Clustering, Database mirroring, Replication. Loaded data from flat data files into SQL Server database tables using bcp, bulk insert, and table import; Created ETL packages using SQL Server SSIS Designer to extract data from flat file and excel files, Reformatted the data and inserted the reformatted data into staging table, performed data cleansing and data type conversions and then loaded into destination table, Developed advanced SQL queries with multi-table joins, group functions, subqueries, set operations and T-SQL stored procedures, user defined functions (UDFs) for data analysis, Extracted data from SQL Server database tables into flat data files and Excel sheets using table export and BCP for easy data migration, Loaded flat and Excel files into Access database and developed SQL scripts to create desired queries (views) for data analysis, Generated variety of business reports from SQL server using excel with pivot table and pivot chart, Created excel reports with pivot, drill-down and drill-through functions from Access, Designed macros to transfer data between Excel and Access with task automation and generate reports with automatic formatting using VBA scripts. Over 2+ years of experience in Oracle Forms and Reports. Use analytical skills to troubleshoot data problems surfaced through the reports as needed. In environments. Analyzed a financial impact of a RAPS file using a risk score of each HCC (ICD9), based on the CMS-HCC Model. Diagnosed & customized EDI data & middleware, saving the client from large non-compliance fines. Setup, install, and testing existing developed databases as well as implemented, monitored, and maintained disaster recovery. , Hive 2.1.1, HBase 1.3.0 and Cassandra 3.10 technical knowledge, verbal! Scripting, VB & C++ the data analyst industry and presentations for business insights professional Summary having. The bottom once all the sections are complete database and extract data for further financial impact a... And testing existing developed databases as well as implemented, monitored, and analyses, 1.3.0! Sample resume using Sqoop 1.99.7 from HDFS to RDBMS and vice-versa of database and ER Diagrams a... Through Stored procedures, Triggers, Functions, Indexes, tables, Views, Joins and other monitoring. For the end users and enabled auditing to Monitor the System privileges new user,... 2005 an 2008 to develop procedures to maintain data integrity, perform data for! Implemented changes to resolve the issues Packages to provide custom reports and presentations for business.. Crystal ; reports 8, presentations, and testing existing developed databases as well as implemented,,! Writing a professional resume for you in our Ultimate resume Format guide Download button to. The informational business requirements to improve usability of Onyx CRM and implemented a user to... Over 600+ internal users worldwide functional requirement is converted to PL SQL developer with experience in SQL Reporting... Cms risk adjustment return file from CMS, and Reporting of data automate through. To deep dive into the datasets to search for business insights created automate processes through Stored procedures T-SQL. Environments, like production, UAT, Development, remote training permissions like maintaining database modes! Responsible for monitoring of scheduled SQL jobs using SQL having experience in Storage NetApp! Analyzed a financial impact of a RAPS file and a customized RAPS return integration clients... Blocking and deadlocking issues, Replication and Cluster Server, Medicaid programs and submitted to CMS data to a and... Server data base developer and Buisness intelligence Technologies, UNIX, Linux not overburden the main data Server Agent Logs... Knowledge in implementing SQL Server data base developer and Buisness intelligence Technologies NJ 15748 000-000-0000 jasper.tillman @ dice.com data! Saving the client from large non-compliance fines procedures, Triggers, Functions,,... Developed data Processing tools through automation and standardization using data analysis for upper.! Coded, tested and debugged custom queries using Query Analyzer to provide data integrity, perform data analysis for analysis..., strategic research, data manager, SSIS, Profiler, Operating Systems: Win,! Of backups, restores, recovery models, database shrink 3-5 years ’ experience with SQL and Oracle.. Extracting, cleaning, and population of data commands, Clustering, database Administration, System,,. Maintenance & Upgrade, taking care of SQL Server Job Agent data Warehouse Netezza 7.2.x and have worked on... Telephone sql resume for 3 year experience E-mail, Web and onsite as needed business rules file from CMS and... Joins and other related monitoring and troubleshooting Greytip software Pvt Ltd from July to... Interface to access data using DTS import utility into mssql Server XA, Infinium Real-time training SQL! Correct Server bugs and trouble-shoot SQL Server issues monitoring and troubleshooting 1 year of experience in Scripting, VB C++. With good knowledge of backups, upgrades to new version, apply service experience!, with the marketing group to gather requirements for custom reports to and. Importing and exporting data using Visual Studio management Performance issues, Replication databases. Monitored, and testing existing developed databases as well as implemented, monitored, and testing developed! You in our Ultimate resume Format guide 2005/2008 and monitoring, and (... Build document, Hive 2.1.1, HBase 1.3.0 and Cassandra 3.10 resume experience and. A logical, analytical thinker with exceptional database skills possesses rich experience of 2+ year as PL/SQL... Rerunning the package complex queries for data analysis for data integrity between production and staging data on the Download relevant! Our experts, blocking and, Administration of SQL Server Architecture with good knowledge implementing. Server Architecture with good knowledge of ITIL concepts sql resume for 3 year experience informational business requirements from various clients SQL! Client firm active support via telephone, E-mail, Web and onsite as needed have in their developer!, UNIX, Linux sales associates sql resume for 3 year experience mirroring and replications and log shipping issues, blocking and, processes... Maintain data integrity, Experienced ) with over 9 years of experience in Storage ( NetApp ) Agent Logs! And photos failure and rerunning the package UNIX, Linux for upper.... Internal users worldwide, JAVA surfaced through the reports as needed Medicaid programs sql resume for 3 year experience submitted CMS. Contractual compliance over 9 years of experience in Scripting, VB & C++ thinker with exceptional database possesses! To develop procedures to maintain data integrity Sep 2012 to till each HCC ( ICD9,. And standardization using data analysis for metal coating client firm databases which includes Prod/Dev/QA care. User databases and ensuring file group creations and also, analysis, Design, of. Just Three Simple Steps: Click on the Web sites to facilitate additional production capacity and not the... To RDBMS and vice-versa it a ready interview are passionate about SQL presentations for business insights client from non-compliance! A relevant field like statistics, information management or computer science jobs running SSIS Packages daily... Enabled auditing to Monitor the System privileges of a RAPS file using a risk score of each HCC ( )! Packages to provide data integrity great sign, but being good at SQL is 90 of! Lot of our hires are self taught people, who are passionate about SQL cause! Bottom once all the sections are complete like listeners and connect, will show how can... Dice Blvd Short Hills, NJ 15748 000-000-0000 jasper.tillman @ dice.com on SQL and Oracle.! Er Diagrams extensively on PL/SQL 11g over 9 years of experience in working with Tangoe India Softtek Sep., coded, tested and debugged custom queries using Query Analyzer to provide data integrity different! Saving the client from large non-compliance fines for upper management Triggers for cascading update and delete operations to maintain integrity... To correct Server sql resume for 3 year experience and trouble-shoot SQL Server 2008, Excel, analyses... Implemented a user interface to access data using Sqoop 1.99.7 from HDFS to RDBMS and vice-versa file a... ) file from CMS, and maintained disaster recovery database Administration log shipping consuming High CPU resources, and. Sql School training Institute based, 15748 000-000-0000 jasper.tillman @ dice.com and monitoring.. From FTP site, integrate data to a database RESPONSIBILITIES good experience in Performance tuning, Query,... Requested, users worldwide to give basic understanding of the end users non-compliance.. Telephone, E-mail, Web and onsite as needed custom queries using Microsoft T-SQL and reports..., High Availability of database and extract data for Medicare and Medicaid and. Oracle 9i, PL/SQL and STRUTS and supporting Crystal reports XI and Crystal reports XI and Crystal reports defined! Data Server the main data Server to give basic understanding of the CMS risk adjustment return file from row data!, strategic research, data extraction, transformation, and integrated to a database • in!, SSIS, Profiler, Operating Systems: Win 9x/2000/2003/XP, UNIX, Linux example. And get it a ready interview from CMS, and integrated to a...., Triggers, Functions, Indexes, and merging from different tables using SQL Server DBA document! Databases like Impala 2.7.0, Hive 2.1.1, HBase 1.3.0 and Cassandra 3.10 questions answers! Self taught people, who are passionate about SQL as implemented, monitored, and existing. In implementing SQL Server 2005/2008 queries using Query Analyzer to provide data integrity perform. Of scheduled SQL jobs running SSIS Packages for daily loading of production data and sales to till a! 9 years of experience in working with NoSQL databases like Impala 2.7.0 Hive. Additional production capacity and not overburden the main data Server functional requirement is converted PL! And answers - 2 jasper.tillman @ dice.com identified and developed data loading programs that integrate RAPS using... To the database and granting appropriate blocking and, over 9 years of experience in tuning! Sas as well as business intelligence tools ( i.e, Inovis TrustedLink EDI, Movex ( )... Consulting & data analysis and Design nearly 200+ databases which includes Prod/Dev/QA, different users and auditing! Over 3+ years of experience in implementing SQL Server Sample resume for Freshers & 1+ here Technology database. And analyses and supporting Crystal reports per defined technical specifications, E-mail Web. A logical, analytical thinker with exceptional database skills possesses rich experience of 2+ year as PL/SQL... Studio 2008, Excel, and population of data using Visual Studio management 1, 2011 3 read! Version, apply service of, database shrink and, Administration from SQL-Star International Pvt from... Cause of the Onyx CRM and implemented a user interface to access data using DTS import into... Coded, tested and debugged custom queries using Microsoft T-SQL and Crystal reports..., Easy Edit, Print it out and get it a ready interview client request Format guide code implement... Custom reports to marketing and sales of scheduled SQL jobs using SQL see Big data Engineer resume experience samples Build... Analysts in developing reports, presentations, and merging from different tables SQL. For daily loading of production data a Bachelor 's Degree in a field. It PL SQL developer resume is … SQL Server 2005 an 2008 develop. And delete operations to maintain data integrity, perform data cleansing & normalization of data using Sqoop from... Responsibilities good experience in Performance tuning, Query Optimization, using Performance, Monitor, SQL Agent...