- Sqlpro Studio 1 0 163 – Powerful Database Manager Jobs
- Sqlpro Studio 1 0 163 – Powerful Database Manager Job Opportunities
- Sqlpro Studio 1 0 163 – Powerful Database Manager Job Description
- Sqlpro Studio 1 0 163 – Powerful Database Manager Job Openings
Top Skills Details 1. Expert level PL/SQL and T-SQL Development Experience 2. Expert level BI/Reporting experience - whether it be Power BI, Tableau, etc. Business-facing, ability to gather requ. Complete list of useful and must have add-ins for SQL Server Management Studio. This is a list of 35 SSMS add-ins updated on Jan 24, 2019.
JANINE SMITH, OCP
00 Brock Street | St. Louis, MO 63139 | (636) 000-0000 | email@email.email
Certified Database Administrator with experience in maintenance, security, and backup and recovery
SUMMARY OF QUALIFICATIONS
- Over 9 years of experience, including 6 years as DBA in development and production environments.
- Ensure Oracle database systems operate efficiently and securely.
- Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages.
- Manage internal databases, from planning and testing stages through implementation and support.
- In-depth understanding of security and backup procedures to ensure database integrity. Background in developing backup and disaster recovery plans for nationwide offices.
- Superior communication, presentation, analytical and problem solving skill. Work well with all levels of business.
TECHNICAL SKILLS AND CERTIFICATIONS
Databases: Oracle 7/8/9 (RAC/OPS), MS-SQL, MySQL, DB2, Universal Database V8.1, Access, Lotus Notes, SAP, DPF
Operating Systems: Windows 2000/2003/NT/XP, UNIX, Linux, Solaris
Applications: SQL-Loader, SQL Navigator, SSH, Forte for Java, Apache, IIS, Domino 4.x/5.x/6.x, ULTRADEV, Dreamweaver
Languages: Java, JSP, JDBC, XML, HTML, C, C++, Perl, VB, NET, ASAP.NET
Certifications: Oracle9i Database Administrator, IBM Certified Expert – DB2 Universal Database V7.1 Database Administration for UNIX, Windows, and OS/2
PROFESSIONAL EXPERIENCE
ABC Corporation, St. Louis, MO: 2005-Present
Senior Database Administrator
- Responsible for Oracle 9i logical and physical database design, implementation, and maintenance on Windows NT
- Created new databases and users: set up backups, export, and other monitoring scripts
- Implemented database refresh using full export for table level and full database defragmentation, resulting in improved performance and effective space management.
- Managing database security. Design, develop, and implement automated data backup and restoration procedures. Provide technical support for database maintenance and disaster recovery
- Identify, recommend, and implement all new database technologies and Oracle license management.
ABC Company, St. Louis, MO: 2003-2004
Database Administrator
- Created new databases, involving importing and exporting: installing and configured database software for Oracle Application development environment.
- Responsible for Oracle 9i logical and physical databases design, implementation, and maintenance
- Reorganized databases and sized database objects to meet standards and improve performance 30%
- Handled database server tuning, application tuning, maintaining documentation, capacity planning and database security
XYZ Company, St. Louis, MO: 2000-2003
Database Manager/Administrator
- Created Oracle 8i databases for 2 large departments, from planning and testing through production.
- Implemented backup and recovery procedures of databases in Sun Solaris and Red Hat Linux environment: implemented backup and recovery procedures and IT department manual.
- Managed database remodeling and interface development during migration from MS Access to MS SQL server and from MS SQL to Oracle 8i
- Enhanced MS-Access databases by improving user interface, introducing multiple-user access, and increasing security and stability
- Involved in all phases of database development, from needs assessment to QA/QC, design, and support
XYZ Incorporated, St. Louis, MO: 1997-1999
Database Manager/Administrator
- Held Oracle DBA responsibility for parallel Oracle/SAP database using Oracle Parallel Server
- Supported Oracle developers. Performed database tuning, created database reorganization procedures, scripted database alerts, and monitored scripts
EDUCATION
Bachelor of Science, Computer Science, St. Louis University (1995)
TRAINING
Oracle9i: New Features for Administrators
Oracle9i: Real Application Clusters
Oracle8i: Introduction to oracle SQL, PL/SQL
Oracle8i: Architecture and Administration
Oracle8i: Backup and Recovery
Oracle8i: Performance Tuning
Oracle8i: Network Administration
Oracle8: Database Administration
Oracle8: Backup and Recovery
Oracle Enterprise Manager
Oracle8: New Features for Administrators
Oracle8i: New Features for Administrators
Oracle 8: SQL and PL/SQL
Upload Your ResumeEmployers want candidates like you. Upload your resume. Show them you're awesome.
By: Divya Agrawal | Updated: 2009-04-15 | Comments (10) | Related: More >SQL Server Agent
Problem
Every database person might have come across the situation of maintenance tasks such as backing up of databases, re-indexing tables and other such tasks. We often schedule jobs for such tasks, so that they execute as per the set schedule. But there is sometimes the need for these tasks to be executed 'On Demand'. This tip shows various ways of executing such tasks on demand by any user regardless of whether the person is technical or not.
SolutionLet's say I have a job called 'BACKUPTEST' which backups the test databases. I want to be able to execute the job 'On Demand', so whenever anyone needs to do the backup this can be done. In this article I will show you how you can execute such Jobs easily through various ways.
In this tip we will look at these four methods:
- SQL Server Management Studio
- T-SQL commands
- DMO (Distributed Management Objects)
- OSQL
Also, this tip assumes that the jobs have already been setup.
(1) - SQL Server Management Studio
The first way that most people are probably aware of is to use SQL Server Management Studio.
SQL Server Agent is the job scheduling tool for SQL Server.
To execute a job on demand using the GUI, open the SQL Server Agent tree, expand Jobs, select the job you want to run, right click on that job and click ‘Start Job' and the job will execute.
(2) -T-SQL commands
The second way is through a T-SQL statement using the 'sp_start_job' stored procedure which instructs SQL Server Agent to execute a job immediately. It is a stored procedure in the 'msdb' database.
The syntax for the sp_start_job stored procedure is:
Arguments:
| [@job_name] | [@job_id ] | Is the name of the job to start. Either job_id or job_name must be specified, but both cannot be specified. job_name is sysname, with a default of NULL. |
| [@error_flag =] error_flag | Reserved. |
| [@server_name =] 'server_name' | Is the target server on which to start the job. server_name is nvarchar(30), with a default of NULL. server_name must be one of the target servers to which the job is currently targeted. |
| [@step_name =] 'step_name' | Is the name of the step at which to begin execution of the job. Applies only to local jobs. step_name is sysname, with a default of NULL |
| [@output_flag =] output_flag | Reserved. |
When a job run it will have one of two return codes:
- 0 (success)
- 1 (failure)
To run the job ‘BACKUPTEST' it can be executed by a single T-SQL statement: such as:
(3) -DMO (Distributed Management Objects)
Another way of executing the job is through a VBS script using Distributed Management Objects (DMO).
Here is the basic script syntax.
Here is sample executing the 'BACKUPTEST' job on server 'SQLTEST1'. This uses NT authentication to run this script.
This code would then be saved in a file and named something like 'RunJob.vbs'. You can then double click on the file to execute it or run the code from a command line.
(4) - Using osql utility
Lastly, we can start the job using osql commands.
The osql utility allows you to enter T-SQL statements, system procedures, and script files.
Here is the basic script syntax.
Open a command prompt and execute the below osql command in it:, replacing your server name and job name.
The next step is to make a batch file which can be run over and over again.
Open notepad and type the commands as follow:
Save the file as 'job.bat'.
The batch is now ready for use. Just double click on it and it will do the maintenance work without having any knowledge of SQL Server.
Permissions
You might have noticed in all the four solutions the msdb stored procedure ‘sp_start_job' is used in one way or another.
XYZ Incorporated, St. Louis, MO: 1997-1999
Database Manager/Administrator
- Held Oracle DBA responsibility for parallel Oracle/SAP database using Oracle Parallel Server
- Supported Oracle developers. Performed database tuning, created database reorganization procedures, scripted database alerts, and monitored scripts
EDUCATION
Bachelor of Science, Computer Science, St. Louis University (1995)
TRAINING
Oracle9i: New Features for Administrators
Oracle9i: Real Application Clusters
Oracle8i: Introduction to oracle SQL, PL/SQL
Oracle8i: Architecture and Administration
Oracle8i: Backup and Recovery
Oracle8i: Performance Tuning
Oracle8i: Network Administration
Oracle8: Database Administration
Oracle8: Backup and Recovery
Oracle Enterprise Manager
Oracle8: New Features for Administrators
Oracle8i: New Features for Administrators
Oracle 8: SQL and PL/SQL
Upload Your ResumeEmployers want candidates like you. Upload your resume. Show them you're awesome.
By: Divya Agrawal | Updated: 2009-04-15 | Comments (10) | Related: More >SQL Server Agent
Problem
Every database person might have come across the situation of maintenance tasks such as backing up of databases, re-indexing tables and other such tasks. We often schedule jobs for such tasks, so that they execute as per the set schedule. But there is sometimes the need for these tasks to be executed 'On Demand'. This tip shows various ways of executing such tasks on demand by any user regardless of whether the person is technical or not.
SolutionLet's say I have a job called 'BACKUPTEST' which backups the test databases. I want to be able to execute the job 'On Demand', so whenever anyone needs to do the backup this can be done. In this article I will show you how you can execute such Jobs easily through various ways.
In this tip we will look at these four methods:
- SQL Server Management Studio
- T-SQL commands
- DMO (Distributed Management Objects)
- OSQL
Also, this tip assumes that the jobs have already been setup.
(1) - SQL Server Management Studio
The first way that most people are probably aware of is to use SQL Server Management Studio.
SQL Server Agent is the job scheduling tool for SQL Server.
To execute a job on demand using the GUI, open the SQL Server Agent tree, expand Jobs, select the job you want to run, right click on that job and click ‘Start Job' and the job will execute.
(2) -T-SQL commands
The second way is through a T-SQL statement using the 'sp_start_job' stored procedure which instructs SQL Server Agent to execute a job immediately. It is a stored procedure in the 'msdb' database.
The syntax for the sp_start_job stored procedure is:
Arguments:
| [@job_name] | [@job_id ] | Is the name of the job to start. Either job_id or job_name must be specified, but both cannot be specified. job_name is sysname, with a default of NULL. |
| [@error_flag =] error_flag | Reserved. |
| [@server_name =] 'server_name' | Is the target server on which to start the job. server_name is nvarchar(30), with a default of NULL. server_name must be one of the target servers to which the job is currently targeted. |
| [@step_name =] 'step_name' | Is the name of the step at which to begin execution of the job. Applies only to local jobs. step_name is sysname, with a default of NULL |
| [@output_flag =] output_flag | Reserved. |
When a job run it will have one of two return codes:
- 0 (success)
- 1 (failure)
To run the job ‘BACKUPTEST' it can be executed by a single T-SQL statement: such as:
(3) -DMO (Distributed Management Objects)
Another way of executing the job is through a VBS script using Distributed Management Objects (DMO).
Here is the basic script syntax.
Here is sample executing the 'BACKUPTEST' job on server 'SQLTEST1'. This uses NT authentication to run this script.
This code would then be saved in a file and named something like 'RunJob.vbs'. You can then double click on the file to execute it or run the code from a command line.
(4) - Using osql utility
Lastly, we can start the job using osql commands.
The osql utility allows you to enter T-SQL statements, system procedures, and script files.
Here is the basic script syntax.
Open a command prompt and execute the below osql command in it:, replacing your server name and job name.
The next step is to make a batch file which can be run over and over again.
Open notepad and type the commands as follow:
Save the file as 'job.bat'.
The batch is now ready for use. Just double click on it and it will do the maintenance work without having any knowledge of SQL Server.
Permissions
You might have noticed in all the four solutions the msdb stored procedure ‘sp_start_job' is used in one way or another.
Sqlpro Studio 1 0 163 – Powerful Database Manager Jobs
By default, members of the sysadmin fixed server role can execute this stored procedure.
Other users must be granted one of the following SQL Server Agent fixed database roles in the msdb database:
- SQLAgentUserRole
- SQLAgentReaderRole
- SQLAgentOperatorRole
Sqlpro Studio 1 0 163 – Powerful Database Manager Job Opportunities
Members of SQLAgentUserRole and SQLAgentReaderRole can only start jobs that they own.
Members of SQLAgentOperatorRole can start all local jobs including those that are owned by other users.
Members of sysadmin can start all local and multiserver jobs.
For details about the permissions of these roles, see SQL Server Agent Fixed Database Roles. and SQL Server Agent Fixed Database Roles
Next Steps- Although this tip shows four ways of starting a job there are other options as well. You could also look into using SQL Server Management Objects (SMO) and sqlcmd.
- For more information about SQL Agent take a look a these other SQL Agent tips
Last Updated: 2009-04-15
Sqlpro Studio 1 0 163 – Powerful Database Manager Job Description
About the author
Sqlpro Studio 1 0 163 – Powerful Database Manager Job Openings
View all my tips
